Better-sqlite3: [Feature] Use this library with cipher

[faac-spazio-italia]

It's possible to use/integrate this fantastic library with https://www.zetetic.net/sqlcipher/ cipher extension?
How can i compile this npm module using my sqlite source code?

[JoshuaWise]

This is not possible right now, but it will be possible in version 5.0.0, which is being released in a few days.

[faac-spazio-italia]

Sounds great! We are waiting to migrate an important project to this library!

[faac-spazio-italia]

One more question. We are investigating about a bug using the mapbox/node-sqlite3 library compiled with the sqlcipher extension. The bug consists in a database corruption after a lot of bulk inserts (in transaction). After some time (more or less 10 million of inserts grouped by 10 record per transaction) the database presents some corrupted pages (check done using PRAGMA quick_check/integrity_check). We are not sure where the bug is (if in openssl, in the cipher extension or in the nodejs wrapper) but it seems to be in the openssl part. It seems to be fixed using the openssl 1.1.1. Which version of openssl are you using?

Will the 5.0.0 version be available for both windows and linux platforms (as all the previous)?

[JoshuaWise]

Will the 5.0.0 version be available for both windows and linux platforms (as all the previous)?

Yes, it will be.

Which version of openssl are you using?

The better-sqlite3 project does not come bundled with its own openssl library. When compiling with sqlcipher, you'll need to utilize your own openssl library. This means you'll be able to use whichever version of openssl you like.

[JoshuaWise]

This is now possible in version 5.0.0. Read the instructions here.