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 -

evidence_refs -

Linked Implementation

Open implementation view for this spec

implementation_refs -

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