Litestream is 🔥
Goodbye PostgreSQL
With Prisma having SQLite as a provider and Litestream replicating globally in a matter of milliseconds with virtually no setup required when hosting on Fly.io, I don't ever see myself going back to running a DB server. It's just not worth it for the type of apps I like to build for fun.
This site for example is hosted in 19 regions on Fly.io and posts replicates between all of them in less than 300ms.