{"spec_id":"postgresql-migration","title":"... 98 more in Requirements section below","summary":"Migrate in-memory data stores (GraphStore and AgentTask storage) to PostgreSQL for production scalability, data persistence, and multi-instance support. Enable zero-downtime migration via dual-write and gradual read switchover.","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":"PostgreSQL schemas defined for all in-memory stores; Projects table with (ecosystem, name) unique constraint; Project dependencies table (graph edges) with foreign keys; Contributors table with UUID primary keys; Assets table with UUID primary keys","pseudocode_summary":null,"implementation_summary":"api/app/services/unified_db.py (database_url(), _create_engine()); api/app/adapters/postgres_store.py (PostgreSQL adapter); api/scripts/migrate_tracking_domains_to_postgres.py (migration script)","created_by_contributor_id":null,"updated_by_contributor_id":null,"created_at":"2026-04-09T03:10:08.995044Z","updated_at":"2026-04-09T03:10:08.995044Z","content_path":"specs/postgresql-migration.md","content_hash":"16e6f9a9588766be","workspace_id":"coherence-network"}