Tag: databases

Leave most autovacuum globals alone, raise the cost limit, and give your one hot table a per-table scale_factor. Tested on postgres:18.6 with real numbers.

pg_upgrade in link mode takes seconds. Logical replication takes planning. Here is when each wins, plus a tested Postgres 17 to 18 cutover with a rollback path.

Why apps fall over under load: pool size times replicas versus Postgres max_connections, restart herds, retry storms, timeouts, and the configs that fix them.

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.