Comment by huijzer
5 hours ago
SQLite is a database. The main idea of a database is to support concurrent reads/writes although databases differ in how much concurrency they allow
5 hours ago
SQLite is a database. The main idea of a database is to support concurrent reads/writes although databases differ in how much concurrency they allow
The answer is more complicated for SQLite: https://sqlite.org/isolation.html
> There can only be a single writer at a time to an SQLite database. There can be multiple database connections open at the same time, and all of those database connections can write to the database file, but they have to take turns.
However, it can also be configured in WAL mode where the single writer is applying WALs while the applications append to the log.
The main idea of a database is to support storing data in a structured and queryable way. Concurrency came later.