In the Context Engine, PostgreSQL serves as the source of truth with JSONB and full-text search support using asyncpg so that canonical structured and searchable data is stored in PostgreSQL.

| PostgreSQL | Source of truth, JSONB, FTS | asyncpg |

— PYRANA_PLATFORM_ARCHITECTURE_REFERENCE.md

Architecture

— PYRANA_PLATFORM_ARCHITECTURE_REFERENCE.md

five storage/messaging backends

— PYRANA_PLATFORM_ARCHITECTURE_REFERENCE.md