Error: Could not locate the bindings file (using bun)

[stabildev]

Can't use better-sqlite3 with bun and drizzle-kit:

bunx drizzle-kit migrate and bunx drizzle-kit push produce the error Could not locate the bindings file.

Workaround for now (locally):

bun add -D node-gyp
cd node_modules/better-sqlite3
bun run build-release
cd -

[mceachen]

I don't believe your workaround actually resolves the issue, though, at least using bun 1.1.16: I get a segfault on Windows and a symbol lookup error on Ubuntu after you force-rebuild the better-sqlite3 library and try to open a new db:

const bs = require("better-sqlite3")
const db = new bs("test.db")

I'd be surprised if bun played nicely with (any) non-FFI/node-gyp libraries, as we're interfacing with v8, and bun is JavaScriptCore-based, so the runtimes are completely different.

Have you considered https://bun.sh/docs/api/sqlite?

You could also try running with bun install --ignore-scripts, the workaround suggested here: oven-sh/bun#7598

More context: #1034 (comment)

[stabildev]

I am using bun only as the package manager, not the runtime.

Why did you close this?

@mceachen

There are other issues in different contexts that all have a similar error message

[mceachen]

You didn’t mention what runtime you’re using in the initial report, so I assumed bun.

This is arguably an install bug in bun (see the linked ticket).