@webreflection/sql.js

An ESM re-packaged sql.js with embedded sqlite.wasm as buffer:

• same initSqlJs API and functionalities
• zero need to host the sqlite-wasm.wasm file a part
• works already in both main or workers

// works in both main and workers
import initSqlJs from 'https://esm.run/@webreflection/sql.js';

const SQL = await initSqlJs();

const db = new SQL.Database();

db.run(`
CREATE TABLE hello (a int, b char);
INSERT INTO hello VALUES (0, 'hello');
INSERT INTO hello VALUES (1, 'world');
`); // Run the query without returning anything

// Prepare an sql statement
const stmt = db.prepare("SELECT * FROM hello WHERE a=:aval AND b=:bval");

// Bind values to the parameters and fetch the results of the query
const result = stmt.getAsObject({':aval' : 1, ':bval' : 'world'});
console.log(result); // Will print {a:1, b:'world'}

db.close();