Keeps this page in sync as the body changes. Pause it any time for a quieter view.
Path /specs/postgresql-migration
Last refresh never
... 98 more in Requirements section below
inventory_source local | spec_api /api/spec-registry/postgresql-migration | registry_updated 2026-04-09T03:10:08.995044Z
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
Missing contributor linkage. Submit a change request with contributor attribution.
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 -
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 -
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.
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 -
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)