Tag: databases

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.

SQLite is brilliant until you need concurrent writes, replication, or online migrations. Here's the actual line where Postgres earns its keep.

NocoDB wraps any SQL database in a spreadsheet UI — self-host an Airtable alternative on top of MySQL, PostgreSQL, or SQLite with Docker.

Repair and optimize all MySQL databases at once with mysqlcheck — a one-liner that runs on every table without logging into MySQL.

Decode the postgresql:// connection string — host, port, database, SSL mode, and the gotchas that cause connection refused at deploy time.

A kernel upgrade halved one team's PostgreSQL throughput. The fix was kernel tuning: huge pages, THP, swappiness, I/O scheduler. Here's what matters and why.

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

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

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

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

Wiki.js is a gorgeous self-hosted wiki with Markdown, WYSIWYG, and Git sync — Docker Compose setup with PostgreSQL backend.

Automate MySQL/MariaDB backups from a running Docker container using cron and mysqldump — no downtime, no excuses for losing your data.