Skip to content

Instantly share code, notes, and snippets.

@joelonsql

joelonsql/PostgreSQL-EXTENSIONs.md

Last active April 21, 2024 17:01
Show Gist options
  • Save joelonsql/e5aa27f8cc9bd22b8999b7de8aee9d47 to your computer and use it in GitHub Desktop.
Save joelonsql/e5aa27f8cc9bd22b8999b7de8aee9d47 to your computer and use it in GitHub Desktop.
Download ZIP
1000+ PostgreSQL EXTENSIONs
Raw
PostgreSQL-EXTENSIONs.md

🗺🐘 1000+ PostgreSQL EXTENSIONs

This is a list of URLs to PostgreSQL EXTENSION repos, listed in alphabetical order of parent repo, with active forks listed under each parent.

⭐️ >= 10 stars
⭐️⭐️ >= 100 stars
⭐️⭐️⭐️ >= 1000 stars
Numbers of stars might not be up-to-date.

If some repo is missing, please write a comment with the url.

Uncategorized

Access Methods

Aggregate Functions

Data Types

Dictionaries

Foreign Data Wrappers

Procedural Languages

Spatial and Geographic Objects

@siilike
Copy link

siilike commented Feb 11, 2022

https://github.com/siilike/postgresql-vpack

@joelonsql
Copy link
Author

@siilike Thanks, added.

@ImreSamu
Copy link

ImreSamu commented Feb 11, 2022 •
edited

https://github.com/MobilityDB/MobilityDB CREATE EXTENSION MobilityDB
https://github.com/CartoDB/cartodb-postgresql CREATE EXTENSION cartodb
https://github.com/apache/madlib "Apache MADlib: Big Data Machine Learning in SQL" / pgxn install madlib
https://github.com/citusdata/citus CREATE EXTENSION citus;
https://github.com/pgRouting/pgrouting CREATE EXTENSION pgrouting

some extension from "gitlab"

EDIT1:

EDIT2:

EDIT3:

@joelonsql
Copy link
Author

@ImreSamu Thanks, added.

@ImreSamu
Copy link

https://github.com/orioledb/orioledb

@yamatattsu
Copy link

yamatattsu commented Sep 11, 2022 •
edited

Hi Joel,

I'd like you to know that 16 repositories are "not found".
See below:

$ curl -s https://github.com/craigbranscom/pg-biguint     |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/funbringer/pg_logging        |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/funbringer/pg_shardman       |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/panwenhang/pgtools   |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/johto/postgres_numeric_trim  |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/danielbulger/postgresql-wilson-ext   |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/gilt/role_manager    |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/x4m/clickhouse_fdw   |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/craigbranscom/pg-biguint     |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/funbringer/pg_logging        |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/funbringer/pg_shardman       |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/panwenhang/pgtools   |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/johto/postgres_numeric_trim  |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/danielbulger/postgresql-wilson-ext   |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/gilt/role_manager    |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/x4m/clickhouse_fdw   |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>

@chanukyasds
Copy link

Hi joel,

This pg_math extension supports PostgreSQL to compute several statistical distribution methods.

https://github.com/chanukyasds/pg_math

Thanks,
Chanukya

@jbiz805
Copy link

jbiz805 commented Jun 29, 2023

Hi Joel,

The graph database extension for PostgreSQL official name is Apache AGE and its official repo is https://github.com/apache/age

Thanks,
Joe

@aozturkoda
Copy link

Hi Joel,

Here some links i found not working anymore in your list.

Thanks.

@JerrySievert
Copy link

it looks like your javascript extensions are out of date and appear to be abandoned.

https://github.com/plv8/plv8 is the canonical one, and is still active. https://github.com/plv8/pljs is the lightweight alternative, still in alpha.

@joelonsql
Copy link
Author

Thanks @JerrySievert @aozturkoda @jbiz805 @chanukyasds @yamatattsu @ImreSamu, updated.

@JSchmidt63
Copy link

is missing: pgMemento

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment