SQL: Using TablePlus

One of my favorite tools to interact with databases is TablePlus.

TablePlus is an application that is available for any Operating System (Mac, Windows, Linux) and can be dowloaded freely from https://tableplus.com/

It’s a paid app but has a free version which provides all you need to get started.

Once installed you’ll see a screen similar to this:

From here you can connect to a new database by clicking the + button or right-clicking and clicking New → Connection… or from the menu bar “Connection → New”:


From there you have the choice of setting up a connection to basically any kind of database:


If you already have a database set up, you can get its connection URL string, and click “Import from URL” in this screen.

If you don’t, we first have to create a database.

We’re going to use PostgreSQL, which I think is a super flexible and powerful solution.

Lessons in this unit:

0: Introduction
1: ▶︎ Using TablePlus
2: Create a Postgres database
3: Create a new table
4: Add data to a table
5: Query data with SELECT
6: Delete data from the database
7: Update data with UPDATE
8: Null constraints
9: Unique and primary keys
10: Updating a table structure
11: Joins
12: DEMO Using Vercel Postgres COMING SOON
Are you intimidated by Git? Can’t figure out merge vs rebase? Are you afraid of screwing up something any time you have to do something in Git? Do you rely on ChatGPT or random people’s answer on StackOverflow to fix your problems? Your coworkers are tired of explaining Git to you all the time? Git is something we all need to use, but few of us really master it. I created this course to improve your Git (and GitHub) knowledge at a radical level. Launching May 21, 2024. Join the waiting list!