How to fix Database is locked error in sqlite?

I

I

Ivan2020-11-12 11:55:06

Python

Ivan, 2020-11-12 11:55:06

How to fix Database is locked error in sqlite?

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?

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

D

Dr. Bacon, 2020-11-12
@mlneko

Don't use sqlite, time to master postgresql

Similar questions

I

instla2018-11-08 22:59:05

Where to look for partners for php projects/startups? 3Reply

H

HoBu4okok2021-07-09 23:07:39

How to send music via bot.send_audio (telebot, python)? 1Reply

N

Nodir Malikov2020-05-07 16:29:18

How to sort and list places in ascending order based on distance from user's geolocation in python using geopy? 1Reply

V

veosz2021-07-10 18:23:30

I can’t start the bot because it doesn’t see the pytelegrambotapi library, what should I do? 1Reply

K

ks_ks2012-01-14 07:54:49

Intercepting and parsing packets, generating html pages, in python 3Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question