Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

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.

Comment on Sqlite and Encryption
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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://571360]
Approved by monkfan
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (5)
As of 2014-12-28 20:19 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (182 votes), past polls