6 posts
A safe migration strategy for production systems using backward-compatible schema changes, phased rollouts, and controlled cleanup.
Manage DB connections in production: PgBouncer transaction pooling, Go database/sql settings, and Node.js pg pool tuning.
Layered integration testing with sqlmock, Testcontainers, httptest, interface-based fake brokers, and external API mocks — architecture diagrams and production-style Go examples.
From B-tree to partial and covering indexes; reading EXPLAIN ANALYZE; how indexes speed reads and what they cost on INSERT, UPDATE, DELETE, and VACUUM.
A practical deep dive into PostgreSQL partitioning with range/list/hash strategies, partition pruning, index design, migration patterns, and operational best practices.
A detailed guide to PostgreSQL sharding architecture, shard-key strategy, query routing, cross-shard trade-offs, and production-ready implementation patterns with GORM.