News for hackers. Stuff that matters.
Re:Bluesky Is Not Decentralized by avinassh on Saturday October 26, 2024 @09:00AM (#41954482)
related: any high level architecture details on how BlueSky uses SQLite per user?
Re:Bluesky Is Not Decentralized by Natanael_L on Saturday October 26, 2024 @08:15PM (#41958798)
It's used in a not particularly advanced way - bluesky uses repositories per each user for all their public social activity (posts, likes, etc) and it creates a Merkle tree as an index for them and signs that index (this enables stuff like authenticated content addressing and efficient verification).

SQLite simply stores those posts and that signed Merkle tree. The PDS account host server also has another SQLite DB with a list of its accounts.

They have fancier stuff in their appview server and relay server