13min High Intensity Postgres Workout (NO REPEATS)

The only way to get REALLY good at something is to actually do it ... over and over! In this video, Jon Meyers takes us through some Postgres Drills that is guaranteed to make you better at databases!

This one covers:
• Int vs Bigint
• Truncate with Cascade
• Common Table Expressions (CTE)

00:00 Create one-to-many relationship: Problem
01:29 Autoincrementing Integers with Serial
02:26 Int vs BigInt and Serial vs BigSerial
04:00 Create one-to-many relationship: Solution
06:34 Insert data with multiple SQL statements
08:28 Cascade deletes across tables with Truncate
10:03 Common Table Expressions (CTE) to insert data across tables
12:52 You should learn about Indexing!

💻 Videos to watch next:

👇 Learn more about Supabase 👇

📱 Connect with Us:

ABOUT SUPABASE:
Supabase is the open source Firebase alternative. Supabase provides a full Postgres database for every project with pgvector, backups, realtime, and more. Add and manage email and password, passwordless, OAuth, and mobile logins to your project through a suite of identity providers and APIs.

Build in a weekend, scale to millions.

#Supabase #AppDevelopment #RealtimeApps #DeveloperTools

[skypuff]

🔥🔥🔥Make this a video series, seriously.

[andydataguy]

I love the training approach! You've inspired me for a content series 😁

[jondoe]

This channel keeps getting better and better 👍

[imho]

CTE is super useful! PLEASE do a video on how to do this with the Supabase JS client and postgrest!

[mikejohneviota]

yay supabase slowly teaching us how to raw sql and avoid using their GUI 😂

[rickhmason]

Read in a post on Postgres that serial and bigserial were deprecated and it wasn't good practice to use them. For the life of me I cannot remember the reason they gave. Is it not true? I would much prefer creating primary keys that are autoincrementing.

[andrewzuo]

4 bytes is too large? *Laughs in 1000+ character plain text AI generated summaries*