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.

10 articles in this topic.

Featured posts

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.

7 Apr, 2026
6 min read
MySQL CLI: From Connection to Maintenance

Master MySQL from the command line: connect, query databases, manage users, repair tables, optimize—everything you keep Googling, one reference.

Updated: 5 Apr, 2026
5 min read
MySQL & MariaDB CLI in 2026: What Changed

MySQL 8.0 broke auth, MariaDB forked hard, and Docker changed how you connect. Here's what still works and what'll bite you.

5 Mar, 2026
7 min read
Appwrite: Your Own Firebase, Minus the Google Surveillance Subscription

Appwrite self-hosted BaaS setup: auth, databases, storage, and serverless functions on your own hardware. Compare with Supabase and PocketBase.

15 Jan, 2026
8 min read
NocoDB: Because Airtable Doesn't Need to Know Your Business

NocoDB self-hosted: connect to existing Postgres/MySQL, build spreadsheet views, auto-generate APIs, and skip the Airtable subscription forever.

16 Nov, 2025
8 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.

8 Mar, 2024
2 min read

All Databases & Data Ops articles