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.
36 articles in this topic.
Featured posts
-
DBeaver vs pgAdmin vs DataGrip
Compare DBeaver, pgAdmin, and DataGrip for PostgreSQL and MySQL management. Free vs commercial picks, feature breakdown.
15 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 -
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.
11 min read -
pgvector for Local Embeddings
Run embeddings on Postgres with pgvector. Skip Chroma/Qdrant, tune IVFFlat vs HNSW indexes, build RAG pipelines locally.
14 min read -
Postgres Replication: Streaming + Logical
Postgres replication at home: when you need read replicas, streaming vs logical replication explained, slot management, conflict handling.
14 min read
All Databases & Data Ops articles
- DBeaver vs pgAdmin vs DataGrip
- PgBouncer for Connection Pooling
- SQLite Replication: Litestream and rqlite
- PostGIS for Self-Hosted Mapping
- pgvector for Local Embeddings
- Postgres Replication: Streaming + Logical
- 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
- 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
- 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