PostgreSQL serves as the source of truth and provides JSONB and full-text search capabilities in the Context Engine using asyncpg so that primary structured storage is centralized there.

Supporting contexts

Quoteverbatim

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

— PYRANA_PLATFORM_ARCHITECTURE_REFERENCE.md

Quoteverbatim

Source of truth, JSONB, FTS

— PYRANA_PLATFORM_ARCHITECTURE_REFERENCE.md

Quoteverbatim

asyncpg

— PYRANA_PLATFORM_ARCHITECTURE_REFERENCE.md

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