@atria/db

Database layer for atria runtime/auth/pages state.

Install

npm install @atria/db

Responsibilities

• Resolve DB connection (ATRIA_DATABASE_URL, DATABASE_URL, fallback SQLite).
• Initialize SQLite database file.
• Initialize auth and pages schema.
• Store users, credentials, OAuth identities, sessions, pages, routes, versions, and workspaces.

Public API

import {
  openDatabase,
  initializeDatabase,
  ensureAuthSchema,
  ensurePagesSchema
} from "@atria/db";

Connection resolution order

1. ATRIA_DATABASE_URL
2. DATABASE_URL
3. local fallback: ./.atria/data/atria.db

Tables managed

• users
• user_credentials
• identities
• sessions
• documents
• document_versions
• routes
• navigations
• workspaces