Tag: databases

DuckDB runs SQL directly on CSV, Parquet, and JSON files with no server and no import step required. Here is why it belongs in every home lab data toolkit.

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.

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.

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 is self-hosted BaaS: auth, databases, storage, and serverless functions on hardware you control. Docker setup plus a Supabase/PocketBase comparison.

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

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

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

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

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

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