Support for Custom PostgreSQL Extensions

[bin-bash-mak]

Currently, Supabase supports a curated set of pre-approved PostgreSQL extensions, because it "helps ensure security and stability in the managed environment". However, this approach limits users who require custom database functionality implemented through PostgreSQL extensions.

As discussed in issue 14325, the only way to currently add an extension is via pg_tle, installing it from database.dev, or using one of the pre-approved ones.

But the problem is that I have an extension built with pgrx and I can't add it to my Supabase project.

Now with the already available set of extensions / tools, I can already do what I want in plpgsql or in a node function. But I think it would be nice to add the ability to push extensions similar to how edge functions are pushed.

I also am not sure but I would assume that the native part of the extension inherits the database process permission. But if there's a way to somehow sandbox them or restrict the access to specific parts of the underlying OS. could it help with the mitigation of the security concerns?

[magick93]

Yeah that would be great!

I think something could be done using web assembly.

I see supabase has used web assembly with their wrappers - https://supabase.com/blog/postgres-foreign-data-wrappers-with-wasm

[bin-bash-mak]

Interesting. I did look at some examples in the repo https://github.com/supabase/wrappers but still doesn't look like a full extension alternative.

[AlexandreSi]

Hi,
Can I suggest that you support the extension pg_rational (https://github.com/begriffs/pg_rational)?
@begriffs provided this postgres extension to solve the issue of storing user-defined position in a list (see their blog post about it).
This issue being quite common, I think it could be a great addition to supabase.

[AlexandreSi]

My bad, I added a comment here: https://github.com/orgs/supabase/discussions/679#discussioncomment-14363676

[jasonaibrahim]

Hi, I'd like to suggest adding the pg_rrule extension (https://github.com/petropavel13/pg_rrule) to simplify date expansion for recurring events.

[mfairley]

I'd like to suggest https://github.com/mpartel/postgres-protobuf for handling protobuf messages

[KanagawaMarcos]

I'd like to suggest Periods, as explained at postgres wiki is the most complete implementation of temporal databases on postgres. (Also the only reason my company has not yet transitioned to Supabase)

List of Extensions and Temporal Enhancements

Name	Description	Implementation	Uni-Temporal	Bi-Temporal	Tri-Temporal	Notes
Periods	Periods and SYSTEM VERSIONING for PostgreSQL	Extension	Y	Y	Y	This extension recreates the behavior defined in SQL:2023 (originally in SQL:2011) around periods and tables with SYSTEM VERSIONING. It has a SQL-standard query syntax, as far as possible. Very little activity on this project, only maintenance to ensure compatibility with the latest versions.

[cies]

It seems that the pgmq extension throws errors due to the plpgsql_check extension. I'm not sure where to report this...

More info can be found here:

#41529

[judell]

This seems like an unmonitored thread but fwiw I would like to use https://github.com/turbot/steampipe-postgres-fdw with Supabase.

[mkleczek]

I'd like to ask for https://github.com/vibhorkum/pg_background

It allows:

• running SQL commands asynchronously
• running SQL commands outside of current transaction - this one is necessary to write functions/procedures that execute commands such as CREATE SUBSCRIPTION that must be called outside of transaction context.

[tcolo]

I would like to suggest https://github.com/apache/age

as a graph database extension it brings enormous value for not only AI applications in a graphrag sense.

[JesseVent]

Especially in the knowledge graph era we seem to be in

[james-baker]

PostgreSQL Anonymizer - https://postgresql-anonymizer.readthedocs.io/en/stable/

Or anything that could selectively mask PII in the process of creating a dump? The desire is to safely replicate prod data to the local dev environment.

[JesseVent]

You try this extension I created for the same reason. https://database.dev/jessevent/supa_privacy

[hkm-rebarhq]

PG_TEXTSEARCH - https://github.com/timescale/pg_textsearch

BM25 in Postgres. See https://www.tigerdata.com/blog/you-dont-need-elasticsearch-bm25-is-now-in-postgres

[crisnao2]

I would like to suggest the pg_partman extension, essential for anyone who needs to work with partitioning.

[wi-ski]

Please: https://github.com/SPANDigital/pg-cel

[scottrhoyt]

PostGIS - H3 please! Great companion to PostGIS for working with global hierarchical hex grid system.

[rikardonm]

Can we have https://github.com/bigsmoke/pg_mockable in local deployments? It'd be very useful to mock now() and extend tests with pgTAP.

[benarmstrongqualitate]

pg_ivm please!