websql-configurable

import openDatabase from 'websql-configurable'; // Create a file-based SQLite3 database named 'mydb.db' const db = openDatabase('mydb.db', '1.0', 'My WebSQL Database', 1024 * 1024); // Alternatively, create an in-memory database that is temporary const inMemoryDb = openDatabase(':memory:', '1.0', 'In-memory DB', 1); console.log('Database opened (or created):', db); db.transaction((tx) => { tx.executeSql( 'CREATE TABLE IF NOT EXISTS items (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, quantity INTEGER)', [], () => console.log('Table "items" created or already exists.'), (tx, error) => console.error('Error creating table:', error.message) ); tx.executeSql( 'INSERT INTO items (name, quantity) VALUES (?, ?)', ['Apple', 5], () => console.log('Inserted: Apple'), (tx, error) => console.error('Error inserting Apple:', error.message) ); tx.executeSql( 'INSERT INTO items (name, quantity) VALUES (?, ?)', ['Orange', 3], () => console.log('Inserted: Orange'), (tx, error) => console.error('Error inserting Orange:', error.message) ); tx.executeSql( 'SELECT * FROM items WHERE quantity > ?', [4], (tx, results) => { console.log('Items with quantity > 4:'); for (let i = 0; i < results.rows.length; i++) { console.log(` ID: ${results.rows.item(i).id}, Name: ${results.rows.item(i).name}, Quantity: ${results.rows.item(i).quantity}`); } }, (tx, error) => console.error('Error selecting items:', error.message) ); }, (error) => { console.error('Transaction failed:', error.message); }, () => { console.log('Transaction completed successfully.'); });