Fauna is a truly serverless database which is awesome if you are deploying to a serverless environment like Vercel because you don't have to worry about connection pools.
You can remove Prisma, which comes in new Blitz apps by default, and replace it with Fauna.
We have an official Blitz + Fauna example app that shows how to integrate Fauna with Blitz and with the Blitz authentication system.