Show HN: PgDog – Scale Postgres without changing the app

kept by eddie feb 24

PgDog is a PostgreSQL proxy that provides connection pooling, load balancing, and sharding without modifying application code; written in Rust, it handles thousands of connections and supports cross-shard queries.

Unconventional PostgreSQL Optimizations
The article details unconventional PostgreSQL optimization techniques like using constraint_exclusion, function-based indexes, virtual generated columns, and hash indexes for efficiency.
also on PostgreSQL, #infrastructure, #open-source, #software-engineering, #developer-tools
Video Conferencing with Postgres — PlanetScale
A developer demonstrates live video calls over PostgreSQL using logical replication, achieving 15fps with a $5 database.
also on PostgreSQL, #infrastructure, #software-engineering, #developer-tools