pg-micro

import { connect } from 'pg-micro'; async function runExample() { // Connect to an in-memory database for a quick test // For a file-backed database, pass a path like 'myapp.db' const db = await connect(':memory:'); try { // Execute DDL statement to create a table await db.exec( "CREATE TABLE users (id SERIAL PRIMARY KEY, name TEXT, email TEXT)" ); console.log('Table "users" created.'); // Insert data into the table using prepared statements const insertStmt = db.prepare( "INSERT INTO users (name, email) VALUES ($1, $2)" ); await insertStmt.run('Alice', 'alice@example.com'); await insertStmt.run('Bob', 'bob@example.com'); console.log('Data inserted into "users" table.'); // Query data using a prepared statement and fetch all rows const rows = await db.prepare("SELECT * FROM users").all(); console.log('Fetched rows:', rows); // Expected output: // [ // { id: 1, name: 'Alice', email: 'alice@example.com' }, // { id: 2, name: 'Bob', email: 'bob@example.com' } // ] } catch (error) { console.error('Database operation failed:', error); } finally { // Always close the database connection when done await db.close(); console.log('Database connection closed.'); } } runExample();