Oracle 26ai Autonomous Database

I decided I needed to learn more about Oracle 26, Autonomous Database, Oracle Cloud Infrastructure, JSON, REST services, HTTP, etc.  

The Project

I returned to a small project originally created to learn about spatial data, and migrated it to an Oracle 26 Autonomous database in Oracle Cloud Infrastructure (OCI).  Originally, I loaded a physical export of my Strava data to create a spatial search to find out when I had cycled through a particular place.  Now, I have interfaced it directly with Strava, both receiving new activity information through a REST service and both receiving and sending information in JSON format through the Strava API.  All the code is on GitHub.

Chat GPT

The project has made me use techniques and technologies that I have never used before.  Following a suggestion from a colleague, I started to use ChatGPT, asking questions in plain language about the details of both Oracle 26 and the Strava API.  It gave me sensible answers with both code examples and descriptive text.  It even designed complete processing flows for my project.  I have no doubt that I got further and got there much faster than I ever would with just the Oracle manuals and Google.

AI will not replace developers and administrators, at least not yet, but we may be replaced by someone who is more productive because they are using AI!

  • See Blog: Oracle Development with ChatGPT

Blog Posts

The project has produced a number of blog posts.  Links will appear here as posts are published.  This page will serve as an index.

  • Oracle 26ai
    • Returning Clause on Merge
  • Autonomous Database
  • OCI
    • Datapump Export/Import from Autonomous Database to OCI Storage Buckets
  • JSON
    • Loading JSON into the database with PL/SQL
  • HTTP
    • Access Control Lists 
    • Get, Put and Post
    • Reading Headers
    • Character sets
  • Spatial Data
    • Loading GeoSpatial Data into Autonomous Database
    • Reading GeoJSON
    • Public sources of GeoJSON.  Strategies for handling areas that don't match
    • Handling Conversion Errors
  • Rest Services
    • Reading Parameters
    • Testing with Curl