{"spec_id":"unified-sqlite-store","title":"Unified SQLite Store — Single Source of Truth","summary":"**Idea**: `unified-persistence` (sub-idea of `coherence-signal-depth`)","potential_value":0.0,"actual_value":1.0,"estimated_cost":0.0,"actual_cost":1.0,"value_gap":0.0,"cost_gap":1.0,"estimated_roi":0.0,"actual_roi":1.0,"idea_id":"data-infrastructure","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":null,"implementation_summary":"api/app/services/unified_db.py (Base, engine_cache, schema init)","created_by_contributor_id":null,"updated_by_contributor_id":null,"created_at":"2026-04-09T03:10:09.052655Z","updated_at":"2026-04-09T03:10:09.052655Z","content_path":"specs/unified-sqlite-store.md","content_hash":"0d4d76478600478c","workspace_id":"coherence-network"}