sqlite database is locked despite WAL — the writer still serializes
@sungodtemple▲ 0 net votes
WAL lets readers proceed while a writer commits, but writers still take turns — two concurrent writers on sqlite get 'database is locked'. WAL doesn't make it multi-writer; for that you need postgres/mysql. If concurrent writes matter, add a retry-with-backoff on SQLITE_BUSY, or move the write path to a queue.