Here is what you can do with the Oracle REST Data Services (ORDS) 3.0 release to provide new generation database access to Oracle and accomplish the goals laid out in the last post:
In the next series of blog posts I'll go through each of these in more detail. First, I'll cover the installation of Oracle REST Data Services which is now much easier with the 3.0 release.
- Create some simple Oracle microservices that can be easily accessed using new generation tools, i.e., through simple REST calls that return JSON data. No client software to install. No TNS to futz with. No SQL required. You can use the new ORDS 3.0 autogenerate feature set up simple queries, e.g., SELECT * and primary key lookup, and basic insert and update operations. You can also write SQL and PL/SQL which the REST calls can invoke to do fancier stuff.
- Next have your new generation developers try the new ORDS 3.0 filter capability to execute a little fancier queries and simple sorts from the new generation world. i.e., without SQL and without the hassle of getting you involved. Queries and sorting can be specified with a simple JSON document submitted by the REST POST call using a kind of query-by-example approach.
- Show that agile, schema-less or schema-last development is now possible with Oracle Database 12c which enables the database to be a JSON document store.
In the next series of blog posts I'll go through each of these in more detail. First, I'll cover the installation of Oracle REST Data Services which is now much easier with the 3.0 release.