@surveilr/ontology

Drizzle ORM schema for the RSSD (Resource Surveillance State Database) system.

Installation

npm install @surveilr/ontology better-sqlite3 drizzle-orm

Initialization

To initialize the database using surveilr, run the following commands:

# Ingest files to create the initial database
surveilr ingest files -d rssd.db

Usage

import { drizzle } from "drizzle-orm/better-sqlite3";
import Database from "better-sqlite3";
import * as schema from "@surveilr/ontology";

const sqlite = new Database("rssd.db");
const db = drizzle(sqlite, { schema });

// Use your type-safe database
const devices = await db.select().from(schema.device);

console.log(devices);

Structure

• models.ts: Table definitions
• relations.ts: Table relations
• views.ts: SQL view definitions (Drizzle-based)
• index.ts: Main entry point exporting all schemas