Le ven. 1 mars 2019 à 10:15, Paolo Greppi <[email protected]> a écrit :
> Package: node-sqlite3 > Version: 4.0.6+ds1-2 > Severity: normal > > Please build nodes-qlite3 with support for sqlcipher: > https://github.com/mapbox/node-sqlite3#building-for-sqlcipher > > This is required to package signal-desktop (https://bugs.debian.org/842943 > ) > It would allow us to simply depend on node-sqlite3 and not the forked > https://github.com/scottnonnenberg-signal/node-sqlcipher > > Test with: > > cat > a.js <<EOT > 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(); > EOT > > nodejs a.js > > hexdump -C test.db > > you should not see the test data "Ipsum ..." > > Paolo These are two (quite different) libraries: sqlite3 is at version 3.27.2 sqlcipher (in debian) is based on sqlite3 3.15.2 So what you're asking is to build two binaries: node-sqlite3 node-sqlcipher which shouldn't be a problem in principle, but i need help to do it. Jérémy
