A big thank you to everyone who's helped me reach my current fundraiser for support. I couldn't have done this without y'all.

I replied to the following: ↷

In my continued (series of failures of an) attempt to make SQLite a local-first peerable database, I'm peeking at the sessions extension and wanted to record changes, at least in a structured form. I got some sample code I thought would work over at https://git.jacky.wtf/me/sqlite-sync/src/commit/798540e1bb609d1b91f360c1f85f5e0cf61d7c67/src/lib.rs#L106-L154. I just had this working two days ago when I was more disconnected from life.

The hope is that if I can record database actions and fuse in something like https://crates.io/crates/rusqlite_migration, I wonder if then having a table of migration data being peered could help as well. Immediately, I'm like "what, auto-updates? nah" so I'll have to think on that more.

For now, I need to just make a list of changes to this database.

byhttps://jacky.wtf • posted archived copycurrent

Okay, so I got this part working pretty easy. I might need a few SQL scripts as test cases, but I can capture the changes made. Now to make it possible to apply those changes. Next could be making it easy to serialize those changes as a stream. Allows for a bunch of other angles of use. Let's keep this going, lol.

Engagement is powered by Webmentions — a premier standard of the Web to let other sites know you've mentioned them. Learn how to reply from your own site. or from a supported silo Aaron has an interactive post about this. If you've mentioned this URL via another one, use the form below to submit it.

If you don't currently own your replies, then you can click below to do so.

I currently aim to own my comments and plan to eventually show those I've received once I finish Lighthouse.