Category: Learning

  • ETags and Oracle REST APIs

    , ,

    About this post I explore ETags and how they can be used in cURL commands when interacting with Oracle REST APIs. I also discuss some of the performance benefits of using ETags. This is not exhaustive, but I hope it introduces you to ETags or reminds you of their existence! But first… LATE-BREAKING NEWS!! A…

  • User Guide: Oracle database in a Podman container, install ORDS locally, and access a SQL Worksheet on localhost

    , , ,

    Summary The title says it all. I’ve run through this about ten times now. But I’ll show you how to start a Podman container (with a volume attached) and install ORDS on your local machine. And then, once installed, we’ll create and REST-enable a user so that the user can take full advantage of Oracle…

  • Oracle Database REST APIs and Apple Automator Folder Actions

    , , ,

    The plan was to create an ORACLE REST endpoint and then POST a CSV file to that auto-REST enabled table (you can see how I did that here, in section two of my most recent article). But, instead of doing this manually, I wanted to automate this POST request using Apple’s Automator application… Me…two paragraphs…

  • 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
  • Podman, Oracle Container Registry, and SQLcl

    , , , ,

    Containers are kind of like terrariums.

    one-more-thing-chris-hoina-senior-product-manager-oracle-database-tools-oracle-cloud-ords-oracle-rest-apis-sql-developer-podman-sqlcl
  • Where to learn SQL: a Slack message

    ,

    What follows is a response I sent via Slack to one of our newest UX Designers. She comes to us by way of another sister business unit within Oracle. She was looking for some resources on where to learn/get better acquainted with SQL (Which for a UX and/or UI designer, I think is a really…

  • 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
  • Oracle REST APIs: A LiveLabs review

    ,

    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…

    Two-approaches-to-Oracle-REST-APIs-Chris-Hoina-Senior-Product-Manager-ORDS-Database-Tools-1
  • 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