PostgreSQL + pgvector now share the data layer
PostgreSQL is the system of record, with pgvector providing semantic retrieval inside the same durable data layer.
Key takeawayIt means semantic search quality is not a hard dependency — worst case, retrieval degrades to keyword matching instead of erroring out.
Content
The current architecture uses PostgreSQL as the system of record for CMS content, settings, relationships, and operational data. pgvector extends that same database with embedding storage and similarity search, so semantic memory no longer sits in a separate optional store.
That consolidation removes the old MySQL-versus-Postgres split from the architecture story: authored content and the vectors derived from it now share one durable data layer, while Alex OS remains a separate FastAPI reasoning service.