Скачать или смотреть Simplify complex SQL queries with Views in Postgres

Writing raw SQL can be extremely powerful, but queries that are joining tables and aggregating data can quickly increase in complexity. In this video, Jon Meyers steps through refactoring an existing application to query Views instead of Tables, greatly simplifying PostgreSQL queries.

Building an email client with the Next.js App Router and Postgres:    • Building an email client with the Next.js ...  

00:00 Simplify complex SQL queries with Views in Postgres
01:26 Creating a free Supabase project
03:41 Refactor data fetching logic to use supabase-js
08:55 Create a PostgreSQL view using Supabase AI
12:01 Refactoring a complex query with multiple joins to use Postgres Views
25:47 Perform complex mutations using Postgres Functions and Transactions

📹 Full Next.js Email Client playlist:    • Build an Email Client with the Next.js App...  
🧑‍💻 GitHub repo: https://github.com/dijonmusters/nextj...

Introspect PostgreSQL schema and generate TypeScript definitions:    • Introspect PostgreSQL schema and generate ...  

💻 Videos to watch next:
▶ Fastest way to host a Postgres database:    • FASTEST way to host a Postgres database (2...  
▶ Implement Authorization using Row Level Security with Supabase:    • Implement Authorization using Row Level Se...  
▶ Generate column values in Postgres with Functions, Triggers, default values and RLS:    • Generate column values in Postgres with Fu...  

👇 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://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