PSA: Workaround for build errors on Node 16.14+ or ARM: try @vscode/sqlite3

[timoxley]

Posting here for visibility until mapbox pops out a new sqlite3 release.

Try using @vscode/sqlite3 instead of sqlite3.

https://github.com/microsoft/vscode-node-sqlite3

Worked for me!

Possibly Related

• Impossible to install sqlite-3 in Mac M1 MacOS 12.1 #1538
• MacOS Monterey 12.3 no longer has Python 2.7 installed, finding it very difficult to use sqlite3 #1552
• Missing some(electron, arm64) prebuilt binaries via node-pre-gyp #1553
• Linux-Arm64 issue #1551
• Package installation not works when using yarn, but able to install by npm (arm64 binaries need!!!) #1540
• error when installing sqlite3 with npm #1554
• Node.js 16 MacOS x64 support / Error while building module #1537

[garyburgmann]

@timoxley I had success with Docker today. The special sauce appeared to be ln -s $(which python3) /usr/local/bin/python

ARG base_image=node:16-alpine

# https://github.com/nodejs/docker-node/blob/main/docs/BestPractices.md#node-gyp-alpine
FROM $base_image as builder

## Install build toolchain, install node deps and compile native add-ons
RUN apk add --no-cache --update python3 make g++
# needed for build of sqlite with node-gyp
RUN ln -s $(which python3) /usr/local/bin/python
WORKDIR /builder
COPY . .
# install node_modules here due to node-gyp dependencies
RUN npm ci
...

[carlosfaria94]

Ghost team have taken the node-sqlite3 development! Great news for everyone! 🙏🚀

[daniellockyer]

This should be fixed in sqlite3 v5.0.3 - let me know if you still experience issues 🙂

[jose-nunez]

I had problems with v5.0.2
v5.0.3 worked for me on Mac M1 - Node v16

[daniellockyer]

FYI v5.1.1 now comes with prebuilt Darwin ARM64 binaries 🙂 https://github.com/TryGhost/node-sqlite3/releases/tag/v5.1.1