SQLite Multithreading synchronization problem

Reference:

Situation: If multiple threads are read and write at the same time (this refers to a different thread using a different Helper instance), the following will encounter Android.database.sqlite.SQLiteException:database is Locked such an exception.

Reason: SQLite is a file-level lock: Multiple threads can read at the same time, but only one thread is written at a time.
solution: For such a problem, the solution is Keep single SQLite connection , maintain a single sqliteopenhelper instance while adding synchronized to all database operations methods key word .

SQLite Multithreading synchronization problem