What is PostgreSQL?

Web Development Jargons Explained in 5 Different Ways

TLDR: PostgreSQL is a relational database management system for storing and managing data. It is known for its reliability, and is popular for building mission critical applications used by financial services and large internet companies.


Explain like I only speak in plain English

PostgreSQL is a relational database management system for storing and managing data. It is known for its reliability, and is popular for building mission critical applications used by financial services and large internet companies.

PostgreSQL stores data in categories called tables, such as authors or books. Each table contains rows and columns. Each row represents one data entry, such as "Leo Tolstoy" or "War and Peace". Each column holds an attribute belonging to an entry, such as "Country of Origin" or "Publish Year".

Explain like I'm a total nerd

PostgreSQL was started as a project called POSTGRES at Berkeley University by a researcher called Michael Stonebraker, who won a Turing award for his work. Early POSTGRES had a proprietary programming language and interface. After the POSTGRES project ended in 1994, two Berkeley graduate students swapped the original programming language with one of SQL.

In 1996, PostgreSQL was officially released and is continuously maintained by a group of engineers called The PostgreSQL Global Development Group. The latest stable version is PostgreSQL v10.

Explain like I'm an artist

PostgreSQL is a relational database management system. It is one example of the relation database management system umbrella. It deals with all parts of creating, reading, editing, and deleting data entries in a database. It is much like the storage system at a museum.

map.jpg

Explain like I like videos

Explain like I already know it

PostgreSQL is well known for its reliability. Its extension module PostGIS adds spatial abilities to PostgreSQL. It is very popular amongst tech companies that have very low tolerance for data corruption.

We are trusted by

Students and instructors from world-class organizations

Imperial College London
Carnegie Mellon University
City University of Hong Kong
Hack Reactor
Cisco Meraki
University of Oxford
Swift
Bazaarvoice
Waterloo
Uber
AtlanTech
Tumblr
Boston College
Bombardier Aerospace
University of St. Andrews
New York University
Minerva Schools at KGI
Merrill Lynch
Riot Games
JP Morgan
Morgan Stanley
Advanced Placement®
Google
KPMG
The University of Hong Kong
University of Toronto
SCMP
Moat
Zynga
Hello Toby
Deloitte
Goldman Sachs
Yahoo
HSBC
General Assembly
Tesla
McGill University
Microsoft

Join the upcoming Cohort #72

Enroll for December 5th, 2022