PLpgSQL Postgresql

Open-source PLpgSQL projects categorized as Postgresql

Top 6 PLpgSQL Postgresql Projects

  • GitHub repo pg_partman

    Partition management extension for PostgreSQL

    Project mention: Replicating a dynamically partitioned table possible in Postgres 13 | | 2021-01-08

    You might want to look into pg_partman which has many useful tools around semi-automatic partitioning. According to their documentation they already have a procedure that will do exactly that: create new partitions based on the rows in the default partition.

  • GitHub repo aquameta

    Web development platform built entirely in PostgreSQL

    Project mention: | 2021-02-16

    Whoa, this project looks really cool. I'm trying to read the docs though, and there's a lot of broken links — e.g. all the "Backend Documentation" links here:

  • GitHub repo periods


    Project mention: Temporal Tables PostgreSQL Extension | | 2021-04-09
  • GitHub repo metagration

    Metagration: PostgreSQL Migrator in PostgreSQL

    Project mention: Metagration: PostgreSQL Migrator in PostgreSQL | | 2021-02-16
  • GitHub repo duckdb_fdw

    DuckDB Foreign Data Wrapper for PostgreSQL

    Project mention: DuckDB Postgres Foreign Data Wrapper | | 2021-02-20
  • GitHub repo klapa

    Text patterns clustering in PostgreSQL

    Project mention: Log Pattern Recognition: LogMine | | 2021-01-11

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2021-04-09.


What are some of the best open-source Postgresql projects in PLpgSQL? This list will help you:

Project Stars
1 pg_partman 1,098
2 aquameta 989
3 periods 114
4 metagration 28
5 duckdb_fdw 18
6 klapa 11