Category: Languages

  • 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
  • Working with WTForms and Oracle REST Database Services (ORDS) APIs

    , ,

    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…

    Current Flask application, made presentable by using Bootstrap for HTML and CSS
  • Clean up a .CSV file with Regular Expressions, Pandas, and Python

    ,

    I want to load data via Database Actions in my Oracle Autonomous Database, but first I need to clean up some Dates and Times. Python is my language of choice, and I’ve heard about Regular Expressions, but I’m scared…

    A-more-formal-pattern-for-Regular-Expressions-Database-Actions-Oracle-Autonomous-Database-Chris-Hoina-Senior-Product-Manager-ORDS-Database-Actions
  • GET requests with Python, ORDS, and the Oracle Autonomous Database

    ,

    I needed an approach that would make me question my life decisions. Something that would force me to rethink what it meant to be human.

    Objects-in-SQL-Worksheet-in-Oracle-Autonomous-Database-Chris-Hoina-Senior-Product-Manager-ORDS-Database-Tools-
  • Project Overview: python – flask – ORDS – Autonomous Database

    , ,

    Update For the past week and a half I’ve been immersed in learning how python and flask interact with each other so a developer can create a quick/crude web application. I’ve also spent time becoming more familiar with virtual environments (as they pertain to python + flask), jinja, and WTForms (I’m sure I’m forgetting other…

    Explaining-my-python-flask-Autonomous-Database-and-ORDS-API-project-1