Tag: self-hosting

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.

PostGIS turns Postgres into a spatial database you own. Import OpenStreetMap with osm2pgsql, run spatial queries, and serve your own tiles through Martin.

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

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.

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

Garrul's 2026-05-25 roadmap promised moderation tools, a faster widget, and admin polish. 89 days and 53 releases later, here is the honest scorecard.

Head-to-head comparison of Unmanic and Tdarr transcode pipelines, config style, plugins, workers, GPU support, and when to pick each.

Batch transcode h264 to h265 or AV1 with Tdarr. GPU/CPU strategies, plugin flows, Docker Compose setup, and storage savings math for your media server.

HyperDX (ClickHouse, session replay) vs OpenObserve (Rust, cheap object storage), two modern self-hosted observability platforms compared for homelabbers.