6 ms·
Correct - We open our databases in serialized mode and access a single connection from multiple threads. We actually are not concerned with handling detailed e
by bob1029 6y ago
Correct - We open our databases in serialized mode and access a single connection from multiple threads.
We actually are not concerned with handling detailed error information. Our usage of these databases is very well bounded. All of the SQL that will ever execute against them is contained in 1 series of constant declarations, and the mappers ensure request data is well-formed before attempting inserts & updates. SQLite is really just there to provide identity and persistence for our business objects.
We are still able to use these fields effectively in local development and unit testing, since in these contexts there is only ever 1 thread hitting the database at a time.