How to fix Database is locked error in sqlite?

Question

Python

After a long interaction with the database, the Database is looked error occurs, I use multithreading and set with lock for any work with the database.
How to fix or work around? The program processes 3-5 requests per second.

I heard that sqlite does not support asynchrony / multithreading / multiprocessing, should I change it then?

Answer 1

Don't use sqlite, time to master postgresql