3 ms·
SQLite works fine with more than one process accessing the database, provided those processes are on the same machine and not attempting to coordinate over some
by simonw 2y ago
SQLite works fine with more than one process accessing the database, provided those processes are on the same machine and not attempting to coordinate over something like NFS.
You can connect to an in-use SQLite database using other tools (like the sqlite3 CLI tool or my https://datasette.io https://datasette.io local web app) just fine.
The only thing to avoid is long running write operations, since those will block writes from other processes for their duration.
Enabling WAL mode avoids errors if you try to read while some other process is performing a write.
You can test this yourself: fire up a few terminal terminal windows and run sqlite3 multiple times against the same file on disk and see what happens.