Simplify complex SQL queries with Views in Postgres

[@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!

[@mrrolandlawrence]

Views are so under rated. So glad that feature is getting some love.

[@TheSlyProfessor]

I've been watching a lot of your videos and things are clicking. Thank you so much!

[@Speechrezz]

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

[@loucasi]

Supabase videos in general are very helpful and the content is great , I really think it's time to start making these with an AI on the side bcs at this level of coding I think everyone would be better off learning the prompts we have to send in order to get the code. Tutorials should focus on: this is how you prime the model to be ready for a "Views + RLS on Supabase" conversation and that's how you prompt for each case. Instead of losing time to actually record themselves writing the code it would be much more SCALABLE advice to figure out where the AI model is prone for a mistake and the tutorial showing what to look for or how to avoid it all together. Thoughts? Here they do it already a bit with the in-house supabase AI but I tried it and it does make mistakes - which I used Claude 3.5 to fix!

[@VincentFulco]

Thanks for this example!

[@JonMeyers]

Glad you enjoyed it! Thanks for watching 🙌

[@0xtz_]

we have views in our app but after adding ton and ton of data the pagination takes like 40 s but the raw query takes only 150ms 😢 so we switched to raw SQL in some places with zod for types

[@caseyspaulding]

This is supa helpful. Thanks.

[@brotherly9058]

Compared to with-clause, which one is better practice?

[@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.

[@Kkvta]

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.

[@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

[@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.

[@imho7992]

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

[@BlazeShomida]

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);`

[@nafg613]

Would be nice if Supabase let you edit views

[@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

[@Laflamablanca969]

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

[@rtorcato]

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