// Topics / Databases

Databases

16 entries tagged “Databases”

    De-Risking the Black Swan: Red-Teaming Distributed Databases Before Production · 8 min Red-teaming distributed databases before production: most catastrophic failures are compound scenarios nobody practiced, not black swans. distributed-systems databases reliability Caching: The Easy Part Is Adding It, the Hard Part Is Everything Else · 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 Database Migrations Without the Drama · 5 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 Database Reliability Engineering: What I've Learned the Hard Way · 7 min Practical database reliability from running Postgres in production: configs, safe migration patterns, and the operational habits that prevent outages. databases reliability infrastructure Most Teams Should Just Use Postgres · 3 min Serverless databases are solving problems most teams don't have. Here's why Postgres with a connection pooler is still the right answer. cloud databases architecture Database Replication Patterns That Actually Matter · 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 The PostgreSQL Tuning Playbook I Actually Use · 7 min Battle-tested PostgreSQL tuning: connection pooling, memory sizing, index discipline, vacuum management, and the queries that tell you what's broken. databases performance backend Migrating to TypeScript 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: What Actually Works · 7 min Algorithms, headers, and deployment patterns for rate limiting APIs -- drawn from building financial data services at the fintech startup. api backend architecture Database Sharding: You Probably Don't Need It Yet · 8 min Most teams shard too early. Here's how we thought about it at the fintech startup, when it actually makes sense, and the SQL-level decisions that matter most. databases architecture Stop Guessing: How I Fix Slow Databases · 7 min The repeatable process I use at the fintech startup to diagnose and fix database performance problems instead of throwing random indexes at the wall. databases performance The Economics of State: Why Scaling Up Beats Sharding (Until It Doesn't) · 8 min A production-grounded case for exhausting single-server headroom with pooling, replicas, and partitioning before taking on sharding complexity. databases architecture engineering Log Aggregation at Scale: ELK vs Alternatives · 4 min ELK is powerful. It's also a second full-time job. Here's what I learned running it at a mobility startup, and what I'd consider instead. observability databases devops Database Migrations Without Downtime · 7 min A practical guide to evolving schemas without maintenance windows by keeping old and new code compatible at every step. 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 →