Tag: databases

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.

Run PostgreSQL 18 on ZFS for atomic snapshots, lz4 compression, and silent corruption detection. Tuning guide, backup automation scripts, and the real pitfalls.

Stop melting your DB with Grafana queries. TimescaleDB continuous aggregates pre-roll your metrics so dashboards stay fast even at 90-day ranges without pain.

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.

Every RAG tutorial says 'just use Chroma.' Then you hit production. Here's what Qdrant, Weaviate, and ChromaDB actually offer and when each one earns its place.

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.

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.