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 clie...
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 ...
🧑‍💻 GitHub repo: github.com/dijonmusters/nextj...
Introspect PostgreSQL schema and generate TypeScript definitions: • Introspect PostgreSQL ...
💻 Videos to watch next:
▶ Fastest way to host a Postgres database: • FASTEST way to host a ...
▶ Implement Authorization using Row Level Security with Supabase: • Implement Authorizatio...
▶ Generate column values in Postgres with Functions, Triggers, default values and RLS: • Generate column values...
👇 Learn more about Supabase 👇
🕸 Website: supabase.com/
🏁 Get started: app.supabase.com/
📄 Docs: supabase.com/docs
🔔 Subscribe for more tutorials and feature updates from Supabase: / @supabase
📱 Connect with Us:
🐙 Github: github.com/supabase
💬 Discord: 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

[@remi-avec-un-i]

Views are something I already heard of but never saw in action, thanks J

[@JonMeyers]

Yeah, they are very handy for something so simple to create! Glad you enjoyed the video! 🙌

[@canergurelsoy6875]

I'm just loving supabase more and more everyday . Nice job, pls keep bringing it.

[@parkerrex]

the videos help a lot

[@JonMeyers]

Glad you enjoyed it! What are you going to build?

[@JonMeyers]

@@parkerrexthanks! 🙌 What would you like to see a video on next?

[@dshukertjr]

I didn't know that `returns()` function on the `select()` call existed! That's very handy!

[@JonMeyers]

Yeah, I only learnt about it while putting this video together! Very handy!

[@Speechrezz]

Really helpful video, thank you! I've started using views in my own Supabase project now and it really simplified my queries!

[@VincentFulco]

Thanks for this example!

[@JonMeyers]

Glad you enjoyed it! Thanks for watching 🙌

[@tonyoconnell99]

I really love this tutorial. i learned so much both yourself and lee. i'm going to use it to replace charbot ui 's frontend (but not their supabase backend) so my users can have conversations with different ai models faster. i would really appreciate a link to a github repo of the code you wrote for supabase. i couldn't find your repo anywhere. if needed i will type the code code from the tuturial and still be happy.

[@LM43243]

As somebody here in the comments mentioned, please do a video on encrypting data! Can't seem to figure out how to do it with next / supabase for my db.

[@Laflamablanca969]

You are very enthusiastic… way too enthusiastic lol. Chill bruz

[@user-vd3ph6zh8q]

Is it better to create a client for each function call over exporting a global constant of the client instance? Like `export const supabase = createClient(SUPABASE_URL, SUPABASE_ANON_KEY);`

[@slavenDj]

Great videos! Is there going to be a video about encryption. Example i have not read anywhere that when i add security label via sql editor to a column it automatically creates trigger and views for decryption

[@imho7992]

Can views also transform POSTGIS geography coordinates back to lat / lng integers?

[@hawarhekmat1174]

Sign in with Google using server action with a client button won't work, when I log the data it gives back a url but in browser won't redirect to Google sign in page but in vscode console when I click on the url it does, maybe it's because of new Google sign in thing.

[@twisterrjl]

Have you also changed the link in supa > auth > url configuration? I sometimes forget to do that

[@rohan7011]

Where is the original video link?

[@JonMeyers]

You mean for Lee’s version? Will add it to the description! Thanks for the reminder!

[@tonyoconnell99]

@@JonMeyers Here's another reminder. I can't wait to use it. It's such a wonderful example of what Supabase can do. The code and design of the email client's is beautifully simple, and your database is simple and succint. There is nothing faster. Thanks for making this and for teaching me how to do it.

[@Alex-bc3xe]

Hmm I then see no reason to use an ORM cause supabase has pretty easy synthax

[@rtorcato]

drizzle has support for views and coming soon foreign table support too, which is great for migrations.. Does Supabase use drizzle?