SQLite worker snippet

sqlite-worker-query.ts

const worker = new Worker("https://cdn.jsdelivr.net/npm/sql.js@1.7.0/dist/worker.sql-wasm.js");
let rpcid = 0;
async function query(sql: string, params: any, action = "exec") {
    const id = rpcid++;
    return new Promise<any>((res, rej) => {
        const listener = (e: MessageEvent<any>) => {
            if (e.data && e.data.id === id) {
                worker.removeEventListener("message", listener);
                res(e.data);
            }
        };
        worker.addEventListener("message", listener);
        worker.postMessage({
            id,
            action: "exec",
            sql,
            params,
        });
    });
}

worker.onerror = (e) => console.log("Worker error: ", e);

console.log("OPEN", await query("", null, "open"));