Hello evryone,
I am following a course about WeWeb / Supabase.
I learned how to make pagination. Super easy, thank you WeWeb Dev 
I have a performance question.
When I filter the columns (fields) of collections — for example, I only want to display First Name and Last Name, and not Date of Birth —
does that improve the performance of the application?
And going further, is it also a good security practice, since the Date of Birth field won’t even be sent to the frontend?
OR I have also to manage performance, filter, in Supabase ?
Thank you
Hi, when you’re filtering in WeWeb at the collection level, it makes you filter in Supabase (on the back-end) by default. As for your question, it widely depends, but I think less is more, and it’ll also make your life a little bit easier if you get only the things you need. I think security wise, unless you implement policies to stop people from getting the DOB, they’ll still be able to get the DOB from the DB, so I wouldn’t solely rely on the fact that “If I don’t fetch it - people can’t see it”.
I have a blog post about how to fetch data from Supabase in an Advanced way if you’re down for some reading. It might also clarify some things.
2 Likes