fix: build sqlite3 from source for older glibc compatibility

TheLastCicada · TheLastCicada · commit 7917dc96e554 · 2026-05-04T12:10:11.000-07:00
Prebuilt sqlite3 6.0.1 binaries require glibc 2.38, which is newer
than Debian 12 (2.36) and Ubuntu 22.04 (2.35). Add a postinstall
script to rebuild sqlite3 from source so npm install works on all
supported platforms.
diff --git a/Dockerfile b/Dockerfile
@@ -15,7 +15,7 @@ COPY src /app/src/
 COPY tests /app/tests/
 WORKDIR /app
 
-RUN npm install && npm rebuild sqlite3 --build-from-source
+RUN npm install
 
 RUN mkdir -p /root/.chia/mainnet/config/ssl && mkdir -p /root/.chia/mainnet/cadt/v1
 
diff --git a/README.md b/README.md
@@ -128,15 +128,33 @@ You'll need:
 ​
 - Git
 - [nvm](https://github.com/nvm-sh/nvm) - This app uses `nvm` to align node versions across development, CI and production. If you're working on Windows, you should consider [nvm-windows](https://github.com/coreybutler/nvm-windows)
+- C/C++ build tools for compiling the SQLite native module (see below)
 - A working [Chia installation](https://docs.chia.net/installation/#using-the-cli) running wallet and datalayer (full node recommended)
 
+##### Build Prerequisites
+
+The `sqlite3` npm package is compiled from source during `npm install` to ensure compatibility across platforms. This requires a C/C++ toolchain and Python 3:
+
+**Debian / Ubuntu:**
+
+```
+sudo apt-get install -y build-essential python3
+```
+
+**macOS:**
+
+```
+xcode-select --install
+```
+
 To install from source:
 
 ```
 git clone git@github.com:Chia-Network/cadt.git
 cd cadt
 nvm install
 nvm use
+npm install
 npm run start
 ```
 
diff --git a/package.json b/package.json
@@ -40,6 +40,7 @@
     "test:v2:live:all": "npm run test:v2:live:organization:create && npm run test:v2:live:data && npm run test:v2:live:organization:delete",
     "resetTestDb": "rm -rf ./tests/test-dbs && mkdir -p ./tests/test-dbs",
     "resetMirrorDb": "npx sequelize-cli db:drop --env mirror",
+    "postinstall": "cd node_modules/sqlite3 && node-gyp rebuild --napi_build_version=6",
     "prepare": "husky",
     "build": "babel src --keep-file-extension --out-dir build --copy-files && cp package.json ./build && node change-build-package-type-commonjs.cjs",
     "build-migrations": "babel migrations --keep-file-extension --out-dir dist/migrations --copy-files",
