also `goat syntax tid check 3m3zm7eurxk26`

aw thanks! it's important to keep everyone moving!

you can also designate clients as trusted. secretly already in there 👀 github.com/bluesky-soci...

canon!!

sounds eerily similar to postgres autovacuum

node, deno, and bun now all have native sqlite!!

going to start using this instead of "hello world"

i think these techniques could technically work together: process as much as you can in memory streaming, and once you hit an unexpected block, flush the rest to a tmp sqlite then walk the rest from disk.

nice! i'm mucking around with repo validation right now too! i have a little disk to spare and am interested in keeping memory footprint low, so i'm streaming blocks to sqlite on disk, then walking the mst using sqlite. i think @retr0.id and i had a similar inclination there.

i can get into that

what is it this time...

thanks for showing us all zeppelin, that was badass. if you end-up sharing any long-form thoughts on the project i will be eager to read them