mardi 26 mai 2015

Why doesn't IronPython support SQLite3's Write-Ahead Logging, even though its SQLite version should?

I'm attempting to set a SQLite database's journal_mode to wal (write-ahead logging) via an IronPython script.

The IronPython's install version is

IronPython 2.7 2.7.0.40 on .NET 4.0.30319.18444

and the SQLite version it uses is 3.7.7, obtained by running print sqlite3.sqlite_version.

WAL support was added to SQLite in version 3.7.0, so why does this script fail to run?

If I execute pragma journal_mode=wal; I just get a response of delete.

If I try to open a database already set to WAL, I get an error of _sqlite3.DatabaseError: file is encrypted or is not a database (wal format detected).

Aucun commentaire:

Enregistrer un commentaire