Using Python Pandas to turn ISO Country Codes into a string to use as values for a SQL Query

pandas-to_html-printout-of-ISO-codes-table-chris-hoina-senior-product-manager-oracle-rest-apis-oracle-autonomous-database-sql-developer-web-ORDS

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 … Read more

More fun with Medium story stats, JSON, Python, Pandas, and Oracle SQL Developer Web

completed-csv-ready-for-oracle-autonomous-database-chris-hoina-senior-product-manager-oracle-rest-apis-database-tools-autonomous-database

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 … Read more

Fun with Python GET requests, Medium stats, and the Oracle Autonomous Database

Audience-Stats-in-Medium-Chris-Hoina-ORDS-Oracle-REST-Database-Actions-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 … Read more

Oracle REST APIs: A LiveLabs review

Two-approaches-to-Oracle-REST-APIs-Chris-Hoina-Senior-Product-Manager-ORDS-Database-Tools-1

Recently Jeff and I were invited by the Oracle Developers and Developer Relations teams to do a walkthrough of a LiveLabs workshop, “How to Build Powerful and Secure REST APIs for Your Oracle Autonomous Database.” We spent about 90 minutes moving through selected labs in the workshop. Luckily they recorded it for us; you can … Read more

Python POST requests three ways with Oracle REST Data Services (ORDS)

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

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 … Read more

Python + Folium + Oracle REST APIs (aka ORDS)

Folium-Stamen-Toner-Python-ORDS-APIs-ADB-Chris-Hoina-Senior-Product-Manager-Database-Tools-Oracle-Autonomous-Database

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 … Read more

Working with WTForms and Oracle REST Database Services (ORDS) APIs

Current Flask application, made presentable by using Bootstrap for HTML and CSS

Welcome Back The title pretty much speaks for itself, and if you’ve been following along, you’d know that I’m working on a demo application that uses Flask (a web application microframework) connected to my Oracle Autonomous Database (ADB) via Oracle REST Data Services (ORDS) APIs. One of Flask’s strengths is that it allows you to … Read more

Updating VARCHAR2 fields in Oracle Database Actions

Developer-Radar-Chart, Chris Hoina, Senior Product Manager, ORDS, Database Tools

Update I’ve run into more problems with this python/flask/ords/adb app idea of mine. Turns out I’m too [developer] dumb to do some of the things that I’d originally envisioned. Now that I’ve become more familiar with python, flask, the Oracle Autonomous Database, and our Database Tools (like ORDS and Database Actions), I’m realizing that I … Read more