Databases for Everyone: How I Spent a Year in the Dark Creating a Database Provisioning API

Databases for Everyone: How I Spent a Year in the Dark Creating a Database Provisioning API

Customer has developed a Platform as a Service solution built on top of Kubernetes. It is a platform for devops with a high degree of self-service with APIs for everything and automation everwhere.

There was this bottleneck though; the database.
That is , not the database itself, but all the hassle before it was available, and the configuration needed to use it.
After a lot of pressure the task fell on me to develop an automated solution to provision databases through an API.

This presentation is about lessons learned, both good and bad, issues to think through before you start on a similar project. The implemented API uses Oracle REST Data Services (ORDS) and PL/SQL and runs entirely in the database. During the project a lot of concerns regarding security and stability had to be answered.

About Øyvind

Øyvind Isene is an independent consultant living in Arendal, Norway.

He mainly works with the Oracle database, serving as both a DBA and a developer. He started as an Oracle DBA in 1997 and has managed Oracle on various Unix dialects, primarily on Linux.
These days, it’s more about the data, exploring them, and making life easier for others by implementing the right strategies in the database.

Øyvind enjoys analytics, performance optimization, troubleshooting, and assisting developers in working seamlessly with the database.