DBaaS Support by Major Cloud Vendors

PostgreSQL has been supported widely as a DBaaS. These services are coming from Amazon(Amazon Aurora PostgreSQL Serverless), Microsoft’s with its Azure Database for PostgreSQL, and Google’s Cloud SQL for PostgreSQL.

In comparison, Oracle is only available on Amazon RDS for Oracle. The services offered by the major players start at an affordable price and are very flexible to set up in accordance with your needs. This helps institutions and organizations to set up accordingly and relieve from its large cost tied up on the Oracle platform.

Advanced JSON Support and is Always Improving

JSON stands for JavaScript Object Notation.It is a lightweight format for storing and transporting data.It is often used when data is sent from a server to a web page.It is “self-describing” and easy to understand.

The JSON data-type was introduced in PostgreSQL-9.2. Since then, it has a lot of significant enhancements and amongst the major addition came-up in PostgreSQL-9.4 with the addition of JSONB data-type. PostgreSQL offers two data types for storing JSON data: json and jsonb. With jsonb, it is an advanced version of JSON data-type which stores the JSON data in binary format. This is the major enhancement that made a big difference to the way JSON data was searched and processed in PostgreSQL.