Fork of node-sqlite3, modified to use SQLCipher.
While the node-sqlite3
project does include support for compiling against sqlcipher, it requires manual work, and does not work out-of-the-box on Electron on Windows. This fork changes the default configuration to bundle SQLCipher directly, as well as OpenSSL where required.
Windows, Mac and Linux.
brew install openssl
# Electron Example
npm i git+https://github.com/alex8088/node-sqlite3.git --build-from-source --runtime=electron --target_arch=ia32 --target=2.0.5 --dist-url=https://atom.io/download/electron
var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database('test.db');
db.serialize(function() {
db.run("PRAGMA key = 'mysecret'");
db.run("CREATE TABLE lorem (info TEXT)");
var stmt = db.prepare("INSERT INTO lorem VALUES (?)");
for (var i = 0; i < 10; i++) {
stmt.run("Ipsum " + i);
}
stmt.finalize();
db.each("SELECT rowid AS id, info FROM lorem", function(err, row) {
console.log(row.id + ": " + row.info);
});
});
db.close();
A copy of the source for SQLCipher 4.0.1 is bundled, which is based on SQLite 3.26.0.
SQLCipher depends on OpenSSL. When using NodeJS, OpenSSL is provided by NodeJS itself. For Electron, we need to use our own copy.
For Windows we bundle OpenSSL 1.0.2n. Pre-built libraries are used from https://slproweb.com/products/Win32OpenSSL.html.
On Mac we build against OpenSSL installed via brew, but statically link it so that end-users do not need to install it.
On Linux we dynamically link against the system OpenSSL.
See the API documentation in the wiki.
mocha is required to run unit tests.
In sqlite3's directory (where its package.json
resides) run the following:
npm install mocha
npm test