Blog

  • Podman, Oracle Container Registry, and SQLcl
    Containers are kind of like terrariums.
  • 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 … Read more
  • An intro to using Oracle SQLcl on Mac
    Did 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 can install Homebrew on … Read more
  • 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 … Read more
  • 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 … Read more