db.prepare is not a function about better-sqlite3 HOT 3 CLOSED

And how does "db" end up in selectDB? While I am firm with it, I do not use TypeScript in any of my projects ..

A minimal, plain NodeJS / Electron compatible, working example might be:

const Database = require('better-sqlite3');
const db = new Database(':memory:');

db.exec('CREATE TABLE test(num bigint)')
db.exec('INSERT INTO test(num) VALUES(5)');

function selectDB(db) {
    const i = db.prepare('SELECT * FROM test').get();

    console.log(i);  // This should output "{num: 5}"

    return i;
}

selectDB(db);

I would not blame the initialization of the database, but handling the reference to the created instance might be the issue,

from better-sqlite3.

Well, how do you "run" the selectDB function? Do you pass the correct db object into it? Also, neither prepare nor get do return a Promise. Await is not required here.

I would guess your problem is located somewhere on the JavaScript level, if you can share more information we might be able to give a better hint.

from better-sqlite3.

I believe you are correct. I moved the initialization of the db to main.ts (in an Electron app).
import Database from 'better-sqlite3'; const dbPath = path.join(app.getPath("userData"), "posty.db"); const db = new Database(dbPath);

This crashes my electron app. Am I incorrectly initializing the database? @neoxpert

from better-sqlite3.