Skip to main content

ADR-0114: PostgreSQL as source of truth

Context​

Kit sections 6.2 and 2.

Decision​

PostgreSQL holds metadata, governance, state, audit, Kill Switch and licences; versioned migrations sql/postgres/V<NNN>__<name>.sql, never changed once shipped. Client provided except in sandbox for navin-manager.

Consequences​

PostgreSQL licence exception recorded.

Evidence​

  • sql/postgres
  • services/control-plane/src/eai/migrate.py
  • services/control-plane/tests/test_core_migrations.py
  • RULES.md (section 4, point 5)