web dev//SQL//PostgreSQL

PostgreSQL is the most standard-compliant and feature-rich open-source SQL database, a relational database with a server-client architecture that runs as a persistent process.

PostgreSQL is the most standard-compliant and feature-rich open-source SQL database, a relational database with a server-client architecture that runs as a persistent process.

It is stricter than MySQL in SQL compliance, so it catches more errors and leaves fewer surprises.

It is extensible, with custom types, functions and extensions like pgvector for vector search. With pgvector, SQL JOINs, complex filters and cosine similarity search run in a single query, though pure vector search is slower than in a dedicated vector database; the common alternative keeps PostgreSQL for the relational data and Pinecone for the vectors, synced through IDs.

Its concurrency model (MVCC) is designed for heavy multi-user workloads.