@farjs/better-sqlite3-wrapper

Thin api wrapper around better-sqlite3 and bun:sqlite to allow cross- runtime/engine usage.

It exposes only a subset of better-sqlite3 api because not everything is available in bun:sqlite.

For example, since run returns undefined you can use the following queries to get changes and/or lastInsertRowid:

const changes = db.prepare("SELECT changes() AS changes;").get().changes;
const lastInsertRowId = db.prepare("SELECT last_insert_rowid() AS id;").get().id;

Also, since db.pragma is not available in bun:sqlite, you can run:

// non-transactional
db.prepare("PRAGMA foreign_keys = ON;").run();