From: "David Filmer" <[EMAIL PROTECTED]>
On Dec 6, 10:47 am, [EMAIL PROTECTED] (Octavian Rasnita) wrote:
I've seen a program made in C# that uses an SQLite database which is
crypted.
I doubt that. SQLite does not (AFAIK) have an encrypted database
engine. The only way that such a program could do this is if the C#
program somehow augmented the SQLite source code.
Can we do the same thing with perl?
You can do the same thing that the C# program (probably) did - namely
encrypt the values before inserting them into the database. Perl can
do all sorts of encryption - search the Crypt:: namespace at
http://cpan.org.
You probably want some sort of bi-directional encryption instead of a
hash encryption (which is usually used for password checking and
such). Symmetrical pass-key encryption is easy but not especially
strong (though probably adequate for most situations, as cracking a
good pass-key is still a ponderous task). Some sort of certificate-
based (PPK) encryption is pretty good.
Of course, since a SQLite database is just a simple file, you can
store it on an encrypted filesystem, which offers a good measure of
protection in some circumstances (lost hard drive, stolen powered-off
laptop, etc).
Well, here it is an archive that contains the following files:
sqlt_fruit.exe - a sample program made in C# that uses a crypted SQLite
database
sqlt_fruit.cs - the source code for that program
CompileSqlt_fruit.bat - a bat file with the command line used for compiling
that program
System.Data.SQLite.DLL - a dll file needed for running the program
http://www.tranzactiibursiere.ro/static/CryptedSQLite.zip
So it seems that this is possible, and when working with an SQLite database,
C# has a big advantage when it is compared it with perl.
Octavian
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
