Unable to load database file saved with Journal Mode: WAL #35
Description
I was using DB Browser for SQLite to work on a database file, and would get the following error when trying to open the same file in Sqlime: SQLite3Error: SQLITE_CANTOPEN: sqlite3 result code 14: unable to open database file
After comparing with the demo.db file from the Sqlime repo, I was able to fix it by saving my database with Journal Mode: Delete instead of "WAL".
This isn't an issue with Sqlime directly, but seems to be with the underlying sqlean.js package. I was getting the same behaviour in an app I'm building with sqlean.js.
To be honest, I don't know what exactly Journal Mode means in this context, but a note in the Sqlime UI or in the sqlean.js repo could be good.
A more explicit error message would be great too, but I'm not sure that's feasible.