Vote for Postgres extensions #679
Replies: 106 comments 123 replies
-
plv8 - https://github.com/plv8/plv8 |
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.
-
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.
-
plpgsql_check for linting and validating SQL code quality. |
Beta Was this translation helpful? Give feedback.
This comment has been minimized.
This comment has been minimized.
This comment has been minimized.
This comment has been minimized.
-
I would like to see pg_cron on here, although I don't know about the licenses. |
Beta Was this translation helpful? Give feedback.
This comment has been minimized.
This comment has been minimized.
This comment has been minimized.
This comment has been minimized.
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.
-
https://github.com/apache/age has finally updated their pg version support. |
Beta Was this translation helpful? Give feedback.
-
This extension provides support for temporal tables. System-period data versioning (also known as transaction time or system time) allows you to specify that old rows are archived into another table (that is called the history table). |
Beta Was this translation helpful? Give feedback.
-
Like pgvector but better and faster. We are currently experiencing some bottlenecks with pgvector when it comes to filtering: pgvector/pgvector#259 We have tested pgvecto.rs locally and it works surprisingly well. This would actually be game changing! pgvecto.rs is a Postgres extension that provides vector similarity search functions. It is written in Rust and based on pgrx. Read more at 📝our blog. Why use pgvecto.rs
|
Beta Was this translation helpful? Give feedback.
-
It allows to access up to 83 distinct spatial file formats or databases with a Foreign Data Wrapper relying on the vector half of the GDAL library. |
Beta Was this translation helpful? Give feedback.
-
Would it be possible to get a version of postgres with the data wrapper extensions included? Specifically I would be looking for the airtable fdw. |
Beta Was this translation helpful? Give feedback.
-
https://github.com/ChenHuajun/pg_roaringbitmap Compressed bitmaps for analytics and efficient faceting |
Beta Was this translation helpful? Give feedback.
-
SipHash via pghashlib extension. Or a new SIMD extension by Supabase Devs based on Defending Against Hash Flooding. This protects Supabase from "hash flooding" denial-of-service attacks (HashDoS) |
Beta Was this translation helpful? Give feedback.
-
Can we have semver support? plugin : https://github.com/theory/pg-semver/blob/main/src/semver.c |
Beta Was this translation helpful? Give feedback.
-
https://github.com/sraoss/pg_ivm Allows for more power of materialized views with auto maintenance on selected views |
Beta Was this translation helpful? Give feedback.
-
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 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: root@IP:/# apt-get install postgresql15-mysql-fdw I logged-in into my postgres and tried to create mysql_fdw extension When I tried to install make, the below error appears root@IP:/mysql_fdw# make 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 |
Beta Was this translation helpful? Give feedback.
-
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. |
Beta Was this translation helpful? Give feedback.
-
zhparser, an extension for full-text search of Chinese language. |
Beta Was this translation helpful? Give feedback.
-
PostgreSQL Partition Manager |
Beta Was this translation helpful? Give feedback.
-
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.
Beta Was this translation helpful? Give feedback.
All reactions