I hate how online shopping involves so much CGI, so I'm not only checking if reviews are fake, if the products are just some AutoCAD rendering or if the material seems to match what's advertised but if the product ACTUALLY exists. Online shopping had a value, but it's really the pits now.

Something I love about the Walking Dead is how much love people tend to have for one another despite the amount of loss and trauma they've gone through. That level of care for community, maybe just a plot point.

Jilly Boel (@nebkor@socialnotwork.net)

@jalcine@todon.eu have you seen https://litestream.io/ ? Streaming replication for sqlite. I'm not sure about schema changes, but if you're putting those into a table a client could see them and act appropriately.
↑ byThe Social Notwork • archived copy • current

I have! I'm looking for something that'd work as an extension to SQLite itself, so I can include it in client applications.

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 copy • current

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.

Jilly Boel (@nebkor@socialnotwork.net)

@jalcine@todon.eu my thinking on this has been if you have unique primary keys, you can pretty naively merge remote tables together. That's why I created Julids, 128-bit sortable globally unique IDs, with a sqlite plugin to support using them:https://crates.io/crates/julid-rs
↑ byThe Social Notwork • archived copy • current

Oh, this is interesting. I can see that working for that case. I'm reaching a bit further now, wondering how to communicate schema changes so both databases are working with the correct version.

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.

One thing about The Walking Dead that annoys me is how improbable and expensive Daryl's motorcycle is. Like where are we getting this gas? All so you can zoom around? GO GET A BIKE!

So I have a LG 4K monitor I got from Glitch and a Lenevo 2K monitor. And frankly, reading text on the 2K monitor is better than the scaled down version of it on my 4K. I think the pixel density of a 4K screen at 100% is too small but even still so with it at 200%.

Today's the birthday of the late bell hooks. She's contributed a tremendous amount of my understanding of self, my community and the world around me. My only regret is that I hadn't spent more time reading her work sooner.

Jenniferplusplus (@jenniferplusplus@tech.lgbt)

@ch0ccyra1n@emeraldsocial.org @jalcine@todon.eu It doesn't. That's the problem. The ActivityPub spec isn't actually complete in the sense that you could just implement it and have a working app when you're done. These gaps have to be filled somehow, and mastodon is the app that got critical mass at the right time to make everyone else follow their lead.
↑ byLGBTQIA+ Tech Mastodon • archived copy • current

I know there's interest in making it more decentralized using DIDs but that seemed to be dominated by crypto folks. I'm resisting speaking on a project because it's still in pre-alpha, but if more client Mastodon apps played with other storage formats for posts, we might be able to slowly move people away from requiring WebFinger by default.

But I agree, some base system for this needs to be defined (and frankly, I'm tempted to promote something like the rel=me approach, a JSON file that's looked for or even as a child tag in the HTML of the URL being looked up, something friendly to static systems).

Maybe it's because I filter a lot of it out but you know one thing I don't see a lot on the Fediverse (at least not anymore?): public advocates of cryptocurrency. Could also who I follow.

I wrote another newsletter entry at https://buttondown.email/jackyalcine/archive/ive-been-laid-off/. Taking this weekend to focus on important things but also to do something I do enjoy doing; and that's tinkering with side projects and/or reading some comics.

Tonight, I'll be reading Avatar: The Last Airbender - The Search inbetween builds and when I want to take a little thinking break. I'll be working on making #Koype a bit more ready for me to talk about more concretely but from way down the pipe. Right now, I'm focusing on fixing up RPC logic. And yes, there's RPC in my blog setup because it's definitely a lot more than a blog (again, why I need to write more about this, lol).

The process of me doing this today: is a bit manual (I write locally, tether over my phone to my laptop, make this post, write it in manual HTML in quill.p3k.io and make sure to syndicate it from my site (though that's just a button in Quill itself to enable). My hope is to write this from some native client on my desktop, pick up my phone - edit it and then open my website and see the final change there. That's because I want to get to a point where I don't have to be online to "blog" or just record my life to the extent that I want to.

But again, relaxing. Part of relaxing is allowing myself to dream (lol) and tinker. So that I will.

Some posting readjustments:

  • In the spirit of doing it manually until it hurts, I'll be moving more of my book reading and progress to @jacky@bookwyrm.social for now. Long-term goal is to have it come from my own website and syndicate elsewhere.
  • I'll be using my newsletter more for "round-up" posts of longer-form things I've been reading, quite similar to how @beep@follow.ethanmarcotte.com does with their site.

Frankly, this means I have to sit down and code more. It's actually relaxing to tinker on my own stuff. Closest I come to being crafty.

I sorely need a Calibre-to-Bookwyrm extension, so I can more easily update my status from my library.

Tangentially, does anyone keep an index of their physical book reading list in something like Calibre? I've been considering making another "virtual" library to track that (but I'll definitely have some duplicates).