Vote for Postgres extensions

[kiwicopple]

This issue is for tracking requests/demand for Postgres Extensions. Give a thumbs up if you want an extension added.

Please refrain from adding comments unless you are adding an extension which isn't already listed.

We will be sorting by Top here, so please upvote the extension, the emojis don't count as upvotes. Don't create duplicate requests, so that the votes aren't split.

[kiwicopple]

plv8 - https://github.com/plv8/plv8

[kiwicopple]

released 🚢

[ozum]

@kiwicopple, could you please hide messages when a requested extension is added, so we can easily see the remaining ones?

[kiwicopple]

PL Python

edit: this cannot be supported on Supabase because it is an untrusted extension. See here for more details
https://github.com/orgs/supabase/discussions/2239

[skwaugh]

Was support for this recently dropped? Can't find it in a new pg13 supabase project...which means it is not enabled during initial build. Is this temporary or the norm going forward?

[chrichrichri]

Any news on the plpython extension we would really love to use this in our project.

[burggraf]

@inian Any word on this python extension?

[inian]

#2239 (comment)

[shah]

PL Java would be great - https://github.com/tada/pljava.

Also, ARG based build which would enable/disable certain plugins might also be helpful.

Great work by the way, love the Dockerfile.

[kenahrens]

Timescale - https://github.com/timescale/timescaledb

[derfurth]

It would be great to have the complementary timescaledb_toolkit as well (it's under the same license), as is provides all of the hyperfunctions to query the time-series.

[georgewritescode]

Following up to also note that timescaledb_toolkit would be very helpful given it has many of the functions required to use timscaledb. Also referenced here: https://github.com/orgs/supabase/discussions/17108

[encima]

Timescale-toolkit is under the TSL License and cannot be offered by Supabase (or any Database-as-a-service)

[riderx]

Timescale is useless in supabase environments…
That why I made a PR to have a columnar db alternative:
https://github.com/orgs/supabase/discussions/679#discussioncomment-7791898
please have a look and if that fit your use case upvote it

[bitnom]

IMO some alternative to timescale should have been used. The licensing is bad, and the version you can use in supabase cloud is not good.

[shah]

plpgsql_check for linting and validating SQL code quality.

[kiwicopple]

Added 👍

[felixyz]

wal2json

[dragarcia]

Added via Supabase Postgres v13.3.0.

[Takashiidobe]

I would like to see pg_cron on here, although I don't know about the licenses.

[kiwicopple]

Added 👍

[psolymos]

PL/R would be great! https://github.com/postgres-plr/plr and https://access.crunchydata.com/documentation/plr/8.3.0.18/

[Vadorequest]

https://github.com/furstenheim/is_jsonb_valid seems useful for enforcing JSON schemas in columns using the JSON type.

It's not in the Database > Extensions yet, I suggest it is added.

It seems to be more performant than its https://github.com/gavinwahl/postgres-json-schema counterpart. (from the author)

[chipilov]

FYI, since the https://github.com/gavinwahl/postgres-json-schema extension is implemented in PL/pgSQL, you can enable it manually in your instance by running its script against your db: https://github.com/gavinwahl/postgres-json-schema/blob/master/postgres-json-schema--0.1.1.sql (you just need to remove/replace the references to @extschema@, since that's only available for extensions).

[cananda]

https://github.com/supabase/pg_jsonschema :)

[nikolap]

https://github.com/sraoss/pg_ivm

Allows for more power of materialized views with auto maintenance on selected views

[AzmathShaik1210]

Hi @kiwicopple,

I tried installed the Postgres server with help of Supabase docker image and I'm facing the issue in installing the mysql_fdw extension in it. Below is the case history and the work-around.

My requirement

Self-hosted
I'm trying to access the DB (MySQL) from Postgres through Supabase

CREATE SERVER mysql_server FOREIGN DATA WRAPPER mysql_fdw OPTIONS (host 'my-host', port '3306', dbname 'my-db-name');

ERROR: foreign-data wrapper "mysql_fdw" does not exist

My Postgres version:
Postgres (PostgreSQL) 15.1 (Ubuntu 15.1-1.pgdg20.04+1)

root@IP:/# apt-get install postgresql15-mysql-fdw
Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Unable to locate package postgresql15-mysql-fdw

I logged-in into my postgres and tried to create mysql_fdw extension
postgres=> CREATE EXTENSION mysql_fdw;
ERROR: extension "mysql_fdw" is not available
DETAIL: Could not open extension control file "/usr/share/postgresql/15/extension/mysql_fdw.control": No such file or directory.
HINT: The extension must first be installed on the system where PostgreSQL is running.

When I tried to install make, the below error appears

root@IP:/mysql_fdw# make
gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wcast-function-type -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -fno-omit-frame-pointer -fPIC -I/usr/include/mysql -D _MYSQL_LIBNAME="libmysqlclient.so" -I. -I./ -I/usr/include/postgresql/15/server -I/usr/include/postgresql/internal -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2 -c -o connection.o connection.c
connection.c:15:10: fatal error: postgres.h: No such file or directory
15 | #include "postgres.h"
| ^~~~~~~~~~~~
compilation terminated.
make: *** [: connection.o] Error 1

I have tried with multiple Postgres versions like 14, 15 & 16 but still no luck.

Will it be possible to add the mysql_fdw extension to supabase docker image? If YES, then can you let me know by when can it be added. If NO, can explain in-detail why we cannot add it.

Thanks

[nCrafts]

pg_timeseries

https://github.com/tembo-io/pg_timeseries

Timescaledb is nice but the Apache license is quite limiting. Would love to support pg_timeseries.

[riderx]

Yes please !

[QThans]

zhparser, an extension for full-text search of Chinese language.

https://github.com/amutu/zhparser

[Rafat97]

PostgreSQL Partition Manager

https://github.com/pgpartman/pg_partman

[nlarusstone]

pg_lakehouse (for querying parquet/iceberg directly) would be really nice to support!

https://blog.paradedb.com/pages/iceberg_lakehouse

[remymiguk]

https://github.com/tcdi/plrust ?

[yujonglee]

pg_search by paradedb
https://docs.paradedb.com/deploy/pg_search#install-pg-search

[lxup]

Having a complete search engine solution directly on postgres could be awesome

[lostz]

So am I

[philipandersson]

agreed, would be a great improvement to this work you already done: https://supabase.com/docs/guides/ai/hybrid-search

[bitnom]

https://github.com/pksunkara/pgx_ulid

[BoscoDomingo]

Any plans to add this? ULID has been around for almost 7 years now and it is a wonderful way to fix issues with index fragmentation caused by UUIDv4

Also, UUIDv7 is not officially out yet

[erolabzait]

@BoscoDomingo this is opened for a longer time https://github.com/orgs/supabase/discussions/679#discussioncomment-5272444, maybe you can vote here as well

[BoscoDomingo]

Done, great catch!

[hwr12]

Postgres Foreign database wrapper for MySQL?

[mattaylor]

parquet s3 FDW
https://github.com/pgspider/parquet_s3_fdw

[burmecia]

The S3 parquet FDW is already included in the Wrappers extension. https://supabase.com/docs/guides/database/extensions/wrappers/s3

[lpj145]

PgMq for queue
https://github.com/tembo-io/pgmq

[parkernilson]

PLDebugger
https://github.com/EnterpriseDB/pldebugger

For supporting pgAdmin 4 debugger

[rakesh-tmdc]

Apache Age - https://github.com/apache/age.git

For supporting Graph Database.

[sajkamal]

Would be keen to get Apache Age

[raywalz]

Would be keen to get Apache Age

This post is a duplicate. Please upvote the main one here: https://github.com/orgs/supabase/discussions/679?sort=top#discussioncomment-7323662

[bachkukkik]

sqlite_fdw for Federated SQL

https://github.com/pgspider/sqlite_fdw