Offline-first support

[website-features]

I would love to be able to use SpacetimeDB in an app that:

1. robustly handles disconnection from a server, and then syncs and catches up when it reconnects
2. propagates updates locally immediately first, and rolls back or corrects if necessary after propagation to the server

This would be similar to what replicache enables.

[maxgeorg99]

I stumbled up on https://github.com/powersync-community/powersync-convex-todolist-demo which is an experimental way of integrating a Local sqlLite with Convex. Maybe the Power Sync community could also help to Build a spacetimeDB Integration 🤔