So I have a question about best practices when working with collections in WeWeb. Should I have only one collection per table?
Using collections is a convenient way to filter data, especially when filters are applied at the time the collection is created. Here’s my scenario:
I have a collection called users that retrieves all users from the table — I’m not applying any filters to it, so it returns everything.
Now, I also have a user profile page where the authenticated user can view and edit their information. For this, I created a new collection called user_by_id, which pulls data from the same table, but with a filter applied: where id = auth.user.id so it brings only one user data.
Is this a bad practice in WeWeb? Or is it acceptable to have multiple collections from the same table with different filters, depending on the use case?
