PostgreSQL
A powerful, standards-compliant open-source relational database.
CurrentbeginnerBeginner-friendlyFull course available
Overview
PostgreSQL is an open-source relational database known for strict SQL standards compliance, advanced features (JSON columns, full-text search, extensibility), and reliability -- a common default choice for new production applications.
- What it is
- An open-source, standards-compliant relational database management system.
- Why it's used
- For its correctness, advanced feature set (JSONB columns, window functions, extensions), and strong reputation for reliability.
- Where it fits
- One of several concrete SQL database engines; this platform's own Supabase integration (when configured) is built on PostgreSQL. This platform's Database Design and PostgreSQL course goes beyond basic SQL into relational modeling, normalization, real PostgreSQL types, transactions, indexing, and operational safety.
Core concepts
- Standard SQL plus extensions (JSONB, arrays)
- Indexes
- Row Level Security
- Transactions
Example
gen_random_uuid() generates a non-sequential unique ID -- a common PostgreSQL pattern (used throughout this platform's own database schema) for IDs that shouldn't reveal creation order.
CREATE TABLE books (
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
title TEXT NOT NULL
);Common use cases
- Production application databases
- Analytical workloads needing advanced SQL features
Project ideas
- Recreate the bookstore schema from this platform's SQL lessons in a local PostgreSQL instance