PLpgSQL Postgresql

Open-source PLpgSQL projects categorized as Postgresql
Edit details
Topics: Postgres SQL postgresql-extension Database plpgsql
Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured

Top 23 PLpgSQL Postgresql Projects

  • blog

    OpenSource,Database,Business,Minds. git clone --depth 1 https://github.com/digoal/blog (by digoal)

  • zombodb

    Making Postgres and Elasticsearch work together like it's 2023

    • Project mention: Introducing pgzx: create PostgreSQL extensions using Zig | news.ycombinator.com | 2024-03-21

    And lots of interesting extensions use it, like

    https://github.com/tembo-io/pgmq

    https://github.com/zombodb/zombodb

    https://github.com/supabase/pg_jsonschema

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo

  • pg_partman

    Partition management extension for PostgreSQL

    • Project mention: Dear data engineers | /r/dataengineering | 2023-12-06

    Assuming these are the types of insights you're looking for, you'll probably look for a way to aggregate data points across/within geographies. postgis is an open source extension for postgres that can help you with this, but there's also quite a few python tools that can help you explore the data, such as geopandas, folium, geoplot. Depending on volume, you might want to partition the data for query performance, and there's another extension pg_partman that can help with that. Just noticed some other posts have recommended something similar.

  • pgwatch2

    PostgreSQL metrics monitor/dashboard

  • aquameta

    Web development platform built entirely in PostgreSQL

    • Project mention: Versioning data in Postgres? Testing a Git like approach | news.ycombinator.com | 2023-10-20

    Aquameta has an interesting extension that something like this in a different way: https://github.com/aquametalabs/aquameta/tree/master/extensi....

  • postgres_dba

    The missing set of useful tools for Postgres DBAs and all engineers

    • Project mention: Postgres: The Unexpected Find That Freed 20GB of Unused Index Space | news.ycombinator.com | 2023-08-28

    In a similar vein, I got good value from these scripts:

    https://github.com/NikolayS/postgres_dba

    I managed to free 10% a.k.a about 100 GB of storage by reorganizing table column ordering in a big table.

  • practical-sql

    Code and Data for the First Edition of "Practical SQL" by Anthony DeBarros, published by No Starch Press (2018).

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo

  • postgresDBSamples

    Sample databases for postgres

  • practical-sql-2

    Code and Data for the Second Edition of "Practical SQL" by Anthony DeBarros, published by No Starch Press (2022).

    • Project mention: Can't copy CSV file to table - Practical SQL 2nd Edition | /r/PostgreSQL | 2023-09-12

  • dbdev

    Database Package Registry for Postgres

    • Project mention: Building a Managed Postgres Service in Rust | news.ycombinator.com | 2024-04-08

  • duckdb_fdw

    DuckDB Foreign Data Wrapper for PostgreSQL

  • periods

    PERIODs and SYSTEM VERSIONING for PostgreSQL

  • sqlite_fdw

    SQLite Foreign Data Wrapper for PostgreSQL

    • Project mention: Things that surprised me while running SQLite in production | news.ycombinator.com | 2023-07-03

    https://github.com/pgspider/sqlite_fdw

    Postgres has foreign data wrappers which can kinda achieve this(see also: https://github.com/pgspider/sqlite_fdw ), but ive been surprised by how well sqlite is already supported by many tools : sometimes it comes for free as its used in testing - hooking up stuff like litestream can work really wel l too

  • pg_net

    A PostgreSQL extension that enables asynchronous (non-blocking) HTTP/HTTPS requests with SQL

    • Project mention: PostgreSQL Is Enough | news.ycombinator.com | 2024-02-06

  • parquet_s3_fdw

    ParquetS3 Foreign Data Wrapper for PostgresSQL

  • postgres-aws-s3

    aws_s3 postgres extension to import/export data from/to s3 (compatible with aws_s3 extension on AWS RDS)

  • pgddl

    DDL eXtractor functions for PostgreSQL (ddlx)

    • Project mention: Ask HN: It's 2023, how do you choose between MySQL and Postgres? | news.ycombinator.com | 2023-05-11

  • metagration

    Metagration: PostgreSQL Migrator in PostgreSQL

  • penkala

    Composable query builder for PostgreSQL written in Clojure.

  • advent-of-code

    https://adventofcode.com/ (by xocolatl)

  • typeid-sql

    SQL implementation TypeIDs: type-safe, K-sortable, and globally unique identifiers inspired by Stripe IDs

    • Project mention: Type-safe, K-sortable, globally unique identifier inspired by Stripe IDs | news.ycombinator.com | 2023-06-28

    The authors have created a specialisation for Postgres that leverages a custom type which is a tuple of type and uuidv7: https://github.com/jetpack-io/typeid-sql/blob/main/sql/typei...

    This is more optimal for Postgres while making it slightly more difficult to interop between the db and the language (db driver needs to handle custom types, and you need to inject a custom type converter).

    And while there are hacks you can do to make storing uuid-alikes as strings less terrible for db engines, if you want the best performance and smallest space consumption (compressed or not) make sure to use native ID types or convert to BINARY/numeric types.

  • omdb-postgresql

    PostgreSQL Schema for OMDB

  • employee-sample-database

    Employee Sample Database for MySQL and Postgres

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
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).

PLpgSQL Postgresql related posts

Index

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

Project Stars
1 blog 7,849
2 zombodb 4,611
3 pg_partman 1,888
4 pgwatch2 1,732
5 aquameta 1,092
6 postgres_dba 974
7 practical-sql 637
8 postgresDBSamples 418
9 practical-sql-2 389
10 dbdev 330
11 duckdb_fdw 241
12 periods 238
13 sqlite_fdw 195
14 pg_net 174
15 parquet_s3_fdw 165
16 postgres-aws-s3 137
17 pgddl 128
18 metagration 99
19 penkala 99
20 advent-of-code 87
21 typeid-sql 69
22 omdb-postgresql 39
23 employee-sample-database 33

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com