Pretty simple question with no literature to expound on it here. If you start a connection, then run a job continually for 12 hours inserting data to the .db, if you do not commit and the python script terminates, can you go back in, connect to the database and commit and see the changes?
This may be a silly question but way are you don't committing records as you process? Isn't it more efficient to commit say 100,000 records now than try to commit 1,000,000 at once at the end of the process?
SQLite3 Python - Comit() in a later session