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 got further and reached my goal much faster than I would have 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 more productive because they are using AI!
Blog Posts
- Oracle 26ai
- Autonomous Database
- OCI
- Datapump Export/Import from Autonomous Database to OCI Storage Buckets
- JSON
- Loading and Processing JSON with PL/SQL
- Loading GeoJSON Format GeoSpatial Data into Autonomous Database
- HTTP
- Consuming Inbound HTTP Requests with REST Services
- Reading Parameters
- Testing with Curl
- Spatial Data
- Loading GeoJSON Format GeoSpatial Data into Autonomous Database
- Public sources of GeoJSON. Strategies for handling areas that don't match