// Topics / Databases

Databases

16 entries tagged “Databases”

    Red-Teaming Distributed Databases Before the Black Swan · 7 min Most catastrophic distributed database incidents are compound failures nobody practiced. How to red-team partitions, clock skew, and operator error. distributed-systems databases reliability Caching Strategies: Adding It Is Easy, Invalidation Is Hard · 6 min Cache-aside, write-through, invalidation strategies, and the failure modes that will wake you up at night. With Go examples. performance databases go PostgreSQL Performance: Measure First, Tune Second · 6 min Most Postgres performance problems are indexing problems. The rest are vacuum problems. Here's how to find and fix both. databases performance backend Zero-Downtime PostgreSQL Migrations Without the Drama · 6 min A single ALTER TABLE can ruin your weekend. How to migrate safely with expand-and-contract, batched backfills, and compatible deploys. databases ci-cd Postgres Reliability: Restores, Failover, Safe Migrations · 8 min Practical database reliability from running Postgres in production: configs, safe migration patterns, and the operational habits that prevent outages. databases reliability infrastructure Serverless Databases vs Postgres: Most Teams Need Postgres · 3 min Aurora Serverless, DynamoDB, Fauna, and PlanetScale solve problems most teams don't have. Postgres with a connection pooler is still the default. cloud databases architecture PostgreSQL Replication Patterns: Async, Sync, and Quorum · 8 min A practical breakdown of replication modes, topologies, and the tradeoffs between consistency, availability, and not losing your users' data at 3am. databases distributed-systems architecture PostgreSQL Performance Tuning: The Playbook I Use · 7 min PostgreSQL tuning in the order I do it: find slow queries with pg_stat_statements, pool connections, size memory, fix indexes, tune autovacuum and WAL. databases performance backend Incremental TypeScript Migration Without Losing Your Mind · 5 min How to introduce TypeScript to a real JavaScript codebase incrementally, without halting product work or annoying your entire team. engineering databases development API Rate Limiting: Token Buckets, Redis, and Headers · 6 min Rate limiting APIs at a fintech startup: choosing the limit key, token bucket vs other algorithms, Redis Lua scripts, headers, and fail-open. api backend architecture Database Sharding: You Probably Don't Need It Yet · 8 min Most teams shard too early. What to exhaust first on a single PostgreSQL primary, when sharding is justified, how to pick a shard key, and what it costs. databases architecture PostgreSQL Performance Tuning: Stop Guessing, Measure First · 7 min How I diagnose slow PostgreSQL queries: slow query log, EXPLAIN ANALYZE, stale statistics, targeted indexes, connection pooling, one change at a time. databases performance Scaling PostgreSQL: Why Scaling Up Beats Sharding · 8 min How we scaled PostgreSQL for a high-volume ingestion pipeline with PgBouncer, streaming replicas, and partitioning, and why sharding comes last. databases architecture engineering Log Aggregation at Scale: ELK vs Alternatives · 4 min ELK is powerful and a second full-time job. What running it at a mobility startup taught me, and the hosted or simpler options I'd pick instead. observability databases devops Zero-Downtime PostgreSQL Migrations: Expand and Contract · 7 min How to change PostgreSQL schemas without maintenance windows: expand and contract, batched backfills, NOT VALID constraints, and concurrent indexes. databases devops engineering Postgres vs MySQL in 2016: A Practical Comparison · 5 min A grounded look at PostgreSQL and MySQL as of April 2016, focusing on integrity, query power, and operational tradeoffs rather than benchmark hype. databases architecture engineering
All topics →