PostgreSQL: Introduction to PostgreSQL

Join the AI Workshop and learn to build real-world apps with AI. A hands-on, practical program to level up your skills.

PostgreSQL, also called Postgres, is one of the most popular SQL database management systems (DBMS) ever.

It is Open Source, free for personal and commercial use, and it has a long history that started in 1996, building on top of other software that dates back to the 1980s.

PostgreSQL is a really complete and full-featured general purpose relational database.

It provides support for most of the SQL standard, and also builds on top of it its unique set of features, to provide us a great tool.

You can find the project homepage at https://www.postgresql.org.

We can interact with a PostgreSQL database using many different programming languages. Internally, being a relational database we’ll use SQL to insert, query and manipulate the data.

Lessons in this unit:

0:	Introduction
1:	▶︎ Introduction to PostgreSQL
2:	How to install PostgreSQL on macOS
3:	How to create a PostgreSQL database
4:	Navigating Databases in PostgreSQL
5:	PostgreSQL User Permissions
6:	Tables and Data Types
7:	Where to host a PostgreSQL database
8:	PostgreSQL vs MySQL
9:	Troubleshooting PostgreSQL
10:	Vercel Postgres, no transactions?
11:	Set up Lucia Auth for local Postgres DB vs Vercel Postgres
12:	Connect to Postgres local vs Vercel Postgres with Kysely