sqlite question

Diez B. Roggisch deets at nospam.web.de
Sat Oct 17 16:27:38 CEST 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