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.