@cloud-cli/d0 v1.3.1

d0

SQLite server over HTTP

Usage

POST /query

Run a prepared SQLite statement. Accepts a JSON with these properties:

// select all items using fetch
fetch('https://db.example.com/query', {
  method: 'POST',
  body: JSON.stringify({
    s: 'SELECT * FROM user WHERE id = ?',
    d: [123],
    m: 'all',
  });
});

// select using the server-provided library
import db from 'https://db.example.com/index.mjs';

const user = await db.query('SELECT * FROM user WHERE id = ?', [123]);

Server address

If BASE_DOMAIN is set, the server will be available at https://db-name.BASE_DOMAIN/ with a multi-database support, where db-name is the name of the database file without the .sqlite extension. The database is selected by the db-name part of the URL, so you can have multiple databases on the same server.

Otherwise, it will be available at http://localhost:PORT/ and serve a single database.

Environment variables