Thank you for the detailed answer, you're awesome.
Electric-SQL, Convex, and Triplit are definitely relevant, and I'll dive deep into understanding their pros and cons.
In the meantime, I found another relevant one: https://squid.cloud/, which has a slightly different approach, more like full BAAS.
On one end, it can save me some time; on another, it's another stack my R&D needs to be familiar with.
Electric-SQL, Convex, and Triplit are definitely relevant, and I'll dive deep into understanding their pros and cons. In the meantime, I found another relevant one: https://squid.cloud/, which has a slightly different approach, more like full BAAS.
On one end, it can save me some time; on another, it's another stack my R&D needs to be familiar with.