Re:Consider SQLite
by benbjohnson on Wednesday December 29, 2021 @02:44PM
(#29729125)
Most writes only take tens to hundreds of microseconds and you can perform those writes from different processes serially. As long as you set WAL mode & a busy timeout then you should be fine:
PRAGMA journal_mode = WAL;
PRAGMA busy_timeout = 30000;