WAL and PITR: When a pg_dump Is Not Enough
Turn on WAL archiving, take a base backup, and restore to a chosen timestamp so a bad write does not cost you a full day of PostgreSQL data.
Databases9 min read
NetBay journal
Databases
40 practical Databases articles from Netbay Engineering — written for operators running Linux and Windows VPS in India.
40 articles in this topic
AllLinuxLinux AdministrationWindowsLinux SecurityLinux NetworkingContainersContainers & OrchestrationKubernetesCI/CDGitHubSelf-HostingBackups & DataDatabasesApp DeploymentDNS & TLSObservabilityEmailAI AgentsAI InfrastructureAPI & AutomationProxiesCloud ArchitectureHardware & PerformanceDevOps Practices
Charsets, Collations, and utf8mb4 from Day One
Set utf8mb4 and a modern collation at create time so emoji, Hindi text, and joins do not become a painful migration project later on a live VPS.
Databases8 min read
Redis Pub/Sub: When to Use It and When Not
Use Redis pub/sub for live fan-out on one host, and skip it when you need persistence, retries, or consumer groups that Streams already provide.
Databases8 min read
Replicate SQLite to Object Storage with Litestream
Ship SQLite WAL frames to S3-compatible object storage with Litestream so a single VPS file has an off-site replica you can restore on demand.
Databases8 min read
Backup with pg_dump and Restore One Database
Dump one PostgreSQL database in custom format, store it off the data disk, and restore it with pg_restore into a clean target cluster safely.
Databases8 min read
SQLite Indexes and Why LIKE %x Will Not Use Them
SQLite B-tree indexes match left-most prefixes, so LIKE with a leading percent cannot seek; use suffix indexes, FTS, or a stored reverse column.
Databases8 min read
Slow Query Log and EXPLAIN for MySQL on a VPS
Enable the slow query log, read EXPLAIN without folklore, and fix the table scans that actually burn CPU on a busy production MariaDB VPS host.
Databases9 min read
Use Redis as a Session Store for a Web App
Store web sessions in Redis with short keys, SETEX TTLs, and cookie hygiene so logins survive app restarts without turning Redis into a public session dump.
Databases8 min read
Indexes That Get Used: PostgreSQL EXPLAIN Basics
Read EXPLAIN ANALYZE until you can tell a Seq Scan from an Index Scan, then add btree indexes that match filters, joins, and ORDER BY clauses.
Databases9 min read
sqlite3 CLI: .schema, EXPLAIN QUERY PLAN, ANALYZE
Use sqlite3 .schema, EXPLAIN QUERY PLAN, and ANALYZE on the live file to see what SQLite stores, how it will read it, and which indexes it trusts.
Databases8 min read
MariaDB Binary Logs and Point-in-Time Recovery
Turn on MariaDB binary logs, take a consistent dump, and practice point-in-time recovery so a bad write is not a full-day restore from last night.
Databases9 min read
Redis Cache in Front of Postgres or MySQL
Put Redis in front of Postgres or MySQL with cache-aside reads, write-time invalidation, and TTLs so the cache stays a speed layer, not a second database.
Databases8 min read