RC6 - New encrypt option for Sqlite DB: SqlCipher

[Mark@SF]

@schmidt -

I've converted several of my older MS Access database applications to SQLite. These applications have all used un-encrypted MS Access databases. I'm also using VS Community 2019 ((VB.Net).

I am now facing the conversion of an encrypted MS Access database to an encrypted SQLite database.

I've searched for help on how to encrypt an SQLite database and have found lots (and lots) of information, but I've not been able to figure out how to do this. I've read that SQLite does not include encryption and that you need an extension for this. There are several commercial extensions available (e.g., SEE) but these are expensive (an SEE license is $2000).

I think the SQLCipher software can encrypt a SQLite database and it is open-source (free). Reading more about this software, it appears that you have to compile the software in order to use it. This is where my understanding/experience "hits the wall" and I need some help.

Can you give me some guidance on how to proceed (or point me to a good step-by-step tutorial)?