How to complex query (Supabase)? What is the best formant solution?

[Broberto]

@jptrinh

You can also select those elements directly in Supabase using views.

Views even though very useful, are not indexable, which might be an issue with big amounts of data. By the way, please, don’t spam the forum with posts that are basically the same thing.

How to create more complexe query in weweb? (left join, etc)

Probably what they mean is that they’ve read somewhere around the forum me, or someone else stating that views indeed aren’t indexed, so it takes a longer time with huge amount of records to filter them.