PostgreSQL (often called Postgres) is a powerful, enterprise-grade relational database system. It supports SQL standards and offers advanced features including: ACID transactions, JSONB for document storage, full-text search, geospatial data (PostGIS), custom functions, and extensions like pgvector for AI embeddings. Known for reliability, data integrity, and extensibility.
🗄️ Database intermediate
PostgreSQL
Open-source relational database with advanced features like JSONB, full-text search, and extensions.
4
views
// Example Usage
SELECT * FROM users WHERE data @> '{"role": "admin"}';
</> Related Terms
Vector Database
Specialized database for storing and searching high-dimensional vector embeddings.
pgvector
PostgreSQL extension that adds vector similarity search capabilities for AI and machine learning applications.
ORM (Object-Relational Mapping)
Programming technique that converts data between object-oriented code and relational databases.