6 ms·
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 on
by flicken 4y 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%20writers%20can%20simply%20take%20turns https://www.sqlite.org/whentouse.html#:~:text=multiple%20wri...