Simplify complex SQL queries with Views in Postgres

Veröffentlicht am: 23 März 2024
auf dem Kanal: Supabase

17,733

338

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

Auf dieser Seite können Sie das Online-Video Simplify complex SQL queries with Views in Postgres mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Supabase 23 März 2024 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 17,733 Mal angesehen und es wurde von 338 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

54,509