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)
🐘 Learn Postgres (playlist): • Learn Postgres
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:
▶ Make your queries 43,240x faster: • Make your queries 43,240x faster
▶ Postgres scales … when you do this!: • Postgres scales … when you do this!
▶ 8 things you should NEVER do in a Database!: • 8 things you should NEVER do in a Dat...
👇 Learn more about Supabase 👇
🕸 Website: https://supabase.com/
🏁 Get started: https://app.supabase.com/
📄 Docs: https://supabase.com/docs
🔔 Subscribe for more tutorials and feature updates from Supabase: / @supabase
📱 Connect with Us:
🐙 Github: https://www.github.com/supabase
💬 Discord: https://discord.supabase.com/
🐦 Twitter: / supabase
▶ Instagram (follow for memes): / supabasecom
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
