Multiple instances of SQLite database open simultaneously on different threads (QT)

Question

Is there a problem while using multiple open connections from different threads at the same time?

From what I read, it is still safe by default, but can this degrade performance rather than improve it?

Answer 1

the documentation says:

A connection can only be used from the thread that created it. Moving connections between threads or creating requests from another thread is not supported.

, , QSqlDrivers, SQL . .

, , . docs QSqlDatabase :

QSqlDatabase .

QSqlDatabase . QSqlDatabase . , QSqlDriver.

(, QSqlDatabase), addDatabase(), (, ?) .

addDatabase() - .

Renzo , SQLite . , () , - . docs.

Answer 2

, , , - , SQLite concurrency . SQlite :

SQLite , . . . , . , concurrency, .

SQLite - "" : , SQL " " . , concurrency ( db).

, , - , PostgreSQL.