Install on Vercel: warning "sqlite3@5.1.7" has no binaries

[jeromecovington]

Issue Summary

I am installing/building an app that has sqlite3 as a dependency. I am able to install and build the app fine on my Mac, but when I install on Vercel, I have an install warning (no binaries) and then a build error when attempting to run my sql migration. I am working to identify architecture/environment differences but wanted to post this issue in case anyone else has already encountered it and can provide guidance.

Relevant logs or output

[1/4] Resolving packages...
warning sqlite3 > node-gyp > make-fetch-happen > cacache > @npmcli/move-file@1.1.2: This functionality has been moved to @npmcli/fs
[2/4] Fetching packages...
[3/4] Linking dependencies...
[4/4] Building fresh packages...
warning "sqlite3@5.1.7" has no binaries
Done in 1.81s.
yarn run v1.22.19
$ sqlite3 biodiversity.db < migrate/data
/bin/sh: line 1: sqlite3: command not found
error Command failed with exit code 127.

Version

5.1.7

Node.js Version

20.13.1

How did you install the library?

npm install MacOS 14.4.1 M1 Max is fine, I am looking for the Vercel architecture specs

[YasharF]

Try switching off of this package to NodeJS 22's new built-in/native SQLite support. The feature in NodeJS is experimental, but it is being actively maintained and pretty much each new update of node is having some improvements over the last. As an experimental support, it currently exposes some of the SQLite features, so it may or may not work in your use case. But in case if it does, you can drop this dependency and have much better maintenance.