JavaScript overview

import { connect } from '@tursodatabase/database';

// Open a file-backed database (created if it does not exist)
const db = await connect('turso.db');

// Execute DDL directly
db.exec('CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT)');

// Prepare and run a statement
const stmt = db.prepare('INSERT INTO users (name) VALUES (?)');
await stmt.run('Alice');

// Query rows
const rows = await db.prepare('SELECT * FROM users').all();
console.log(rows); // [{ id: 1, name: 'Alice' }]

db.close();

import { connect } from '@tursodatabase/database';

const db = await connect(':memory:');      // in-memory database
const db = await connect('./app.db');      // file-backed database