Spec unified-sqlite-store

Spec Source

inventory_source local | spec_api /api/spec-registry/unified-sqlite-store | registry_updated 2026-04-09T03:10:09.052655Z

Open spec API record

Spec Value/Cost/Gap Sensing

potential_value 0.00 | actual_value 1.00 | value_gap 0.00

estimated_cost 0.00 | actual_cost 1.00 | cost_gap 1.00

estimated_roi 0.00 | actual_roi 1.00

Linked Ideas

• data-infrastructure

Linked Contributors

Missing contributor linkage. Submit a change request with contributor attribution.

Linked Process

Open process view for this spec

task_ids -

branches -

source_files specs/api-request-logging-middleware.md, specs/canonical-route-registry-and-runtime-mapping.md, specs/coherence-algorithm-spec.md, specs/postgresql-migration.md, specs/release-gates.md, specs/runtime-telemetry-db-precedence.md, specs/unified-sqlite-store.md, specs/universal-node-edge-layer.md

evidence_refs -

Linked Implementation

Open implementation view for this spec

implementation_refs spec-registry:api-request-logging-middleware, spec-registry:canonical-route-registry-and-runtime-mapping, spec-registry:coherence-algorithm-spec, spec-registry:postgresql-migration, spec-registry:release-gates, spec-registry:runtime-telemetry-db-precedence, spec-registry:unified-sqlite-store, spec-registry:universal-node-edge-layer

lineage_ids -

public_endpoints -

Spec Summary + Process + Pseudocode + Implementation Notes

summary **Idea**: `unified-persistence` (sub-idea of `coherence-signal-depth`)

process_summary All services use unified_db.session() for database access; Single COHERENCE_DATABASE_URL env var controls all persistence; JSON file stores migrated to SQLAlchemy tables; Old per-service DB env vars still work as fallbacks during migration; Tests configurable with one env var for isolated test DB

pseudocode_summary -

implementation_summary api/app/services/unified_db.py (Base, engine_cache, schema init)

API Links

• /api/spec-registry/unified-sqlite-store
• /api/inventory/flow
• /api/inventory/system-lineage