Is there any way for me to be able to allow to create a public share url of a filtered row with read only access?
The scenario is that I have a
item
item
table and I create a custom view of this as a end user filtering on a few rows and that I own it:
SELECT * FROM item WHERE owner_id='myuserid' AND type='cats'
SELECT * FROM item WHERE owner_id='myuserid' AND type='cats'
Then I want to make a publicly shareable url to view this. Any idea on how to do that with supabase? Usually with a nodejs backend e.g. the nodeJs would have full read access to the table and could get those elements and show them based on a "public" table or something.
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.