Hi, is there a sql template/tutorial to create something like a "session for multiple users" like garticphone or something like that. The first user starts a session without logging in/signing up, shares the id and the other users can "join his session". Doodle makes the same, but more "async" (hope you understand what i mean...my eglish is not the best 😄 ) Thanks!

You could use something like

gen_random_uuid()

(requires the pgCrypto extension to be installed and enabled) to generate a UUID that could then be shared. Store that value in the database. When someone enters this ID to join the session, retrieve all records with that ID from the database. Everything else would be dependant on your backend and front-end architecture, as well as what you're trying to achieve.

Ok, Thank you. I will have a look at these function. Maybe it solves my problem 🙂

It depends on what policies you implement. They can implement any logic you want as long as they return a boolean value. For example, an RLS update policy of

false

prevents people from changing any rows in the table that it's applied to. Likewise, an RLS select policy of

true

would allow anyone to view any data in that table.

ah ok... Thank you