Challenge 3: ORDS API

Oracle REST Data Services demo using Autonomous Database

Comment

NOTE: This project is the unaltered result of the Oracle LiveLab for ORDS.

Inspiration

I'm interested in database work and I wanted to become familiar with Oracle's service infrastructure.

What it does

This project demonstrates the usage of the Oracle Rest Data Service and Autonomous Database. It includes a database with 3 columns and 2,097,148 rows of dummy data (all nullable VARCHARs) as well as an OAuth-secured REST API with:

  • an HTTP GET request handler for generating reports for all rows with matching values in col2 (page size 25)
  • an HTTP POST request handler for querying the number of rows with matching values in col2

How I built it

I followed the LiveLab instructions using an Autonomous Data Warehouse.

Challenges I ran into

  • CSV uploads don't work on Oracle Cloud in Firefox. I had to switch to Chrome.
  • Some of the instructions are unclear and misleading as written. For example, the OAuth implementation section suggests copying data that does not include the token necessary to complete the task.

Accomplishments that I'm proud of

I got around the token issue without external resources because I remembered how REST APIs and OAuth work from a class I took a year ago. It's nice to confirm I retained something useful!

What I learned

Modern tools for automatically generating REST APIs are much more efficient than coding by hand, but knowing what the code does is extremely helpful for troubleshooting.

What's next for Challenge 3: ORDS API

I may use it as a template to build a larger project or complete another challenge.

Built With

Share this project:

Updates