Published:
Last updated:
PostgreSQL
PostgreSQL is a powerful object-relational database system with over 30 years of active development. It is renowned for its extreme reliability, data integrity, and correctness.
Core Concept
Strict SQL compliance paired with modern extensibility. Through extensions such as pgvector, Postgres becomes a full-featured vector database for AI applications, whilst simultaneously remaining the most stable foundation for transactional data.
Assessment
- Use case: The default backend for virtually every serious web application and data platform.
- Advantage: Enormous feature set (JSONB, GIS, full-text search), extremely stable, and available under a very permissive licence.
- Limitation: Administering large, highly available clusters requires specialist expertise (or the use of managed services).