Simon Willison’s Weblog

Subscribe

Thursday, 26th January 2023

[On SQLite for production concurrent writes] In general, WAL mode “just works” as Simon said. You just need to make sure you don’t have long running write transactions, although those are somewhat problematic in any database system. Don’t do stuff like starting a write txn and then calling a remote API and then committing. That’ll kill your write throughout.

Ben Johnson

# 7:36 pm / sqlite, ben-johnson

Guppe Groups. This is a really neat mechanism for helping build topic-oriented communities on Mastodon: follow @any-group-name@a.gup.pe to join (or create) a group, then that account will re-broadcast any messages from people in that group who mention the group in their message.

I found it via the histodons group. I was pondering how something like this might work this recently, so it’s great to see someone has built it already.

# 7:45 pm / mastodon, fediverse

2023 » January

MTWTFSS
      1
2345678
9101112131415
16171819202122
23242526272829
3031