Category: Python

  • From one API to another: Using ORDS Auto-REST to update a table

    , , , , , , ,

    I think in this new age of AI/LLMs it is important to understand prompting. Eventually, whether we like it or not, we’ll all need to become “prompt engineers.” And as you’ll see in that thread, you actually have to know what you are doing to be able to ask the right questions and to challenge…

  • Python script to retrieve objects from Oracle Cloud Bucket

    , , ,

    For…reasons, I needed a way to retrieve all the .CSV files in a regional bucket in Oracle Cloud Object Storage, located at this address: https://objectstorage.us-phoenix-1.oraclecloud.com/n/dwcsprod/b/moviestream_data_load_workshop_20210709/o You can visit it; we use it for one of our LiveLabs (this one), so I’m sure it will stay live for a while 😘. Once there, you’ll see all…

  • Python and the Oracle Autonomous Database: Three Ways to Connect

    , , , ,

    Watch the deep dive videos: Part I Part II Part III Welcome back I finally had a break in my PM duties to share a small afternoon project [I started a few weeks ago]. I challenged myself to a brief Python coding exercise. I wanted to develop some code that allowed me to connect to…

    summary-outut-from-sql-query-in-test1-python-file-chris-hoina-senior-product-manager-ords-oracle-rest-apis-autonomous-database-database-actions
  • Using Python Pandas to turn ISO Country Codes into a string to use as values for a SQL Query

    , ,

    Summary, code, resources Problem While querying a table (based on this dataset) with SQL, you realize one of your columns uses 3-character ISO Country Codes. However, some of these 3-character codes aren’t countries but geographical regions or groups of countries, in addition to the actual country codes. How can you filter out rows so you are left…

    pandas-to_html-printout-of-ISO-codes-table-chris-hoina-senior-product-manager-oracle-rest-apis-oracle-autonomous-database-sql-developer-web-ORDS
  • More fun with Medium story stats, JSON, Python, Pandas, and Oracle SQL Developer Web

    ,

    That’s right; I’m back again for yet another installment of this ongoing series dedicated to working with Medium.com story stats. I first introduced this topic in a previous post. Maybe you saw it. If not, you can find it here. Recap My end goal was to gather all story stats from my Medium account and…

    completed-csv-ready-for-oracle-autonomous-database-chris-hoina-senior-product-manager-oracle-rest-apis-database-tools-autonomous-database
  • Fun with Python GET requests, Medium stats, and the Oracle Autonomous Database

    , ,

    I feel so silly for posting this because you’ll quickly realize that I will have to leave things unfinished for now. But I was so excited that I got something to work, that I had to share! If you’ve been following along, you know you can always find me here. But I do try my best…

    Audience-Stats-in-Medium-Chris-Hoina-ORDS-Oracle-REST-Database-Actions-Oracle-Autonomous-Database
  • Python POST requests three ways with Oracle REST Data Services (ORDS)

    , ,

    The simple POST request It was bugging me that I couldn’t perform a simple Python POST request to an ORDS REST-enabled table. I don’t mean to convey that this isn’t possible. Up until very recently, I wasn’t able to do this. Luckily I had a few hours free, so I took to the docs to…

    Columns-in-POST-table-in-Oracle-Autonomous-Database-to-test-requests-in-Python-ORDS-Oracle-REST-APIs-Chris-Hoina-Product-Manager-Database-Actions-Database-Tools
  • Flask, Python, ORDS, and Oracle CloudWorld 2022

    , , ,

    Python, Flask, and ORDS Restaurants Web Application update If you’ve been following along, then you are probably aware of the python/flask/ORDS journey that I’ve embarked on. If not, you can read up on the overview here. The idea was to take local restaurant health inspection scores (aka Sanitary grades) and present the data to a…

    Las-Vegas-Oracle-CloudWorld-2022-Chris-Hoina-Senior-Product-Manager-ORDS-Database-Tools-photo-courtesy-of-parsamphotography
  • Python + Folium + Oracle REST APIs (aka ORDS)

    , ,

    Willkommen I stumbled upon a new [to me] python library called Folium. It’s a mapping tool that enables python developers (or is it programmers, which is less offensive?) to visualize data on a Leaflet map. About folium Folium makes it easy to visualize data that’s been manipulated in Python on an interactive leaflet map. It…

    Folium-Stamen-Toner-Python-ORDS-APIs-ADB-Chris-Hoina-Senior-Product-Manager-Database-Tools-Oracle-Autonomous-Database
  • Python or Filtering in Queries: sorting JSON responses from an Oracle Database

    ,

    Hey, at least now I know I won’t be restricted to what I can filter based on the python functions I do or don’t know. I can’t be the only one….right?

    URI-with-filering-in-query-from-ORDS-REST-API-enabled-table-Chris-Hoina-ORDS-Database-Tools-Oracle-Autonomous-Database