|
|
|
|
|
by mixmastamyk
713 days ago
|
|
Looks neat as I want to try making a local-first app. Though this seems to require React. Is that the case or will it work with vanilla JS? Also not yet sure how I'd send an edited sqlite db to a backend like LiteFs—looks like Sqlite3Persister is the interface. |
|
The way to do that would be to listen to data changes (eg addCellListener) and in the listener just manipulate the DOM directly. Probably a pretty slick approach, performance-wise.
For SQLite, a variety of flavors are supported including things like ElectricSQL, Turso, and PowerSync - which all let you sync back to a server. You might also consider running a ‘client’ on a server that can listen to changes coming through web sockets and persist itself to server storage - but I haven’t written that pattern up yet.
Hopefully you’ll get a chance to try it out in the meantime though!