On Dec 9, 7:03 am, [EMAIL PROTECTED] (Octavian Rasnita) wrote: > 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- 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! -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/