Data synchronization

[thanhnguyen2187]

After considering various options, I came up with this:

• In default/offline mode, we can use SQLite in the browser.
• In online mode (when we want to centralize our data), we can send SQLite queries to the specific "connection string".

Related libraries:

• https://github.com/rhashimoto/wa-sqlite
• https://docs.sqliterg.dev

[thanhnguyen2187]

Migration can be a real pain, as I had some dogfooding data that I would not want to lose.

[thanhnguyen2187]

Task list:

• [x] Make it works offline-wise
  • [x] Install and play with wa-sqlite
  • [x] Integrate SQLite querying to current stores
  • [x] Implement migration
  • [x] Initial creation
  • [x] Smaller changes
  • [x] From raw OPFS to SQLite in-browser
• [ ] Make it works online-wise
  • [ ] Install and play with sqliterg
  • [ ] Implement the UI for "connection string" and other cases
  • [ ] Integrate online SQLite querying to current stores

[thanhnguyen2187]

Food for thought: Turso may be a great backend, too.