Production Database Operations: Backups, Monitoring & Optimization

# Production Database Operations: Backups, Monitoring & Optimization

Choosing Your Database Platform

Neon (Serverless PostgreSQL) `bash # Connection string format DATABASE_URL="postgresql://user:pass@ep-cool-name-123456.us-east-2.aws.neon.tech/mydb?sslmode=require" ` - Killer feature: Branching — create a copy of your database for each PR, just like git branches - Auto-scaling: Scales to zero when idle, scales up under load - Free tier: 0.5 GB storage, generous compute hours - Best for: Next.js on Vercel, teams that want database branching

Supabase (PostgreSQL + extras) `bash DATABASE_URL="postgresql://postgres.[ref]:[password]@aws-0-us-east-1.pooler.supabase.com:6543/postgres" ` - Killer feature: Built-in auth, real-time subscriptions, storage, edge functions - Free tier: 500 MB database, 1 GB storage, 50K monthly active users - Best for: Projects that want an all-in-one backend (auth + database + storage)

PlanetScale (MySQL-compatible) - Killer feature: Non-blocking schema changes, deploy requests (like PRs for schemas) - Best for: Teams that need MySQL compatibility or very large scale