Push a web app. Get a versioned URL. One database, shared by everyone.

$ cairn push ./dist --artifact my-app --create --public
$ cairn push ./dist --artifact my-app --overwrite latest
$ cairn open my-app

<script src="./cairn.js"></script>
<script>
  await cairn.ready();  // sql.js in the browser here; server APIs on Cairn

  // run-once schema — exactly what this page migrates
  await cairn.db.migrate('001-register', [{
    sql: 'CREATE TABLE register (id INTEGER PRIMARY KEY AUTOINCREMENT, ' +
         'name TEXT NOT NULL, note TEXT NOT NULL, created_at TEXT NOT NULL)'
  }]);

  // sign the register
  await cairn.db.query(
    'INSERT INTO register (name, note, created_at) VALUES (?, ?, ?)',
    [name, note, new Date().toISOString()]);

  // latest entries + the live count in the nav
  const latest = await cairn.db.query(
    'SELECT id, name, note, created_at FROM register ORDER BY id DESC LIMIT 6');
  const count = await cairn.db.query('SELECT COUNT(*) FROM register');
  // latest.rows → [[id, name, note, created_at], …]
</script>

# install (or: docker, or: go install github.com/aloisdeniel/cairn/cmd/cairn@latest)
$ curl -fsSL https://aloisdeniel.github.io/cairn/install.sh | sh

# run the server — data is just this directory; no password on the CLI:
# you choose the admin password in the browser at first sign-in
$ cairn serve --data-dir data --admin-email you@example.com

# log in, push, query — every command takes --json for agents
$ cairn login --host http://localhost:8787 --email you@example.com
$ cairn push ./dist --artifact my-app --create --public
$ cairn db query --artifact my-app --json "SELECT COUNT(*) FROM notes"
$ cairn files put ./report.pdf --artifact my-app --path exports/report.pdf

# prebuilt multi-arch image on GHCR — all state lives in the named volume
$ docker run -p 8787:8787 -v cairn-data:/data \
    -e CAIRN_ADMIN_EMAIL=you@example.com ghcr.io/aloisdeniel/cairn:latest

# or: docker compose up -d — a docker-compose.yml ships in the repo

<script src="./cairn.js"></script>
<script>
  await cairn.ready();
  const me = await cairn.me();               // null when anonymous
  await cairn.db.migrate('001-schema', [
    {sql: 'CREATE TABLE notes (id INTEGER PRIMARY KEY, body TEXT)'}
  ]);
  await cairn.db.query('INSERT INTO notes (body) VALUES (?)', ['hi']);
  const res = await cairn.db.query('SELECT * FROM notes'); // {columns, rows}
  await cairn.files.upload('photos/cat.png', blob);       // per-version files
  img.src = cairn.files.url('photos/cat.png');
</script>