From: <[EMAIL PROTECTED]>
On Dec 9, 7:03 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- Hide quoted text -
- Show quoted text -
I've tried this and it works fine with my C# application running on
XP, however, I cannot run it on Windows Vista? complaining about a
problem signature on System.Data.SQLite.DLL.
Any ideas?
Thanks!
Sorry. No idea. I didn't wrote that C# program because I don't know C# well
enough. That's why I was interested in a perl solution, but unfortunately it
is not possible in perl.
I don't even have Windows Vista to test the program under that OS.
Octavian
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
