sqlite question
Diez B. Roggisch
deets at nospam.web.de
Sat Oct 17 10:27:38 EDT 2009
Roger Binns schrieb:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Dennis Lee Bieber wrote:
>> I suspect, besides building an sqlite3.dll (if Windows), you might
>> have to modify the pysqlite DB-API adapter to support whatever new
>> arguments have been added to various calls (most like the db.connect()
>> parameters have changed to require an encryption password)
>
> The extension requires an extra C api call after the database is opened to
> set the encryption key. (There is also another API to change the key.)
>
> This means that it is not possible for the same pysqlite to work against
> SQLite built with and without the encryption extension. The changes needed
> in pysqlite are a simple matter of programming although you'll want them
> incorporated back into the core so you don't have to maintain them (wrapped
> in some sort of ifdef).
It might be possible to wrap the needed call using ctypes, if the DLL/SO
can be loaded explicitly. Which it should be I'd say.
Diez
More information about the Python-list
mailing list