Skip to content

Instantly share code, notes, and snippets.

@joelonsql
Last active December 12, 2024 22:15
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.
1000+ PostgreSQL EXTENSIONs

🗺🐘 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

@joelonsql
Copy link
Author

@siilike Thanks, added.

@ImreSamu
Copy link

ImreSamu commented Feb 11, 2022

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

@yamatattsu
Copy link

yamatattsu commented Sep 11, 2022

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

@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

@JSchmidt63
Copy link

is missing: pgMemento

@joelonsql
Copy link
Author

Thanks @JSchmidt63, updated.

@rebasedming
Copy link

rebasedming commented Aug 20, 2024

pg_search (5K+ stars)
CREATE EXTENSION pg_search

@joelonsql
Copy link
Author

Thanks @rebasedming, updated.

@AlexRMU
Copy link

AlexRMU commented Aug 31, 2024

@joelonsql
Copy link
Author

Thanks @AlexRMU, added.

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