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.
12 articles in this topic.
Featured posts
-
Neo4j vs ArangoDB: Graph DB Showdown
Neo4j is the household graph DB with Cypher. ArangoDB is multi-model with AQL and free clustering. Here's which one fits your homelab graph use case.
10 min read -
Postgres vs SQLite for Home Lab Apps
SQLite is brilliant until you need concurrent writes, replication, or online migrations. Here's the actual line where Postgres earns its keep.
12 min read -
NocoDB DB Management System
NocoDB wraps any SQL database in a spreadsheet UI — self-host an Airtable alternative on top of MySQL, PostgreSQL, or SQLite with Docker.
· Updated:5 min read -
Repair & Optimize all Mysql Databases one liner
Repair and optimize all MySQL databases at once with mysqlcheck — a one-liner that runs on every table without logging into MySQL.
· Updated:6 min read -
Understanding PostgreSQL Connection URIs
Decode the postgresql:// connection string — host, port, database, SSL mode, and the gotchas that cause connection refused at deploy time.
· Updated:5 min read -
PostgreSQL + Linux: Kernel Tuning That Actually Matters
An AWS engineer found Linux 7.0 halved their PostgreSQL performance. The fix was kernel tuning. Here's what settings matter and why, so you're not the last to know.
6 min read
All Databases & Data Ops articles
- 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