Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

Sqlite and Encryption

by Anonymous Monk
on Sep 06, 2006 at 01:25 UTC ( #571360=perlquestion: print w/replies, xml ) Need Help??
Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Anybody knows of an open source way to encrypt a Sqlite database for distribution. I am hoping to build a database which will have Social Security numbers and was wondering if there is an extension to Sqlite that encryts the database file. Thanks for your help.

Replies are listed 'Best First'.
Re: Sqlite and Encryption
by diotalevi (Canon) on Sep 06, 2006 at 02:32 UTC

    I know of no direct support. Failing that, you could just write some kind of filter to do this work for you. It wouldn't be difficult. Consider making a DBD::db driver that just proxies for some other kind of database. In fact, this reminds me of DBD::AnyData which has some proxy-like support and might also support a crypto wrapper.

    It strikes me as a really bad idea to distribute social security numbers, encrypted or not. I assume you'll include the decryption key with the program, perhaps inside of it? This means your high value data is effectively not encrypted at all. This is a perilous thing you've asked about. Be good.

    ⠤⠤ ⠙⠊⠕⠞⠁⠇⠑⠧⠊

Re: Sqlite and Encryption
by Anonymous Monk on Sep 07, 2006 at 09:38 UTC

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://571360]
Approved by monkfan
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (2)
As of 2017-03-30 05:05 GMT
Find Nodes?
    Voting Booth?
    Should Pluto Get Its Planethood Back?

    Results (353 votes). Check out past polls.