#atproto Has anybody tried loading the Atmosphere into column stores like DuckDB or Clickhouse? Esp social graphs or backlinks? Column stores have an advantage with compression on the primary sort keys, and I'm curious how it compares against special-built indexes like Jaz's roaring bitmaps

Alright last month of the year, let’s finish on a high note

This is how I find out. RIP to a great one RE:

Bluesky Social

Bluesky

PSA: iMessage has backgrounds now

Sad for science that so much of the universe is anti matter

What does idk stand for

This Thanksgiving, I’m thankful that scientists have come close to inventing Spider-Man’s web shooters

The kinds of databases: • Fancy files • 1970s stays winning • This would be so cool if it worked at scale • Oh, that's why google has a monopoly on search

I've been playing around with backfill a lot. Dan's tool is giving me 40-50k records per second now. Increasingly leaning toward "capture the backfill in an LSM or similar" and then build your database from that

The recent discourse just goes to show how wise Apple was to never release a product called the “Pie.” Real industry foresight.