Top 11 PLpgSQL SQL Projects

• zombodb

  23 4,608 8.3 PLpgSQL

  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

• practical-sql

  1 624 0.0 PLpgSQL

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

• InfluxDB

  www.influxdata.com sponsored

  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.

  

• practical-sql-2

  1 378 6.0 PLpgSQL

  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

• sqlite_fdw

  6 192 5.4 PLpgSQL

  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

  4 165 7.2 PLpgSQL

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

  

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

• pgstac

  1 123 7.3 PLpgSQL

  Schema, functions and a python library for storing and accessing STAC collections and items in PostgreSQL

  

• pgddl

  2 117 8.5 PLpgSQL

  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

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• advent-of-code

  3 87 5.5 PLpgSQL

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

• typeid-sql

  2 66 5.6 PLpgSQL

  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.

• employee-sample-database

  1 33 1.7 PLpgSQL

  Employee Sample Database for MySQL and Postgres

  

• helium-etl-queries

  1 15 0.0 PLpgSQL

  A collection of SQL views used to enrich data produced by a Helium blockchain-etl

PLpgSQL SQL related posts

• Integrate PostgreSQL and Elasticsearch – ZomboDB
  1 project | news.ycombinator.com | 20 Dec 2022
• ZomboDB: Making Postgres and Elasticsearch work together like it's 2022
  1 project | news.ycombinator.com | 15 Aug 2022
• State of the art for serde-compatible CBOR encoding/decoding?
  3 projects | /r/rust | 19 Apr 2022
• Full text search PG and elastic [High-level questions]
  1 project | /r/PostgreSQL | 15 Apr 2022
• Postgres Auditing in 150 lines of SQL
  10 projects | news.ycombinator.com | 9 Mar 2022
• Unsure if this is the place to ask, but does anybody know of any tools to do full text search on Postgres for patterns, mentions, and so on?
  1 project | /r/PostgreSQL | 12 Feb 2022
• What are you using for text search in your apps? 🔎
  1 project | /r/dotnet | 23 Oct 2021
• A note from our sponsor - WorkOS
  workos.com | 23 Apr 2024

  The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning. Learn more →

Index

Sponsored

SaaSHub - Software Alternatives and Reviews

SaaSHub helps you find the best software and product alternatives

www.saashub.com

Do not miss the trending PLpgSQL projects with our weekly report!