Skip to main content

tjs:sqlite

SQLite3 module.

This module borrows a lot of inspiration from better-sqlite3 and the Bun sqlite module.

import { Database } from 'tjs:sqlite';

const db = new Database(':memory:');
db.exec('CREATE TABLE greetings (message TEXT)');
const ins = db.prepare('INSERT INTO greetings (message) VALUES (?)');
ins.run('Hello world!');
const rows = db.prepare('SELECT * FROM greetings').all();
console.log(rows); // [{ message: 'Hello world!' }]
db.close();

Classes

Interfaces