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.
Plan database storage on block volumes for PostgreSQL and MySQL, including layout, capacity headroom, I/O monitoring, backups, and recovery.
Compare database migration services by scope, cost, downtime, provider responsibilities, validation, and rollback before choosing a migration provider or consultant.
Compare VPS database hosting with managed databases, including control, cost, backups, recovery, networking, and operational ownership for small teams.
Compare MySQL, PostgreSQL, and MongoDB by data model, ecosystem, performance, scaling, and operations to narrow a three-engine database decision.
Use this database migration checklist to assess compatibility, prepare the target, prove recovery, synchronize data, control cutover, validate production, and plan rollback.
Compare database hosting services for production apps by engine support, backups, PITR, HA, private networking, connections, pricing, migration, and support.
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.
Learn K3s default datastore behavior and compare SQLite, embedded etcd, and external PostgreSQL/MySQL/etcd for HA, quorum, backups, and recovery.
Understand PostgreSQL connection pooling, PgBouncer modes, pool sizing, max_connections, and how SaaS teams prevent connection storms in production.
Understand PostgreSQL for SaaS apps across sizing, connections, pooling, backups, high availability, and managed vs self-hosted production ownership.
PostgreSQL performance tuning for SaaS teams: query plans, indexes, vacuum, statistics, locks, connection pressure, and capacity decisions.
PostgreSQL high availability explained: architecture, synchronous vs asynchronous replication, failover, fencing, read replicas, application reconnects, and managed vs self-hosted HA.
Compare MongoDB vs PostgreSQL across data modeling, JSON, transactions, performance, scaling, and operations to choose the database that fits your application.
Compare Postgres hosting for SaaS across managed PostgreSQL and self-hosted PostgreSQL, including cost, connections, backups, HA, recovery, and operational ownership.
Plan a zero-downtime database migration with expand-contract, staged backfills, replication cutovers, rollback, and PostgreSQL or MySQL safety checks.
Compare PostgreSQL vs MySQL across performance, JSON, transactions, extensions, replication, use cases, migration, and managed hosting to choose the right database.
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