[sgt]

I'd use PowerSync for this:

https://powersync.com/

People are often blown away by the real time reactivity.