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!
