Databases

Elide includes three database drivers for JavaScript and TypeScript. Import the one you need; there is nothing to install and no Elide.db global.

import { Database } from "elide:sqlite";

const db = new Database(":memory:");
db.exec("CREATE TABLE notes (body TEXT)");
db.prepare("INSERT INTO notes VALUES (?)").run("hello");
console.log(db.query("SELECT body FROM notes").all());

node:sqlite and bun:sqlite load the same module as elide:sqlite; Node’s DatabaseSync isn’t provided (see SQLite). elide:postgres and elide:mysql ship TypeScript declarations in @elide-dev/types; elide:sqlite has none yet (see TypeScript and modules).

Other languages

The JavaScript drivers aren’t on a JVM program’s classpath: declare the JDBC driver like any other library (see Maven dependencies).

Samples

• Embedded SQLite
• SQLite transactions
• PostgreSQL queries