Photo from

Since August 2020, the Autonomous Databases have seen a new member: Autonomous JSON Database. With it came the support of the new OSON format to efficiently store JSON documents while allowing for powerful analytics on it using modern SQL and the best performances on the market for this kind of data.

Now, this is definitely just the beginning of this data story since JSON data is everywhere today and one of the most used formats to exchange data across the world.

As such, it is time to see how one can effectively bring Open Data in the game and especially…

TL;DR — GraalVM 20.3.0 Native Image generated executables can be compressed by a factor of x3 to x4 using tools such as Ultimate Packer for eXecutables with very low impacts on the startup time. The DRAGON Stack manager, a Java CLI application, improves the developer experience because of the resulting perception: a lot of capabilities in less than 20 MB.

The first time I heard about data compression was a short time after I had my first PC where the hard disk was huge: 512 MB. …

Oracle Cloud Infrastructure Cloud Shell

In a previous post, I presented a quick way to do this using Python. Now is the time to make JavaScript or TypeScript developers happy as well!

To get started with your Always Free Autonomous Database, please read Todd’s post.

Then, click on the Cloud Shell icon in the upper right corner of your OCI (Oracle Cloud Infrastructure) web console. This opens a Linux shell right inside your browser! The first run might take more than one minute in order to configure it. You’ll have up to 5 GB of storage and numerous tools pre-installed…

Oracle Cloud Infrastructure Cloud Shell

Remember Todd’s post about creating your Always Free Autonomous Database? What’s next? How about starting to work with it using Python language?

In your OCI (Oracle Cloud Infrastructure) web console, click on the Cloud Shell icon in the upper right corner. This opens a Linux shell right inside your browser! The first run might take more than one minute in order to configure it. You’ll have up to 5 GB of storage and numerous tools pre-installed.

Oracle brings free training to the mass of newcomers, students, or even seniors wanting to improve their skills and discover new fields.

See the latest post around here.

One of the learning track is called Autonomous Database Explorer and it gives a clear overview of this cloud service from provisioning using the Always Free Tiers offering to the SQL Developer Web interface to Machine Learning…

Relatively short and going straight to the point this is one of the track you don’t want to miss :)

On the 13th of August 2020, Oracle announced the general availability of a “new” public cloud service: the Oracle Autonomous JSON Database.

Not so new indeed as it leverages the existing Oracle Autonomous Database platform running already the Autonomous Data Warehouse (aka ADW) and Autonomous Transaction Processing (aka ATP).

The idea behind this new service is to make available the Autonomous Database capabilities (multi-model support, zero administration, independently scale-out compute and scale-out storage infrastructure, 99.995% availability, self-patching, automatic-scaling, state-of-the-art security…) to the Web/Frontend/Backend/Full-Stack… developers while providing new innovations in the world of storing and processing hierarchical data, here JSON data.

Limitless possibilities

It has been like years that I wanted to connect these 2 state of the art technologies: Unity, THE video game platform and Oracle Autonomous Database, THE enterprise grade data platform. Bringing them together would indeed allow for any video game, mobile or VR/AR application… to benefit from always available data along all the capabilities of a modern, secure, scalable and resilient Multi-Model database.

But how to do that today?

It appears that some advances have been made lately when the Oracle Autonomous Database Cloud Service has been made accessible through REST API right at deployment time: the secret is called ORDS for Oracle REST Data…

During its annual event, Oracle Open World, Oracle delivered a new way to access Cloud Infrastructure: Always Free Tiers.

Basically, you end up with always free resources, not for 12 months but as long as the resources are used — your blog, your development environment, etc… — it remains available!

The cherry on the cake is that you even get access to the most advanced Database technology: the Oracle Autonomous Database.

Oracle second generation public IaaS named Oracle Cloud Infrastructure (or OCI) has an open source mindset. As such, delivery is really dynamic and new capabilities are added at a weekly if not daily pace.

In order to test rapidly these new capabilities OCI, proposes different SDKs (in Java, Python, Ruby and Go) for developers.

These open source SDKs are available on github such as the one for Java:

Enjoy the numerous examples!

Recently an interesting post was published comparing the free Oracle REST Data Services capability named “REST Enabled SQL” to GraphQL:

While GraphQL tends to remove REST APIs limitations, it is still far from what REST Enabled SQL allows to do: run complex SQL over HTTPS connection in a REST fashion with OAuth2 authentication and get just the rows and columns you need as JSON documents.

Combining ORDS with your Oracle Database Multi-Model capabilities and Oracle Big Data SQL just brings you any of your Data at hands using REST!

Loïc Lefèvre

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store