On 7/11/16, David Lederkremer <lederkre...@gmail.com> wrote:
> I am using a library that is CEROD-enabled and still I cannot open my
> CEROD-encrypted DB. It has no password so I'm supposed to use the prefix
> ':cerod::' but when I use it like this:
>
>> import sqlite3
>
>> conn = sqlite3.connect(':cerod::example.db')
>
>> cursor = conn.cursor()
>
>> cursor.execute('...')
>
>> ..."
>
>
> It simply creates a new empy DB named :cerod::example.db .
>
> Am I doing it wrong or perhaps the program doesn't recognize CEROD?

My guess is that Python is not using the CEROD-enabled SQLite that you
think it is using, but is instead using either a public-domain SQLite
system library, or a statically linked copy of the SQLite library.

If you use Python to open a connection to ":memory:" and then run commands:

    PRAGMA compile_options;
    SELECT sqlite_source_id();

what outputs do you see?

In particular, I'm expecting to see "ENABLE_CEROD" among the outputs
from the pragma if you are really using a CEROD-enabled SQLite.
-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to