database-js-sqlite

import { Connection } from 'database-js'; // Ensure database-js-sqlite and node-sqlite3 are installed: // npm install database-js database-js-sqlite node-sqlite3 (async () => { let connection; try { // Connect to an SQLite database file. It will be created if it doesn't exist. connection = new Connection('sqlite:///test.sqlite'); console.log('Database connection established.'); // Create a table if it doesn't exist await connection.query( "CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY AUTOINCREMENT, user_name TEXT, email TEXT);" ); console.log('Table 'users' ensured.'); // Insert data using a prepared statement let statement = await connection.prepareStatement("INSERT INTO users (user_name, email) VALUES (?, ?)"); await statement.query('john_doe', 'john@example.com'); await statement.query('jane_smith', 'jane@example.com'); console.log('Users inserted.'); // Query data using a prepared statement statement = await connection.prepareStatement("SELECT * FROM users WHERE user_name = ?"); const rows = await statement.query('john_doe'); console.log('Query result for john_doe:', rows); } catch (error) { console.error('Database operation failed:', error); } finally { if (connection) { await connection.close(); console.log('Database connection closed.'); } } })();