sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked #493

Activity

1. pdsparks commented on Apr 12, 2021

   

   pdsparks

   on Apr 12, 2021

   More actions

   Hi - I believe that sqlite write-locking will prevent multi process inserts.

   If you are trying to generate a table for one-off data exploration I would use a free program like HeidiSQL (Tools - Import CSV)

   If you are looking to automate an import process then maybe try checking this Stack response [here] (https://stackoverflow.com/questions/6977497/import-csv-file-into-sqlite3-database-in-command-line-or-via-batch-file)