This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, I'm working on an app that requires an encrypted and compressed, local database. We're looking at using SQLite. The SQLite professional extensions (CEROD) would suit us nicely but will Lightspeed (LINQ to SQLite) work with it? If not, does Lightspeed itself support compression and encryption of data? Thanks in advance! Chris |
|
|
|
|
We're not familiar with CEROD, but from the Web site it looks like CEROD ships as source code which you must compile into the SQLite implementation itself. The SQLite implementation used by LightSpeed is Robert Simpson's System.Data.SQLite. As this includes the original C/C++ SQLite engine together with the .NET wrapper, I would expect you could compile CEROD into this, but I would strongly suggest asking on their forums to be sure (or of course getting an evaluation version of CEROD and just trying it out!). You may also need to figure out how the CEROD password prefix fits into the SQLite connection string e.g. can you just write "Data Source=:cerod:password:filename.db3" or will you need to make changes in the .NET wrapper code to handle this? Assuming that patching System.Data.SQLite to include the CEROD extensions works, and that you are able to pass the CEROD password via the connection string, you should then be able to use this with LightSpeed simply by providing the extended connection string. You *may* need to do a binding redirect to handle versioning / strong naming because LightSpeed is linked to the original SQLite DLL and may not recognise your modified DLL without the redirect. We would be happy to work with you on addressing any issues that arise with a modified DLL. We don't currently support compression or encryption at the LightSpeed level. |
|
|
|
