bun-sqlite

# Bun SQLite Bun has a built-in, high-performance SQLite driver via `bun:sqlite`. ## Quick Start ```typescript import { Database } from "bun:sqlite"; // Create/open database const db = new Database("mydb.sqlite"); // Create table db.run(` CREATE TABLE IF NOT EXISTS users ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, email TEXT UNIQUE ) `); // Insert data db.run("INSERT INTO users (name, email) VALUES (?, ?)", ["Alice", "alice@example.com"]); // Query data const users = db.query("SELECT * FROM users").all(); console.log(users); // Close db.close(); ``` ## Opening Databases ```typescript import { Database } from "bun:sqlite"; // File-based database const db = new Database("data.sqlite"); // In-memory database const memDb = new Database(":memory:"); // Read-only mode const readDb = new Database("data.sqlite", { readonly: true }); // Create if not exists (default) const createDb = new Database("new.sqlite", { create: true }); // Strict mode (recommended) const strictDb = new Database("strict.sqlite", { strict: true }); ``` ## Running Queries ### Direct Execution ```typescript // Run (for INSERT, UPDATE, DELETE, DDL) db.run("CREATE TABLE items (id INTEGER PRIMARY KEY, name TEXT)"); db.run("INSERT INTO items (name) VALUES (?)", ["Item 1"]); db.run("DELETE FROM items WHERE id = ?", [1]); // Get changes info const result = db.run("DELETE FROM items WHERE id > ?", [10]); console.log(result.changes); // Rows affected console.log(result.l...