SQLITE Opening same file by two different classes in same app

Databases
1

Hi!

I am working on a WEBAPP that uses SQLITE as the main engine. The thing is that I have one centralized DB CONNECTOR that opens the database for central activities and cleanups, however I want to also access the same DB in each USER SESSION so that I can speed up things for reading mostly…

Is this possible/recommended or should I stick with one connector (SQLITE CLASS) per database file?

I know I have to set the multi user flag to true, but I don’t know if that means that I can open the file by multiple classes or connectors…

2

Yes, a separate connection per Session is possible and recommended, especially for writing.

Setting MultiUser = True enables Write Ahead Logging which improves performance when changes are written to disk. SQLite still only allows a single user at a time to write to the DB.

3

Excellent! Thanks!