SQLCipher on Windows 10 using Windows' built-in sqlite binary


#1

We use SQLCipher for Windows 10 UWP apps, but so far we have used it by packaging SQLite into our app (along with SQLCipher of course). As of Windows 10 Anniversary Update SQLite is built into the OS, and is more performant for apps to use the OS version of SQLite. For more info see https://blogs.windows.com/buildingapps/2017/02/06/using-sqlite-databases-uwp-apps

Can SQLCipher work with the built in version of SQLite? Or do we have to keep packaging SQLite into our app? Are the instructions any different?

Thanks!
Wes


#2

Hello @wpetersfdc

Can SQLCipher work with the built in version of SQLite?

That is a good question. SQLCipher includes a full version of SQLite with it’s distribution. The type of integration hook SQLite exposes for SQLCipher to encrypt and decrypt data on the fly requires that our code be compiled with a full version of SQLite. Because of this, SQLCipher can not be used in conjunction with a standalone SQLite distribution. We will continue to update SQLCipher, tracking releases made within the upstream SQLite project.

Or do we have to keep packaging SQLite into our app?

You will want to continue to package SQLCipher with your application as you have.