kopper @w.on-t.work · 14/07/2026lobste.rs/s/ko1ji1/lo… despite sounding like a simple announcement this seems like quite a nice collection of info on running sqlite """at scale""" (not the best words but you get the idea i thibk) 120
kopper @w.on-t.work · 14/07/2026one interesting thing with sqlite is its main downside (1 concurrent writer max) can be alleviated if you partition your database, which in something like postgres is only needed if you Scale Massively. like, the bluesky pds software uses sqlite, 131
kopper @w.on-t.work · 14/07/2026but partitions it so each user has their own sqlite file, with the expectation that one user won't ever write fast enough for sqlite to be the bottleneck. 120
