Topic
Databases & Data Ops
Databases that just work — and the moves that keep them that way. Postgres tuning that isn't astrology, Redis/Valkey patterns, SQLite-as-a-real-database, MariaDB without the legacy ick, schema migrations on big tables without downtime, and the connection-pool / replication choices you'll thank yourself for later.
42 articles in this topic.
Featured posts
-
SurrealDB vs Postgres: Real or Toy?
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.
13 min read -
osm2pgsql Tuning for Modest Hardware
Stop watching osm2pgsql crawl. Tune flex output, slim mode, --cache, and Postgres for OSM imports on hardware that isn't a hyperscaler.
12 min read -
DBeaver vs pgAdmin vs DataGrip
Compare DBeaver, pgAdmin, and DataGrip for PostgreSQL and MySQL management. Free vs commercial picks, feature breakdown.
15 min read -
MongoDB Self-Hosted in 2026: SSPL and Alternatives
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.
14 min read -
PgBouncer for Connection Pooling
Why PgBouncer matters for home lab Postgres, connection pooling modes explained, config examples, and when prepared statements break.
16 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.
14 min read
All Databases & Data Ops articles
- SurrealDB vs Postgres: Real or Toy?
- osm2pgsql Tuning for Modest Hardware
- DBeaver vs pgAdmin vs DataGrip
- MongoDB Self-Hosted in 2026: SSPL and Alternatives
- PgBouncer for Connection Pooling
- SQLite Replication: Litestream and rqlite
- PostGIS for Self-Hosted Mapping
- pgvector for Local Embeddings
- Postgres Replication: Streaming + Logical
- Database Migrations: Liquibase vs Flyway vs Atlas
- MariaDB vs MySQL in 2026
- SQLite for Self-Hosted Apps
- Redis vs Valkey After the License Drama
- Postgres Backups: pg_dump vs pgBackRest vs WAL-G
- Postgres in Docker: The Durable Setup
- dbt-core for Self-Hosters: SQL With Tests, Without dbt Cloud
- Durable Objects: Stateful Serverless
- ClickHouse vs DuckDB vs StarRocks: Light OLAP
- Adding NOT NULL on a Big Table Without Downtime
- Postgres HA: Patroni + etcd + HAProxy
- Dragonfly vs Redis: Single-Binary Performance
- KeyDB: A Redis Fork With Multi-Threading
- pg_repack vs VACUUM FULL: Reclaim Bloat Live
- pg_stat_statements: What Most Tutorials Miss
- Postgres EXPLAIN ANALYZE Without Crying
- pgAdmin vs Adminer vs CloudBeaver: Web UIs
- PostgreSQL on ZFS: Tuning, Snapshots, Pitfalls
- TimescaleDB Continuous Aggregates Without Pain
- DuckDB for Local Analytics: Pandas on Steroids
- Neo4j vs ArangoDB: Graph DB Showdown
- Postgres vs SQLite for Home Lab Apps
- Qdrant vs Weaviate vs Chroma: Vector DB Showdown
- PostgreSQL + Linux: Kernel Tuning That Actually Matters
- MySQL & MariaDB CLI in 2026: What Changed
- Appwrite: Your Own Firebase, Minus the Google Surveillance Subscription
- NocoDB: Because Airtable Doesn't Need to Know Your Business
- Understanding PostgreSQL Connection URIs
- Wiki.js for your documentation in docker
- NocoDB DB Management System
- Automatic Backup of Docker MySQL or MariaDB Containers
- Repair & Optimize all Mysql Databases one liner
- MySQL CLI: From Connection to Maintenance