@paraharness/sqlite
Variables
| Variable | Description |
|---|---|
| SQL_IDENTIFIER_REGEX | Regular expression enforcing safe SQL table and identifier syntax (^[A-Za-z_][A-Za-z0-9_]*$). |
| sqlite | Pure AST builder namespace for @paraharness/sqlite storage and source adapters. |
| SQLITE_DDL_STATEMENTS | Idempotent SQLite DDL statements initializing tables for SqliteLedgerStore, SqliteTopologyStore, and SqliteLessonStore. |
| SQLITE_PRAGMA_STATEMENTS | SQLite connection PRAGMA statements executed immediately when opening a WAL-mode database. |
| sqliteExecutors | Pre-built RuntimeExecutorRegistrySlice for @paraharness/sqlite. |
Functions
| Function | Description |
|---|---|
| assertValidSqlIdentifier | Validates that identifier matches ^[A-Za-z_][A-Za-z0-9_]*$. |
| computeNormalizedRelevance | Computes normalized text relevance $R(L, Q) \in [0, 1]$ between a single lesson directive and queryText via MiniSearch. |
| computeNormalizedRelevanceScores | Computes normalized BM25 + fuzzy/prefix relevance scores $R(L, Q) \in [0, 1]$ across candidates using MiniSearch. |
| createCompactionConfigBuilder | Creates an immutable CompactionConfigBuilder instance for ledger wire-frame pruning policies. |
| createSqliteExecutors | Creates a RuntimeExecutorRegistrySlice registering all @paraharness/sqlite storage and source executors. |
| createSqliteGlobalRulesBuilder | Creates an immutable SqliteGlobalRulesBuilder for uri and options.table. |
| createSqliteLedgerBuilder | Creates an immutable SqliteLedgerBuilder targeting uri. |
| createSqliteLessonsBuilder | Creates an immutable SqliteLessonsBuilder targeting uri. |
| createSqliteTopologyBuilder | Creates an immutable SqliteTopologyBuilder targeting uri. |
| executeSqliteGlobalRulesSource | Executes a SqliteRulesSourceNode (type: 'sqlite:global-rules') to load ordered global rules. |
| openSqliteConnection | Opens or initializes a WAL-mode better-sqlite3 database connection and applies all schema DDL statements. |
Classes
| Class | Description |
|---|---|
| SqliteLedgerStore | WAL-mode SQLite implementation of the @paraharness/core LedgerStore runtime port. |
| SqliteLessonStore | WAL-mode SQLite implementation of the @paraharness/core LessonStore runtime port. |
| SqliteTopologyStore | WAL-mode SQLite implementation of the @paraharness/core TopologyStore runtime port. |
Interfaces
| Interface | Description |
|---|---|
| CompactionConfigBuilder | Fluent configurator for SQLite and PostgreSQL ledger wire-frame compaction policies (.compactWhen($c => ...)). |
| CompactionSignalTriggerOptions | Options for configuring a signal-correlated ledger compaction trigger via CompactionConfigBuilder.onSignal. |
| CompactionTerminalExitOptions | Options for configuring a terminal exit state compaction trigger via CompactionConfigBuilder.onTerminalExit. |
| SqliteGlobalRulesBuilder | Fluent builder for a passive SqliteRulesSourceNode (sqlite.globalRules(uri, { table })). |
| SqliteGlobalRulesOptions | Options passed to sqlite.globalRules(uri, options). |
| SqliteLedgerBuilder | Fluent builder for a passive SqliteLedgerNode (sqlite.ledger(uri)). |
| SqliteLedgerNode | Passive AST node configuring a WAL-mode SQLite ledger store (sqlite.ledger). |
| SqliteLessonsBuilder | Fluent builder for a passive SqliteLessonsNode (sqlite.lessonStore(uri)). |
| SqliteLessonsNode | Passive AST node configuring a WAL-mode SQLite lesson store (sqlite.lessonStore). |
| SqliteNamespace | Public builder namespace contract exported as sqlite from @paraharness/sqlite. |
| SqliteRulesSourceNode | Passive AST node loading global rules from a SQLite table (sqlite.globalRules). |
| SqliteTopologyBuilder | Fluent builder for a passive SqliteTopologyNode (sqlite.topologyStore(uri)). |
| SqliteTopologyNode | Passive AST node configuring a WAL-mode SQLite topology store (sqlite.topologyStore). |