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
Sur cette page du site, vous pouvez voir la vidéo en ligne Simplify complex SQL queries with Views in Postgres durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Supabase 23 mars 2024, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 17,733 fois et il a aimé 338 téléspectateurs. Bon visionnage!
