3 ms·
How do you workaround the fact that SQLite only supports a single writer? For example, your app could be blocked when you run a long operation like creating an
by ngrilly 9y ago
How do you workaround the fact that SQLite only supports a single writer? For example, your app could be blocked when you run a long operation like creating an index.
- hasenj 9y agoSQLite supports concurrent reads and writes since 2010 with the introduction of the "write ahead log" https://sqlite.org/wal.html https://sqlite.org/wal.html
- ngrilly 9y agoYes, but with a single writer at a time. From the link you shared: "However, since there is only one WAL file, there can only be one writer at a time".