Tag: databases

Redis went source-available, then back to AGPL. When to migrate to Valkey or KeyDB, persistence and clustering options, and what matters for self-hosters.

pg_dump, pgBackRest, and WAL-G compared for Postgres backups. Point-in-time recovery, S3 setup, retention policy, and the restore drill to run today.

Docker volumes, version pinning, health checks, and tuning. A production-ready Postgres Compose template with init scripts and backup strategy.

Run dbt-core free with Postgres, DuckDB, or ClickHouse. SQL transformations, tests, docs, and star schemas without the dbt Cloud price tag.

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.