does dotConnect for SQLite support concurrent access? Thank you.
SQLite don't support concurrent write. But dbExpress driver for SQLite have concurrent access feature. So I ask.
SQLite concurrent access
Please refer to http://www.sqlite.org/faq.html#q5:
1) "Locking=Normal;";
2) if you want to use "Read Uncommitted=True;", you should also call static SQLiteConnection.EnableSharedCache() before opening connections: http://www.sqlite.org/c3ref/enable_shared_cache.html.
Concerning dotConnect for SQLite, please pay attention to the following connection string parameters:SQLite allows multiple processes to have the database file open at once, and for multiple processes to read the database at once. When any process wants to write, it must lock the entire database file for the duration of its update. But that normally only takes a few milliseconds. Other processes just wait on the writer to finish then continue about their business.
1) "Locking=Normal;";
2) if you want to use "Read Uncommitted=True;", you should also call static SQLiteConnection.EnableSharedCache() before opening connections: http://www.sqlite.org/c3ref/enable_shared_cache.html.