Topic
Databases & Data Ops
Databases that just work — and the moves that keep them that way. Postgres tuning that isn't astrology, Redis/Valkey patterns, SQLite-as-a-real-database, MariaDB without the legacy ick, schema migrations on big tables without downtime, and the connection-pool / replication choices you'll thank yourself for later.
24 articles in this topic.
Featured posts
-
ClickHouse vs DuckDB vs StarRocks: Light OLAP
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.
11 min read -
Adding NOT NULL on a Big Table Without Downtime
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.
11 min read -
Postgres HA: Patroni + etcd + HAProxy
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.
12 min read -
Dragonfly vs Redis: Single-Binary Performance
DragonflyDB vs Redis 7.4 and Valkey 8.x: architecture deep dive, real performance benchmarks, honest gotchas, and when to swap your cache layer for a dragon.
10 min read -
KeyDB: A Redis Fork With Multi-Threading
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.
10 min read -
pg_repack vs VACUUM FULL: Reclaim Bloat Live
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.
12 min read
All Databases & Data Ops articles
- ClickHouse vs DuckDB vs StarRocks: Light OLAP
- Adding NOT NULL on a Big Table Without Downtime
- Postgres HA: Patroni + etcd + HAProxy
- Dragonfly vs Redis: Single-Binary Performance
- KeyDB: A Redis Fork With Multi-Threading
- pg_repack vs VACUUM FULL: Reclaim Bloat Live
- pg_stat_statements: What Most Tutorials Miss
- Postgres EXPLAIN ANALYZE Without Crying
- pgAdmin vs Adminer vs CloudBeaver: Web UIs
- PostgreSQL on ZFS: Tuning, Snapshots, Pitfalls
- TimescaleDB Continuous Aggregates Without Pain
- DuckDB for Local Analytics: Pandas on Steroids
- Neo4j vs ArangoDB: Graph DB Showdown
- Postgres vs SQLite for Home Lab Apps
- NocoDB DB Management System
- Repair & Optimize all Mysql Databases one liner
- Understanding PostgreSQL Connection URIs
- PostgreSQL + Linux: Kernel Tuning That Actually Matters
- MySQL CLI: From Connection to Maintenance
- MySQL & MariaDB CLI in 2026: What Changed
- Appwrite: Your Own Firebase, Minus the Google Surveillance Subscription
- NocoDB: Because Airtable Doesn't Need to Know Your Business
- Wiki.js for your documentation in docker
- Automatic Backup of Docker MySQL or MariaDB Containers