8 tutorials · 17 guides
Install PostgreSQL 18 on a Raff Ubuntu 24.04 VM. Add PGDG, create a database role, verify SCRAM, secure port 5432, and test backup and restore safely.
Self-host Supabase on Ubuntu 24.04 with the versioned Docker Compose stack, Caddy HTTPS, secure keys, Postgres and Storage backups, restores, and safe updates.
Deploy Odoo 19 on Ubuntu 24.04 with Docker Compose, PostgreSQL 15, Caddy HTTPS, workers, database lockdown, matched backups, restores, and safe updates.
Back up PostgreSQL to S3-compatible Raff Object Storage with Restic on Ubuntu 24.04. Automate encrypted dumps, retention, checks, and restore tests.
Self-host Plausible Analytics CE on Ubuntu 24.04 with Docker Compose, automatic HTTPS, protected secrets, health checks, backups, and safe upgrades.
Deploy a multi-container Docker Compose app on Ubuntu 24.04 with Node.js, PostgreSQL, Redis, secrets, health checks, private networking, backups, and persistence.
Deploy Gitea on Ubuntu 24.04 with Docker Compose, PostgreSQL, Nginx, HTTPS, SSH clone access, backups, upgrades, and verification steps.
Self-host n8n on Ubuntu 24.04 with Docker Compose, PostgreSQL, Nginx, HTTPS, safe firewall setup, backups, restore verification, and updates.
Compare database migration services by scope, cost, downtime, provider responsibilities, validation, and rollback before choosing a migration provider or consultant.
Compare database hosting services for production apps by engine support, backups, PITR, HA, private networking, connections, pricing, migration, and support.
Compare VPS database hosting with managed databases, including control, cost, backups, recovery, networking, and operational ownership for small teams.
Plan database storage on block volumes for PostgreSQL and MySQL, including layout, capacity headroom, I/O monitoring, backups, and recovery.
Use this database migration checklist to assess compatibility, prepare the target, prove recovery, synchronize data, control cutover, validate production, and plan rollback.
Compare PostgreSQL replication, backups, point-in-time recovery, and snapshots by the failure modes each protects and the recovery gaps each leaves.
Compare managed database vs self-hosted across total cost, control, backups, HA, recovery, security, scaling, and operational ownership for production workloads.
Compare MySQL, PostgreSQL, and MongoDB by data model, ecosystem, performance, scaling, and operations to narrow a three-engine database decision.
Learn K3s default datastore behavior and compare SQLite, embedded etcd, and external PostgreSQL/MySQL/etcd for HA, quorum, backups, and recovery.
PostgreSQL performance tuning for SaaS teams: query plans, indexes, vacuum, statistics, locks, connection pressure, and capacity decisions.
Learn PostgreSQL high availability: compare standby replication, automatic failover, fencing, recovery testing, and managed vs self-hosted trade-offs.
Understand PostgreSQL for SaaS apps across sizing, connections, pooling, backups, high availability, and managed vs self-hosted production ownership.
Understand PostgreSQL connection pooling, PgBouncer modes, pool sizing, max_connections, and how SaaS teams prevent connection storms in production.
Learn PostgreSQL vs MySQL trade-offs in JSON, extensions, transactions, performance, replication, and recovery. Choose by workload, team, and ecosystem fit.
Compare Postgres hosting for SaaS across managed PostgreSQL and self-hosted PostgreSQL, including cost, connections, backups, HA, recovery, and operational ownership.
Compare MongoDB vs PostgreSQL across data modeling, JSON, transactions, performance, scaling, and operations to choose the database that fits your application.
Plan a zero-downtime database migration with expand-contract, staged backfills, replication cutovers, rollback, and PostgreSQL or MySQL safety checks.
The tutorials, guides, and comparisons we publish, rounded up in one weekly email. Unsubscribe anytime.
Spin up a Linux or Windows server and follow any tutorial here on real infrastructure. RDP and SSH ready, 14-day money-back guarantee.
Deploy a server