SumGuy's Ramblings
The art of wasting time.
Docker, self-hosting, AI/LLM, Linux, and DevOps — explained by someone who learned the hard way. No fluff, no enterprise jargon, just practical stuff that actually works on real hardware.
Recent Posts
-
InfluxDB vs TimescaleDB vs VictoriaMetrics
Time-series database showdown. Cardinality limits, query language, retention policies, and which engine fits your monitoring stack.
10 min read -
SQLite Replication: Litestream and rqlite
Compare Litestream's continuous backup with rqlite's Raft replication for distributed SQLite. Learn when each fits your self-hosted setup.
8 min read -
PostGIS for Self-Hosted Mapping
Self-host map tiles with PostGIS. Import OSM data, query spatial data, serve tiles via Martin. No Google Maps tax.
7 min read -
pgvector for Local Embeddings
Run embeddings on Postgres with pgvector. Skip Chroma/Qdrant, tune IVFFlat vs HNSW indexes, build RAG pipelines locally.
10 min read -
Postgres Replication: Streaming + Logical
Postgres replication at home: when you need read replicas, streaming vs logical replication explained, slot management, conflict handling.
9 min read -
Database Migrations: Liquibase vs Flyway vs Atlas
Compare Liquibase, Flyway, and Atlas for schema migrations. Declarative vs imperative, CI integration, and which suits your home lab.
9 min read -
MariaDB vs MySQL in 2026
Fork futures: MariaDB's agile innovation vs MySQL's Oracle stewardship. Storage engines, JSON, replication, and why your choice matters now.
8 min read -
What Is an AI Harness?
What is an AI harness? A plain-language answer, plus 21 of them grouped by job: Claude Code, Codex CLI, Kilo Code, Goose, OpenHands and DeepSeek Harness.
20 min read -
SQLite for Self-Hosted Apps
Why SQLite is the secret weapon for self-hosted apps. WAL mode, concurrency limits, and when to actually leave it behind for Postgres.
7 min read -
Redis vs Valkey After the License Drama
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.
9 min read -
Postgres Backups: pg_dump vs pgBackRest vs WAL-G
Compare pg_dump, pgBackRest, and WAL-G for Postgres backups. Point-in-time recovery, S3 setup, and restore drills.
10 min read -
Postgres in Docker: The Durable Setup
Docker volumes, version pinning, health checks, and tuning. A production-ready Postgres Compose template with init scripts and backup strategy.
10 min read
