Web Dev//SQL//PostgreSQL

Relational database. The most standard-compliant and feature-rich open-source SQL database. Server-client architecture — runs as a persistent process.

Relational database. The most standard-compliant and feature-rich open-source SQL database. Server-client architecture — runs as a persistent process.

More strict than MySQL in SQL compliance — catches more errors, fewer surprises

Extensible: supports custom types, functions, and extensions like pgvector for vector search

Strong concurrency model (MVCC) — designed for heavy multi-user workloads

The combination of relational queries + pgvector means you can do SQL JOINs, complex filters, AND cosine similarity search in a single query. All in one DB. The tradeoff: not as fast at pure vector search as dedicated vector databases like Pinecone

Common pattern: PostgreSQL for everything (relational + vectors via pgvector) when simplicity matters. PostgreSQL + Pinecone (via synced IDs) when vector scale matters.