ODS - Announcing Support for Postgres Extensions

Today we are excited to announce Postgres extensions support for ODS which allows you to leverage your Postgres database features. Postgres extensions are available on all ODS instances without any additional cost.

You can enable or disable extension directly from the Online control panel or API. Following are listed the most popular extensions available:

hstore: To store sets of key/value pairs within a single PostgreSQL value. This can be useful in various scenarios, such as rows with many attributes that are rarely examined, or semi-structured data.

We also enable additional options for Mysql, MariaDB and PostgreSQL to offer you more flexibility. For MariaDB and MySQL, you can now override the default collation. For PostgreSQL, you can change the connection_limit which defines how many concurrent connections can be made to your database and the owner_to to change the database owner.

Demo

Requirements

To enable ODS extensions, you need to have a PostgreSQL instance running. You can get yours here.

Enabling uuid-ossp extension

Let's enabled the uuid-ossp extension from the control panel. By default, all extensions are disabled. You have to enable each one of the extension you required.

In your PostgreSQL instance, select the "Extensions" tab and search for uuid-ossp. Then, enable it and click the save button.

Validate uuid-ossp extension is enabled

To check the uuid-ossp extension is well enabled, let's generate a new UUID v4. Connect your database instance and run the following: