Has anyone tried ElectricSQL? Looks amazing.
The ability to effectively use multi-tenant SQLite but aggregate shared data into a postgres database is amazing. And they help you with migrations etc. This is exactly the ideal setup I've been looking for!
But the main benefit to me would be that user data will be more private and protected and configurable.
This gives someone much more fine-grained control over their data and how their data is stored. I think it ultimately makes the attack vector space smaller for any client data.