PostgreSQL serves as the source of truth and provides JSONB and full-text search capabilities in the Context Engine using asyncpg so that canonical structured storage is maintained in the relational backend.

Supporting contexts

Quoteverbatim

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

— PYRANA_PLATFORM_ARCHITECTURE_REFERENCE.md

Quoteverbatim

PostgreSQL

— PYRANA_PLATFORM_ARCHITECTURE_REFERENCE.md

Quoteverbatim

Source of truth, JSONB, FTS

— PYRANA_PLATFORM_ARCHITECTURE_REFERENCE.md

Effective from: 7/16/2026, 11:29:13 PM