@petradb/engine

A lightweight, embeddable SQL database engine for JavaScript and TypeScript. No native dependencies, no external services — just import and query. Follows PostgreSQL conventions.

Installation

npm install @petradb/engine

Quick Start

import { Session } from '@petradb/engine';

const db = new Session();

await db.execute(`
  CREATE TABLE users (id SERIAL, name TEXT NOT NULL, email TEXT);
  INSERT INTO users (name, email) VALUES ('Alice', '[email protected]');
`);

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

Persistent Storage

Data survives restarts with crash-safe durable storage in a single file:

const db = new Session({ storage: 'persistent', path: './mydb' });
// ... use the database ...
await db.close();

Also available: { storage: 'text', path: './data.ptxt' } for human-readable text files.

Documentation

Full documentation, SQL reference, and API details are available at petradb.dev.

License

ISC