Is there an out-of-the-box solution that just does all of this - as a hosted solution, a boilerplate, or a best-practices example? Maybe Supabase could do it? Would be nice to one-click deploy a Postgres with cache and auditing and the rest of it.

If you can use Postgres, maybe you can use SQLite.