Tag: databases

SurrealDB promises documents, graphs, search and realtime in one binary. I tested it against Postgres to see where that pitch holds up for self-hosters in 2026.

Compare DBeaver, pgAdmin, and DataGrip for PostgreSQL and MySQL management. Free vs commercial picks, feature breakdown.

The SSPL only bites if you offer MongoDB itself as a service. What that means for self-hosters, and when FerretDB on Postgres is the better answer.

Why PgBouncer matters for home lab Postgres, connection pooling modes explained, config examples, and when prepared statements break.

Compare Litestream's continuous backup with rqlite's Raft replication for distributed SQLite. Learn when each fits your self-hosted setup.

Postgres replication at home: when you need read replicas, streaming vs logical replication explained, slot management, conflict handling.

Compare Liquibase, Flyway, and Atlas for schema migrations. Declarative vs imperative, CI integration, and which suits your home lab.

Fork futures: MariaDB's agile innovation vs MySQL's Oracle stewardship. Storage engines, JSON, replication, and why your choice matters now.

Why SQLite is the secret weapon for self-hosted apps. WAL mode, concurrency limits, and when to actually leave it behind for Postgres.

Redis went source-available, then back to AGPL. When to migrate to Valkey or KeyDB, persistence and clustering options, and what matters for self-hosters.

pg_dump, pgBackRest, and WAL-G compared for Postgres backups. Point-in-time recovery, S3 setup, retention policy, and the restore drill to run today.

Docker volumes, version pinning, health checks, and tuning. A production-ready Postgres Compose template with init scripts and backup strategy.