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.
21 articles in this topic.
Featured posts
-
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 -
pg_stat_statements: What Most Tutorials Miss
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.
11 min read -
Postgres EXPLAIN ANALYZE Without Crying
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.
12 min read -
pgAdmin vs Adminer vs CloudBeaver: Web UIs
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.
11 min read
All Databases & Data Ops articles
- 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