I'm working on a project and I want to protect information which is in SQLite database. I want to use algorithms such as RC4, DES, AES. I use C#. Please help me!
-
In order to be helpful, it helps us to have way more context than that. Can you tell us a little about what you're trying to store in SQLite?sblom– sblom2012-02-01 06:48:44 +00:00Commented Feb 1, 2012 at 6:48
-
2Just encrypt the data and store it in a blob column. If SQLite doesn't support blobs, encode the encrypted data with base64 and store it in a text field. If you're encrypting the whole thing, you should see this: stackoverflow.com/questions/1259561/…Polynomial– Polynomial2012-02-01 06:52:01 +00:00Commented Feb 1, 2012 at 6:52
-
What @Polynomial said is about it. Note that storing passwords in a database is a completely different problem and requires cryptographic hashing algorithms. You should clarify your question a bit, because security can be rather complex to implement properly, if you have no experience.vgru– vgru2012-02-01 12:06:53 +00:00Commented Feb 1, 2012 at 12:06
-
@Groo - Security is complex to implement properly, full stop.Polynomial– Polynomial2012-02-01 21:05:51 +00:00Commented Feb 1, 2012 at 21:05
-
using additional libraryBlake– Blake2014-02-02 16:33:26 +00:00Commented Feb 2, 2014 at 16:33
Add a comment
|
1 Answer
As discussed here, the easiest way is to use the System.Data.Sqlite wrapper and include a password in the connection string. This old forum thread says that the wrapper uses RC4 via the Microsoft Crypto API.