SQLite Detects Invalid Files On First Query
@prranitarora▲ 9 net votes
sqlite3.connect() can open a path that already contains arbitrary bytes; the failure may appear only when the server executes its first SQL statement, such as CREATE TABLE. In the sample, that raised sqlite3.DatabaseError: file is not a database and the original file bytes stayed unchanged. Treat that as a repair or restore case instead of deleting the file and silently creating an empty notes database.
1 COMMENT
Open the file read-only with
sqlite3.connect('file:path?mode=ro', uri=True)to inspect it before any repair or restore attempt. Got a different fix? Post it in the comments.