Supabase
Vote for Postgres extensions #679
-
Beta Was this translation helpful? Give feedback.
Replies: 138 comments 217 replies
-
|
plv8 - https://github.com/plv8/plv8 |
Beta Was this translation helpful? Give feedback.
-
|
released 🚢 |
Beta Was this translation helpful? Give feedback.
-
|
@kiwicopple, could you please hide messages when a requested extension is added, so we can easily see the remaining ones? |
Beta Was this translation helpful? Give feedback.
-
|
Removed 😞 |
Beta Was this translation helpful? Give feedback.
-
|
PL Python edit: this cannot be supported on Supabase because it is an untrusted extension. See here for more details |
Beta Was this translation helpful? Give feedback.
-
|
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? |
Beta Was this translation helpful? Give feedback.
-
|
Any news on the plpython extension we would really love to use this in our project. |
Beta Was this translation helpful? Give feedback.
-
|
@inian Any word on this python extension? |
Beta Was this translation helpful? Give feedback.
-
Beta Was this translation helpful? Give feedback.
-
|
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. |
Beta Was this translation helpful? Give feedback.
-
|
Timescale - https://github.com/timescale/timescaledb |
Beta Was this translation helpful? Give feedback.
-
|
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 |
Beta Was this translation helpful? Give feedback.
-
|
Timescale-toolkit is under the TSL License and cannot be offered by Supabase (or any Database-as-a-service) |
Beta Was this translation helpful? Give feedback.
-
|
Timescale is useless in supabase environments… |
Beta Was this translation helpful? Give feedback.
-
|
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. |
Beta Was this translation helpful? Give feedback.
-
|
The official alternative has been announced today: https://supabase.com/blog/analytics-buckets |
Beta Was this translation helpful? Give feedback.
-
|
plpgsql_check for linting and validating SQL code quality. |
Beta Was this translation helpful? Give feedback.
-
|
Added 👍 |
Beta Was this translation helpful? Give feedback.
This comment was marked as duplicate.
This comment was marked as duplicate.
This comment was marked as duplicate.
This comment was marked as duplicate.
-
Beta Was this translation helpful? Give feedback.
-
|
Added via Supabase Postgres v13.3.0. |
Beta Was this translation helpful? Give feedback.
-
|
I would like to see pg_cron on here, although I don't know about the licenses. |
Beta Was this translation helpful? Give feedback.
-
|
Added 👍 |
Beta Was this translation helpful? Give feedback.
This comment was marked as duplicate.
This comment was marked as duplicate.
This comment was marked as duplicate.
This comment was marked as duplicate.
This comment has been hidden.
This comment has been hidden.
This comment has been hidden.
This comment has been hidden.
-
|
PL/R would be great! https://github.com/postgres-plr/plr and https://access.crunchydata.com/documentation/plr/8.3.0.18/ |
Beta Was this translation helpful? Give feedback.
-
|
https://github.com/furstenheim/is_jsonb_valid seems useful for enforcing JSON schemas in columns using the 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) |
Beta Was this translation helpful? Give feedback.
-
|
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). |
Beta Was this translation helpful? Give feedback.
-
Beta Was this translation helpful? Give feedback.
-
|
pg_anon |
Beta Was this translation helpful? Give feedback.
-
|
Note that pg_anon is not an extension and is supported by almost any postgres database. Following their docs now works against any Supabase project :) |
Beta Was this translation helpful? Give feedback.
-
Beta Was this translation helpful? Give feedback.
-
|
I'm also in need of this as pgvector's hnsw is problematic with filters. |
Beta Was this translation helpful? Give feedback.
-
|
keccak |
Beta Was this translation helpful? Give feedback.
-
|
pg_rational |
Beta Was this translation helpful? Give feedback.
-
|
pg_bigm |
Beta Was this translation helpful? Give feedback.
-
|
I could really use mysql_fdw for multiple migrations trajects. |
Beta Was this translation helpful? Give feedback.
-
|
seems supabase not intended to introduce the mysql_fdw, I made my own by forking the https://github.com/wenerme/wrappers |
Beta Was this translation helpful? Give feedback.
-
|
Ability to use PostgreSQL 18 UUIDv7, both to set as the default UUID method and implemented as a function - |
Beta Was this translation helpful? Give feedback.
-
|
You can use this pure sql extension from database.dev to get support already :) |
Beta Was this translation helpful? Give feedback.
-
|
We got analytics in the ability to connect to DuckDB But the beautiful thing is that you can already have it within your regular Postgres with pg_duckdb Now with the release of pg_lake (it's shiny but almost too new, i've yet to test it, but on paper sounds fantastic) there is an opportunity to make Supabase "the everything Postgres" platform. This in particular sounds almost too good
But at this point i'm curious how it would work with Analytical Buckets that are being developed right now |
Beta Was this translation helpful? Give feedback.
-
|
pg_semver |
Beta Was this translation helpful? Give feedback.
-
|
timescaledb (latest version supported pg:17) |
Beta Was this translation helpful? Give feedback.
-
|
I think timescale now supports pg18 |
Beta Was this translation helpful? Give feedback.
-
|
I am afraid Timescale support is being deprecated from 17 onwards, we recommend to use pg_partman |
Beta Was this translation helpful? Give feedback.
-
|
@encima You say you recommend pg_partman but the supabase (pg 15) started with "npx supabase start" (image public.ecr.aws/supabase/postgres:15.8.1.085) doesn't even include that. We plan to migrate to pg_partman prior to upgrading to 17 but without running it locally we can't do that. Also the whole article supabase.com/docs/guides/database/migrating-to-pg-partman seems to be broken/incomplete. It doesn't work at all cause there are no tables created and it also exposes the partitioned public tables to everyone cause RLS is not applied (not even mentioned there). github.com/orgs/supabase/discussions/14506 is not answered at all. It seems like the pg 15 version supabase cloud uses has pg_partman included now but for some reason the cli uses an old version. Can this be upgraded? |
Beta Was this translation helpful? Give feedback.
-
|
That's right, this is included in 15.14 and above I believe. Hope that helps! |
Beta Was this translation helpful? Give feedback.
-
|
Add reoccurring rule (rrule) support with https://github.com/volkanunsal/postgres-rrule RRules are very useful for representing things like calendar entries that repeat (eg: Standup Meeting every Monday at 10am) without needing to materialize all those repeated entries. They also support limiting the number of repetitions by count or end date. Rules are plain text key-value pairs separated by a The syntax can be explored with this rules generator. https://www.addevent.com/c/documentation/tools/recurring-rule-generator While it is possible to perform rrule calculations at the application level without this extension, having it installed means it's much easier to select a date range that occurs long after the initial entry and know that you'll capture repeated entries. |
Beta Was this translation helpful? Give feedback.
-
|
It does not solve your problem directly but Postgres is actually quite good at handling overlapping time periods docs |
Beta Was this translation helpful? Give feedback.
-
Beta Was this translation helpful? Give feedback.
-
|
bump! |
Beta Was this translation helpful? Give feedback.
-
|
+1 This would be incredibly helpful for building knowledge bases. |
Beta Was this translation helpful? Give feedback.
-
|
"The Cryptic Elephant", for Transparent Column Encryption: https://gitlab.com/dalibo/the_cryptic_elephant at Dalibo labs (PostgreSQL License). Ongoing project, but very promising. Will comment this post when they will go "production ready". |
Beta Was this translation helpful? Give feedback.
-
|
The new pg_clickhouse extension, plz! Analytics directly from Postgres (views/RPCs) without SQL rewrites and reducing data-pipeline complexity. |
Beta Was this translation helpful? Give feedback.
-
|
We have support for Clickhouse using our wrappers extension! |
Beta Was this translation helpful? Give feedback.
-
Beta Was this translation helpful? Give feedback.
and others
https://github.com/supabase/pg_jsonschema :)