[Pkg-javascript-devel] Bug#923512: Bug#923512: node-sqlite3: please build with sqlcipher support

[Jérémy Lal]

Le ven. 1 mars 2019 à 10:15, Paolo Greppi <paolo.greppi at libpf.com> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/pkg-javascript-devel/attachments/20190301/75a9b9bc/attachment.html>