Guided Notes
Introduction to PostgreSQL
What sets Postgres apart, and connecting to a database.
PostgreSQL ('Postgres') is an open-source relational database known for strict standards compliance and a rich feature set — window functions, full-text search, and native JSON support beyond plain SQL.
Like other relational databases, data lives in tables inside a database, queried with standard SQL — but Postgres adds its own extensions, like the JSONB type for storing and querying JSON documents inside a relational table.
Constraints (NOT NULL, UNIQUE, CHECK, foreign keys) are enforced directly by Postgres — they're the database's own guarantee about data integrity, not something application code has to re-check.