There's a version mismatch between the SQLite version being used and the better-sqlite3 module

Bug Reports
#1

Description

when npm install runs to:

it runs the command below actually:

npm install better-sqlite3@^11.0.0 --no-save --no-audit --build-from-source --sqlite3="/src/Mailspring/app/build/sqlite-amalgamation"

and report bugs:

npm ERR! ./src/util/constants.lzz:98:34: error: use of undeclared identifier 'SQLITE_IOERR_IN_PAGE'
npm ERR!    98 |                 SetCode(isolate, SQLITE_IOERR_IN_PAGE, "SQLITE_IOERR_IN_PAGE");
npm ERR!       |                                  ^
npm ERR! ./src/util/constants.lzz:133:34: error: use of undeclared identifier 'SQLITE_NOTICE_RBU'
npm ERR!   133 |                 SetCode(isolate, SQLITE_NOTICE_RBU, "SQLITE_NOTICE_RBU");

this error occurs because there’s a version mismatch between the SQLite version being used and the better-sqlite3 module.

when i run:
npm install better-sqlite3@^8.0.1 --no-save --no-audit --build-from-source --sqlite3="/src/Mailspring/app/build/sqlite-amalgamation"
, not surprising, it scuueeds .

To Reproduce…

Steps to reproduce the behavior:

just Running Mailspring from Source
npm install

Expected Behavior

no error

Screenshots

Setup

  • OS and Version:
    • Installation Method:
      Ubuntu Linux 20.04
  • Mailspring Version:
    newest

Additional Context