« xDev Magazine Issue 1… | Home | MBS FileMaker Plugin,… »

Use SQLCipher with MBS SQL Plugin functions

If you are interested in encrypted SQLite databases with SQLCipher, you can use their library with our plugins.

You simply get a copy of their library, either the commercial or the open source one. For open source, I built my own copies today for Mac and below you can download them. When you use my SQL plugin functions, you normally set option to point to libsqlite.dylib file. But instead to this file, you point to the libsqlcipher.dylib file. Now you run as first command "PRAGMA key = 'passphrase';" to pass in your password for the database. All following calls should run normal and the file is encrypted.

This is not the same encryption as used by Xojo. They use the SQLite Encryption Extension from Hwaci - Applied Software Research (see hwaci.com/sw/sqlite/)

Download my built library: sqlciphermac.zip
03 01 15 - 17:35
three comments

Hi Christian. Don’t have a dll for Windows users, do you? Please see https://forum.xojo.com/18652-sqlite-database-encryption-issue/0#p156113
GaryMc (Email) - 04 01 15 - 17:29

I have none here. But you can build them or ask the company for a commercial license and a prebuilt dll.
Christian Schmitz (URL) - 04 01 15 - 17:46

I’ve just built copies of SQLCipher for Mac (dylib) and Windows (dll). For info…
For Mac I used:
./configure —enable-tempstore=yes CFLAGS=”-DSQLITE_HAS_CODEC -mmacosx-version-min=10.4 -arch x86_64 -arch i386 “ LDFLAGS=”-lcrypto”
http://www.jerryrw.com/howtocompile.php has a great walkthrough of the Windows process, but there are a few gotchas.
I also had to install ActiveTcl: http://www.activestate.com/activetcl/dow..
And add it to the fstab file: c:Tcl /tcl
I also found that OpenSSL 1.0.2 didn’t want to play ball, but OpenSSL 1.0.1 is fine.
Hamish Symington (Email) - 19 06 15 - 14:59

Remember personal info?

Emoticons / Textile

Hide email:

Small print: All html tags except <b> and <i> will be removed from your comment. You can make links by just typing the url or mail-address.