Iroh-examples: Example how to sync a sqlite database

[rklaehn]

Use a sqlite database locally
Use the sqlite VFS for change tracking (or do brute force rehash)
Sync the sqlite database to other nodes
Have a "compute over data" thing that reads multiple sqlite dbs and updates an aggregated sqlite db.

https://www.sqlite.org/vfs.html

[s2dd]

instead of VFS maybe just do selects on aggregate and update accordingly ?

• iroh-node with sqlite has a table with sequential id's
• when local act on table iroh-node notifies aggregate, then fetch from aggregate for aggregates sequental id replicated
• iroh-node chrono aggregate select for last id compares with own and do a select on aggregate for fetch [new] range
• if request is not in local (inbetween chrono sync) node selects on aggregate
• aggregate need have trigger for id that changed [updated deleted] in separate table ts-id with field id, that iroh-node can select on and update its synced local since last ts-id range

besides syncing sqlites tables in iroh-band it could also index as mentioned elsewhere for gateway supernodes etc.

• table with humanized key's containing tickets and / or addrs derp hash]type] fields

[s2dd]

how about mix and match with DuckDB ? it has a sqlite extension a rust client and several imports

http://duckdb.org/docs/extensions/sqlite
http://duckdb.org/docs/extensions/inet