Choose and operate the right database. PostgreSQL vs MySQL, Redis caching patterns, MongoDB data modeling, replication, sharding, and backup strategies explained.
8 articles
A practical comparison of SQL and NoSQL databases. Covers MongoDB, Redis, DynamoDB, Cassandra, and Neo4j vs PostgreSQL with real trade-offs, code examples, and a decision framework for choosing the right database.
A practical guide to time-series databases. Compare TimescaleDB, InfluxDB, Prometheus, and ClickHouse. Learn TSDB architecture, compression, downsampling, and when to upgrade from plain PostgreSQL.
A complete guide to PostgreSQL connection pooling with PgBouncer. Covers the process-per-connection model, pooling modes (session, transaction, statement), configuration, Kubernetes deployment patterns, and alternatives.
A practical guide to database sharding and partitioning in PostgreSQL. Covers range, list, and hash partitioning, consistent hashing, cross-shard queries, resharding, and when to choose each strategy.
A practical guide to ACID properties in PostgreSQL. Covers atomicity, consistency, isolation levels (Read Committed through Serializable), durability, and the anomalies each isolation level prevents.
A practical guide to every Redis data structure. Learn when to use strings, lists, sets, sorted sets, hashes, and streams -- with real commands, memory trade-offs, and a decision framework.
A complete guide to PostgreSQL streaming replication. Covers WAL shipping, synchronous vs asynchronous modes, replica lag monitoring, failover with Patroni, and physical vs logical replication trade-offs.
A complete guide to PostgreSQL index types. Learn when to use B-Tree, Hash, GIN, GiST, BRIN, and partial indexes with real SQL examples, EXPLAIN ANALYZE verification, and index maintenance strategies.
New articles delivered to your inbox. No spam.