PostgreSQL TutorialLesson 2Free preview

PostgreSQL Intro

This lesson is part of PostgreSQL · All levels

Summary

PostgreSQL grew out of the Ingres project at the University of California, Berkeley, and is now one of the most popular open source RDBMS in the world. Its object-relational nature makes it supporting tables, views, triggers, stored procedures, to custom data types. MVCC architecture also ensures that the reader does not block the author, making it suitable for applications with multiple users at once.

Key points

PostgreSQL evolved from the Ingres project at UC Berkeley in the late 1980s.
Object-relational properties: support for view, trigger, function, and custom data types.
Using MVCC (Multi-Version Concurrency Control) for simultaneous transactions.
It supports popular ACID, replication, and extensions such as PostGIS and pg_trgm.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.