The cost equation
Supabase's free tier is generous until you need 500 tenants. At $25/month per project, multi-tenant gets expensive fast. PocketBase is a single binary that costs $5/month to host — for unlimited tenants.
SQLite performance
For read-heavy workloads (which a blog CMS absolutely is), SQLite outperforms PostgreSQL because there's no network hop between the application and the database.
Operational simplicity
One binary, one data file, zero dependencies. Backup is literally copying a file. Restore is pasting it back. No connection pools, no migrations that require downtime.
decisions