ODS - Announcing Support for Postgres Extensions

Post image

A month ago, we launched ODS the fully managed SQL database solution to host your Mysql, MariaDB and PostgreSQL databases.

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.

  • pgcrypto: To enable in-database encryption, ideal for hashing passwords.

  • uuid-ossp: To generate universally unique identifiers (UUIDs).

  • citext: For supporting case-insensitive character string type.

You can find the complete list here.

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:

=# SELECT uuid_generate_v4();
           uuid_generate_v4
--------------------------------------
 b91f1073-de6a-4aa7-a3de-54cba207943d
(1 row)

If everything is fine, it will return an UUID, e.g: b91f1073-de6a-4aa7-a3de-54cba207943d.

As shown above, it's pretty easy to enable new extensions for your databases. If you need one which you don’t see listed, please let us know!

If you have any feedback, pricing or technical question, tweet us at @online_en or open a support ticket, we're always happy to help.

Run your databases on ODS now!

Author image

Edouard Bonlieu

Strategy and marketing at Online.net & Scaleway