+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: Web Scraping & Web Development (https://python-forum.io/forum-13.html)
+--- Thread: Flask: sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked (/thread-39726.html)
Flask: sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked - pythonpaul32 - Apr-03-2023
Hi,
I am trying to update a database table and I keep getting this error:
'sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked'
None of the solutions online have helped and I am more confused than ever. Any help here would be greatly appreciated. Otherwise, I will have to remake the db.
RE: Flask: sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked - Larz60+ - Apr-04-2023
read: https://www.sqlite.org/lockingv3.html
Some will tell you that sqlite is not concurrent, however it is fully ACID compliant an can handle up to 50,000 inserts per second.
You should use transaction processing.