The biggest design mistake I made when we moved OC to sqlite: using sync db access. When it was just an agent that reports to you on Slack or iMessage this was fine; now that one agent might do 50 sessions in parallel and the whole team works on it, it is limiting. I have a
Sync SQLite access became an OC bottleneck
steipete says synchronous SQLite access worked for one reporting agent, but falters when agents run 50 parallel sessions and whole teams collaborate.