Subject
8 entries
Postgresql
Bookmarks
Improving Django Testing with Seed Databases
A technique for speeding up Django CI test runs by pre-seeding a database with migrations already applied, then restoring it via pg_dump/pg_restore rather than re-running migrations from scratch each time. Significant CI speedup for projects with many migrations.
Benchmarking Postgres vector search: pgvector vs Lantern
Tembo's benchmark comparing pgvector and Lantern for vector similarity search in PostgreSQL — tests query speed, indexing time, and recall across different dataset sizes. Practical data for choosing a Postgres vector extension.
PostgreSQL Encryption: The Available Options
Matt Palmer's comprehensive overview of PostgreSQL encryption options — covers full-disk encryption, TLS in transit, column-level encryption with pgcrypto, and the tradeoffs between each. A clear-headed reference for teams navigating database encryption requirements.
Supabase Vault: Secrets and Encryption in PostgreSQL
Supabase Vault is a PostgreSQL extension for managing secrets and encrypted data inside the database — built on pgsodium and Libsodium, it handles key management and column encryption without application-layer complexity.
OrioleDB: Modern Cloud-Native PostgreSQL Storage Engine
OrioleDB is a PostgreSQL table access method (storage engine) built to solve PostgreSQL's wicked scalability problems — bloat, vacuum overhead, lock contention — by using a copy-on-write B-tree and row-level WAL. Aims to make PostgreSQL cloud-native without forking it.
Cleaning Up Your Postgres Database
Crunchy Data's guide to PostgreSQL database maintenance — identifying bloat, reclaiming space with VACUUM, finding unused indexes, and cleaning up dead connections. Practical operations reference for keeping a Postgres database healthy.
PoWA — PostgreSQL Workload Analyzer
PoWA (PostgreSQL Workload Analyzer) is a real-time statistics and workload analysis tool for PostgreSQL — collects query statistics, visualizes slow queries, and helps identify index and configuration improvements. A targeted alternative to generic APM tools for Postgres-specific performance work.
How I Write SQL
Craig Kerstiens' SQL style guide — uppercase keywords, meaningful aliases, explicit JOINs, and consistent formatting. A practitioner-written standard that became influential in the PostgreSQL and analytics communities.