I find the opposite approach of local-first (database in the client).
It fits more solutions and solves many more things (free offline, syncing, undo support) and getting rid of caching, retries, and latency.
Of course the industry wants you to want more on the server though.
Same view applies to RSC (react server components).
Embrace CRDTs.