Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid

Re: sqlcipher for sqlite

by Corion (Pope)
on Dec 28, 2012 at 21:42 UTC ( #1010748=note: print w/replies, xml ) Need Help??

in reply to sqlcipher for sqlite

DBD::SQLite basically gets compiled from the SQLite source code, together with some Perl-specific C code ("XS code"). Simply replacing the SQLite.dll with a DLL that was not compiled from the XS code in DBD::SQLite will not work. You will have to recompile DBD::SQLite with the sqlcipher source code and then also think hard about the new API to pass the decryption key around.

Recompiling DBD::SQLite with the sqlcipher code should be fairly easy:

  1. Download the sqlcipher package
  2. Download and change into the DBD::SQLite package directory:
    > cpan cpan[1]> look DBD::SQLite
  3. Replace the sqlite3.c and sqlite3.h files with the files from sqlcipher
  4. Use the standard invocation to compile and install the module:

    perl Makefile.PL dmake dmake test dmake install

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1010748]
[LanX]: do you know the story of the triangle player?
[choroba]: Oh, the Czech one playing the German composition?
[choroba]: BTW, the elections are over. We already have the final results.
[choroba]: I should probably apply for a job somewhere abroad.

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (9)
As of 2017-10-21 19:32 GMT
Find Nodes?
    Voting Booth?
    My fridge is mostly full of:

    Results (270 votes). Check out past polls.