d0

SQLite server over HTTP

Usage

POST /query

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

Property	Description	Required
s	string with the statement	yes
d	data to bind on a statement	no
m	method to execute: all, run or get. Run is the default	no

// 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

Variable	Description
PORT	HTTP port
DATA_PATH	Path to a folder where the database files are stored
BASE_DOMAIN	Root domain to use in a multi-db server, e.g. .example.com