Hacker News
- Common DB schema change mistakes in Postgres https://postgres.ai/blog/20220525-common-db-schema-change-mistakes 77 comments
- PostgreSQL Subtransactions Considered Harmful https://postgres.ai/blog/20210831-postgresql-subtransactions-considered-harmful 41 comments
- Joe, a Postgres query optimization bot https://postgres.ai/blog/joe-0.5/ 37 comments
- Common DB schema change mistakes in Postgres https://postgres.ai/blog/20220525-common-db-schema-change-mistakes 0 comments programming
- Common DB schema change mistakes https://postgres.ai/blog/20220525-common-db-schema-change-mistakes 2 comments programming
- Common DB schema change mistakes https://postgres.ai/blog/20220525-common-db-schema-change-mistakes 0 comments postgresql
- Three Cases Against IF NOT EXISTS / IF EXISTS in Postgres DDL https://postgres.ai/blog/20211103-three-cases-against-if-not-exists-and-if-exists-in-postgresql-ddl 5 comments postgresql
- Zero-downtime Postgres schema migrations need this: lock_timeout and retries https://postgres.ai/blog/20210923-zero-downtime-postgres-schema-migrations-lock-timeout-and-retries 3 comments postgresql
- Database Lab Engine 2.1.0 released https://postgres.ai/blog/dle-2.1-release/ 3 comments postgresql
Linking pages
- GitHub - NAlexPear/pg_branch: Experimental Postgres extension for quickly branching databases through file system snapshots https://github.com/NAlexPear/pg_branch 67 comments
- Why we spent the last month eliminating PostgreSQL subtransactions | GitLab https://about.gitlab.com/blog/2021/09/29/why-we-spent-the-last-month-eliminating-postgresql-subtransactions/ 56 comments
- GitHub - postgres-ai/database-lab-engine: Database Lab Engine (DLE) provides blazing-fast database branching for Postgres to build powerful development, test, QA, staging environments. Follow to stay updated. https://github.com/postgres-ai/database-lab-engine 40 comments
- Supabase Branching https://supabase.com/blog/supabase-branching 1 comment
- Deep Dive: Testing a Microservice Architecture with QA Environments | by Dan Hipschman | Open House | Medium https://medium.com/opendoor-labs/deep-dive-testing-a-microservice-architecture-with-qa-environments-cd338648c37b 0 comments
- PostgreSQL: bloat, pg_repack, and deferred constraints | by Nikolai Averin | Miro Engineering | Medium https://medium.com/miro-engineering/postgresql-bloat-pg-repack-and-deferred-constraints-d0ecf33337ec 0 comments