Adopting Erlang

https://adoptingerlang.org/docs/development/supervision_trees

PostgreSQL is Enough

PostgreSQL is Enough

• Simplify: move code into database functions
• Just Use Postgres for Everything
• PostgreSQL is the worlds’ best database
• Postgres is eating the database world
• Hacker News discussion

Background and Cron Jobs

• https://github.com/citusdata/pg_cron
• https://github.com/cybertec-postgresql/pg_timetable

Message Queues

• https://adriano.fyi/posts/2023-09-24-choose-postgres-queue-technology
• https://github.com/tembo-io/pgmq

GIS/Mapping

• https://github.com/postgis/postgis

Audit Logs

• https://github.com/arkhipov/temporal_tables
• https://github.com/supabase/supa_audit
• https://github.com/pgMemento/pgMemento
• https://github.com/pgaudit/pgaudit

Access Control & Authorization

• https://github.com/arkhipov/acl
• https://www.postgresql.org/docs/current/pgcrypto.html
• https://github.com/michelp/pgjwt
• https://supabase.com/docs/guides/database/vault

Search

Full Text

• Postgres Full Text Search (bunch of helpful links)
• https://github.com/paradedb/paradedb

Vector

• https://github.com/neondatabase/pg_embedding
• https://github.com/pgvector/pgvector

Time Series

• https://github.com/timescale/timescaledb

Column Oriented

• https://github.com/hydradatabase/hydra
• https://github.com/citusdata/cstore_fdw

NoSQL

• https://www.postgresql.org/docs/current/datatype-json.html
• https://github.com/robconery/dox
• https://www.ferretdb.com

Graph Data

• https://age.apache.org

Foreign Data

• https://github.com/supabase/wrappers

Alternative Query Langauges

• https://github.com/kaspermarstal/plprql
• https://supabase.github.io/pg_graphql

HTTP

• https://github.com/pramsey/pgsql-http
• https://github.com/supabase/pg_net

APIs

• https://github.com/PostgREST/postgrest
• https://github.com/hasura/graphql-engine
• https://postgraphile.org
• https://supabase.github.io/pg_graphql

Events, Replication, CDC,

• https://www.postgresql.org/docs/current/sql-notify.html
• https://github.com/cpursley/walex (Disclosure: I maintain this and think it’s pretty awesome)
• https://github.com/PeerDB-io/peerdb
• https://github.com/debezium/debezium
• https://github.com/2ndQuadrant/pglogical

Caching

• https://martinheinz.dev/blog/105
• https://github.com/readysettech/readyset

Unit Tests

• https://github.com/theory/pgtap
• https://github.com/peterldowns/pgtestdb

HTML and Applications

• SQLpage
• Omnigres
• pg_render
• plmustache

Graphics / Visual

• pgSVG

Migrations

• https://github.com/purcell/postgresql-migrations
• https://www.bytebase.com/
• https://github.com/xataio/pgroll
• https://github.com/stripe/pg-schema-diff

Performance Tuning

• Index Advisor
• Dexter
• HypoPG
• pg_hint_plan
• PGHero

Scalling

• How Cloudflare Achieved 55 Million Requests per Second with Just 15 PostgreSQL Clusters!
• https://github.com/supabase/supavisor
• https://github.com/pg-sharding/spqr

Dashboards / UIs

• Baserow
• NocoDB
• AppSmith

Data Visualization

• Evidence
• Metabase

Package Management

• https://github.com/pgxman/pgxman
• https://github.com/supabase/dbdev

Language Servers

• https://github.com/supabase/postgres_lsp

Miscellaneous

• Very comprehensive list of Postgres tooling

What’s missing? Please share in the comments.

view raw postgresql_is_enough.md hosted with ❤ by GitHub

Ruby load testing

https://news.ycombinator.com/from?site=rorvswild.com

https://pgtune.leopard.in.ua/

Helvetic Ruby Conf

Great presentations:

AI Speech

https://news.ycombinator.com/item?id=39036796

https://elevenlabs.io/

Platform engineering vs devops

https://blog.massdriver.cloud/posts/devops-is-bullshit/

A new LRU Cache algorithm

https://cachemon.github.io/SIEVE-website/blog/2023/12/17/sieve-is-simpler-than-lru/

How to learn better

https://news.ycombinator.com/item?id=36580837

Hardware prototyping

https://news.ycombinator.com/item?id=37370248

Interactive Music Theory

https://muted.io/

Improve your English pronunciation

https://youglish.com/

https://news.ycombinator.com/item?id=38074701

A magical documentation site generator : docsify

https://docsify.js.org/#/?id=docsify-4131

Choosing a programming language

https://www.tundraware.com/Technology/How-To-Pick-A-Programming-Language/

How to roll out your own root CA

https://wejn.org/2023/09/running-ones-own-root-certificate-authority-in-2023/

https://news.ycombinator.com/item?id=37537689

https://github.com/smallstep/cli

https://github.com/smallstep/certificates

CPU Caches

CPU caches myths