PinnedMy new homeWARNING: Turn back now. You have been warned. Latest Developments I’m Chris Hoina. Senior Product Manager at Oracle as (still not sure why they hired me, most likely a clerical error). I’m a recent “Big Blue” defector; at IBM for nearly three years. There I worked in IBM Z (the mainframe, Big…Oracle3 min readOracle3 min read
Published inDev Genius·Apr 25Oracle Database REST APIs and Apple Automator Folder ActionsThe 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). …Applescript7 min readApplescript7 min read
Published inDev Genius·Apr 5Python and the Oracle Autonomous Database: Three Ways to ConnectWatch the deep dive videos: Part I Part II 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. …Rest Api14 min readRest Api14 min read
Published inDev Genius·Jan 27Podman, Oracle Container Registry, and SQLclContainers are kind of like terrariums. Intro to Podman, man What is Podman? Podman is a daemonless container engine for developing, managing, and running OCI Containers on your Linux System. Containers can either be run as root or in rootless mode. Simply put: alias docker=podman. the deets I’ve spent the past couple of weeks…Podman19 min readPodman19 min read
Published inDev Genius·Jan 17Where to learn SQL: a Slack messageWhat 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. …Sql4 min readSql4 min read
Published inDev Genius·Jan 4An intro to using Oracle SQLcl on MacDid you know you can use Homebrew to install Oracle’s SQLcl on Mac? I just realized this about a week ago (always the bridesmaid never the bride…amirite??). Homebrew First you’ll need to install Homebrew (I’m sure there are other ways to install SQLcl, but installing through Homebrew was a breeze). You…Command Line7 min readCommand Line7 min read
Published inDev Genius·Dec 9, 2022Using Python Pandas to turn ISO Country Codes into a string to use as values for a SQL QuerySummary, 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. …Python8 min readPython8 min read
Published inDev Genius·Nov 22, 2022More fun with Medium story stats, JSON, Python, Pandas, and Oracle SQL Developer WebThat’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…Python10 min readPython10 min read
Published inDev Genius·Sep 26, 2022Fun with Python GET requests, Medium stats, and the Oracle Autonomous DatabaseI 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 actually got something to work that I had to share! If you’ve been following along, you know you can always find me…Python6 min readPython6 min read
Sep 22, 2022Oracle REST APIs: A LiveLabs reviewRecently 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.” You can access the workshop here. We spent about 90 minutes moving through selected labs…Oracle Cloud3 min readOracle Cloud3 min read
