Connection Pooling PostgreSQL with PgBouncer
Put PgBouncer in front of PostgreSQL 16 so app workers share a small pool of backends instead of opening one backend process per HTTP request.
Databases9 min read
NetBay journal
Databases
44 practical Databases articles from Netbay Engineering — written for operators running Linux and Windows VPS in India.
44 articles in this topic
AllLinuxLinux AdministrationWindowsLinux SecurityLinux NetworkingContainersContainers & OrchestrationKubernetesCI/CDGitHubSelf-HostingBackups & DataDatabasesApp DeploymentDNS & TLSObservabilityEmailAI AgentsAI InfrastructureAPI & AutomationProxiesCloud ArchitectureHardware & PerformanceDevOps Practices
When a MariaDB Replica on a Second VPS Is Worth It
Know when a MariaDB replica on a second VPS earns its keep for reads and backups, and when it only adds lag, failover fiction, and extra cost.
Databases9 min read
redis-cli Diagnostics: INFO, SLOWLOG, MEMORY
Diagnose a live Redis with INFO, SLOWLOG, and MEMORY so you can catch slow commands, memory growth, and eviction pressure before the VPS starts swapping.
Databases8 min read
SQLite .backup and VACUUM INTO While the App Runs
Take a consistent SQLite snapshot from a live app with VACUUM INTO or .backup, then restore beside the original without stopping writes in production.
Databases8 min read
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
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