UUID vs bigint for users table
I’m trying to decide on format for the private key of my public.users table (and subsequently all tables that reference the users with a foreign key).
Let’s simplify and say I’m choosing between int8 and UUIDv4. The Supabase docs has a great article that concludes that integer is the most performant. But it doesn’t mention any considerations around row level security, which seems to require UUID (or email) from the users.auth() table.
Is it a choice between either best performance or access to RLS policies? Am I thinking about this right?
Let’s simplify and say I’m choosing between int8 and UUIDv4. The Supabase docs has a great article that concludes that integer is the most performant. But it doesn’t mention any considerations around row level security, which seems to require UUID (or email) from the users.auth() table.
Is it a choice between either best performance or access to RLS policies? Am I thinking about this right?
