AI Workshop: learn to build apps with AI →
PostgreSQL
Learn PostgreSQL, one of the most popular open source relational database management systems

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

PostgreSQL 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.

In this unit you’ll learn how to install PostgreSQL, create databases, manage users and permissions, and where to host your database.

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