that was what I thought. But didn't want to invent the wheel if there is something already

that I didn't knew

ha, found this: https://www.enterprisedb.com/postgres-tutorials/how-implement-column-and-row-level-security-postgresql sounds like its possible. not sure tho about supabase

something like

GRANT INSERT
  (name, picture, etc)
  ON profile TO public;

@User 👆

Strange not needing a policy. Will try.

more on this: https://www.postgresql.org/docs/9.5/ddl-rowsecurity.html

I built an app with Ember and Firebase many years ago.

I remember, to my surprise, the notifications for new comments, etc, come in instantly in real time because some how firebase + ember firebase adapter automagically gave me that feature.

Is supabase with Next similar?

Yeah you could make something similar!

The future is now!

Gm

Trying to create tables from my postgres client instead of supabase editor.

permission denied for table users. I'm doing references. Do you know any way?

trying the

create table leaderboard (
  id uuid references auth.users,
  high_score bigint
);

throws the same error if you need to test it. operator does not exist: uuid = bigint

If I replace it for auth.users.id it shows that cross-database isn't allowed as well

If you specify

public

as the schema for the table, does it work?;

sql
CREATE TABLE public.leaderboard (
  id uuid references auth.users,
  high_score bigint
)

Also, this probably belongs in the #869405720934744086 channel

auth.users.id

Hi here, lets try to use threads everywhere 🧵. It is hard to follow the conversation if it is one giant wall of text. Also, a reminder that if you have questions, to post it in our Github discussions - https://github.com/supabase/supabase/discussions. Other users might have the same questions that you have and discussions are more searchable and organised than Discord. We try to answer every question there, since it is easy to filter by unanswered questions and try to help out.

Are you guys planning to add realtime updates to supabase admin page just like firebase?

If you enable replication, it updates in realtime I believe

Oh isee let me try

Where do I find replication

Yeah got it

https://app.supabase.io/project/{your-project-id}/database/replication

Hi everyone,

What would be the easiest way to paginate queries ?

comes built in?