Hacker News new | ask | show | jobs
by flicken 1485 days ago
SQLite does support multiple writers, they take turns:

> SQLite only supports one writer at a time per database file. But in most cases, a write transaction only takes milliseconds and so multiple writers can simply take turns. SQLite will handle more write concurrency than many people suspect. Nevertheless, client/server database systems, because they have a long-running server process at hand to coordinate access, can usually handle far more write concurrency than SQLite ever will.

Source: https://www.sqlite.org/whentouse.html#:~:text=multiple%20wri...