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.
To enable ODS extensions, you need to have a PostgreSQL instance running. You can get yours here.
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.
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:
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!