Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?

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 avoiding work at the Monastery: (5)
As of 2017-12-16 02:45 GMT
Find Nodes?
    Voting Booth?
    What programming language do you hate the most?

    Results (447 votes). Check out past polls.