Tag: databases

Compare Litestream's continuous backup with rqlite's Raft replication for distributed SQLite. Learn when each fits your self-hosted setup.

ClickHouse, DuckDB, or StarRocks for home lab analytics? A practical guide to picking the right OLAP engine for your query patterns without losing the weekend.

How to safely add a NOT NULL column with a live backfill on a 200M-row Postgres table without locking your users out or scheduling any maintenance downtime.

Build a real Postgres 17 HA cluster with Patroni 4.x, etcd 3.5, and HAProxy, fully automatic failover, tested switchover procedure, zero manual babysitting.

DragonflyDB vs Redis 8.x and Valkey 9.x: architecture deep dive, real performance benchmarks, honest gotchas, and when to swap your cache layer for a dragon.

KeyDB forked Redis and shipped multi-threaded I/O and active-active replication years before Redis itself did. Here is whether it is still worth using today.

Postgres table bloat killing your query performance? Compare VACUUM FULL vs pg_repack and learn how to reclaim disk space live without any scheduled downtime.

pg_stat_statements is far more than a slow query log. Here is what most tutorials skip entirely: tail latency percentiles, cache hit ratios, and WAL bloat.

Learn to read Postgres EXPLAIN ANALYZE output without losing your mind. Costs, row estimates, buffer hit stats, and the index and query fixes that matter most.

pgAdmin, Adminer, or CloudBeaver, three web UIs for your databases, zero overlap in who should use them. Pick the wrong one and you'll hate your life.

Run PostgreSQL 18 on ZFS for atomic snapshots, lz4 compression, and silent corruption detection. Tuning guide, backup automation scripts, and the real pitfalls.

Stop melting your DB with Grafana queries. TimescaleDB continuous aggregates pre-roll your metrics so dashboards stay fast even at 90-day ranges without pain.