Would ATTACH'ed Sqlite databases support parallel writes from multiple threads?

Question

I'm trying to understand if using the ATTACH DATABASE feature of Sqlite allows a single process use 2 threads to write to two databases in parallel.

There are a number of questions and answers clarifying how using WAL allows Sqlite to support multiple writer threads to a database, but I could not find a document or question that clarifies how writes from different threads to multiple databases work.

The documentation of ATTACH DATABASE says:

Transactions involving multiple attached databases are atomic, assuming that the main database is not ":memory:" and the journal_mode is not WAL. If the main database is ":memory:" or if the journal_mode is WAL, then transactions continue to be atomic within each individual database file.

This makes me think that N databases would have N dedicated WALs and a write to a database would be independent of other databases.

I'm hoping I can use multiple files for multiple databases, where db files reside on different disks.

question from:https://stackoverflow.com/questions/65645065/would-attached-sqlite-databases-support-parallel-writes-from-multiple-threads

Answer 1

Waitting for answers