playing around with node-sqlite

main.js

const sqlite3 = require("sqlite3");
const { open } = require("sqlite");

(async () => {
    // open the database
    const db = await open({
      filename: '/tmp/db',
      driver: sqlite3.cached.Database //sqlite3.Database
    })
    const db1 = await open({
      filename: '/tmp/db',
      driver: sqlite3.cached.Database // sqlite3.Database
    })
    
    await db.exec("create table t1 (col1)");
    await db.exec("insert into t1 values ('a')");
    let tx1 = await db.exec(`
    BEGIN; 
    insert into t1 values ('c'); 
    create temp table t2 (col1 int);
    -- insert into t1 values ('d'); 
    insert into t1 values ('b'); 
    insert into t2 values ('t2a'); 
    COMMIT;
    `);
    console.log(await db.all("select * from t1"));
    console.log(await db1.all("select * from t2"));
    
})().catch(e => {
    console.error('error occured', e)
})