Databases Beginner

What is PostgreSQL?

An advanced open-source relational database known for its reliability, feature richness, and standards compliance.

PostgreSQL is a powerful, enterprise-class database supporting advanced features: JSON/JSONB for document storage, full-text search, window functions, CTEs (Common Table Expressions), materialized views, and custom types.

It offers excellent concurrency through MVCC (Multi-Version Concurrency Control), robust indexing options, and extensive extension ecosystem (PostGIS for geospatial, pg_trgm for fuzzy matching). It is the database of choice for many modern applications.

A technique where the database maintains multiple versions of data to allow concurrent reads and writes without locking.

Write-Ahead Log (WAL)

A technique where changes are first written to a log before being applied to the database, ensuring crash recovery and data integrity.

Soft Delete

A pattern where records are marked as deleted with a flag or timestamp rather than being physically removed from the database.

Graph Database

A database that uses graph structures with nodes, edges, and properties to store and query highly connected data.

Crosstab Query

A query that transforms rows into columns, creating a pivot table view of aggregated data.

View

A virtual table defined by a SQL query that provides a simplified or restricted view of data from one or more tables.

View All Databases Terms →