import type { CollectorStore } from "./store.js"; /** * Optional single-tenant Microsoft SQL Server store (ADR 0020, #85): the * relational, multi-writer path for self-hosters standardized on SQL Server / * Azure SQL who have outgrown DuckDB's single read-write process. It carries * the **full** analytics surface — no stubbed aggregates — by rendering the same * dialect-agnostic builders with {@link mssqlDialect} (vectors as JSON, ASOF * joins emulated via `CROSS`/`OUTER APPLY`, daily rollups recomputed at query * time) and executing them over a pooled `mssql` (tedious) connection. Events * live in the wide `events` table (plus the dedicated `node_samples`); metadata * (projects, API keys, scene registry) is re-homed into the same database. * * The database is created on first boot when the login may (`CREATE ANY * DATABASE`), and the schema is migrated on creation (migrations are * idempotent, forward-only and serialized behind an application lock, so * several collector instances can boot against one database). Connection * settings come from `readDbSettings().mssql` (`MSSQL_URL`, or `MSSQL_SERVER` / * `MSSQL_PORT` / `MSSQL_DATABASE` / `MSSQL_USER` / `MSSQL_PASSWORD` with * `MSSQL_ENCRYPT` / `MSSQL_TRUST_SERVER_CERTIFICATE`, plus `MSSQL_POOL_MAX`). */ export declare function createMssqlStore(): Promise; //# sourceMappingURL=mssqlStore.d.ts.map