orbitinghail / sqlsync

SQLSync is a collaborative offline-first wrapper around SQLite. It is designed to synchronize web application state between users, devices, and the edge.
https://sqlsync.dev
Apache License 2.0
2.19k stars 28 forks source link

schema migrations #1

Open carlsverre opened 10 months ago

carlsverre commented 10 months ago

schema migrations (raw notes)

Basic idea is to add another api to the reducer which is used to trigger migrations when documents are created or versions change.

This is more robust than the current "InitSchema" mutation which is difficult to coordinate.

This will be the first pass on figuring out sqlsync's upgrade story. Eventually it needs to encompass the sqlsync runtime version, the reducer version, the sqlite schema version across both the client(s) and server.