And here is the next.js use of it:

ts
import { Provider as SupabaseProvider } from 'react-supabase';
import { AuthProvider } from "components/authProvider";
import { supabase } from "services/supabase";
import React from 'react';

const App = ({ Component, pageProps }) => {
  return (
      <SupabaseProvider value={supabase}>
        <AuthProvider>
          <Component {...pageProps} />
        </AuthProvider>
      </SupabaseProvider>
  )
}

export default App;

Is there a way to do FKs in the dashboard? Just found it smh

You could always search for issues. And the make one of you can't find it

Anyone been able to combine multiple

contains

filters?

I have combined, but they work as an

and

and I need it to work as an

or

have opened this discussion: https://github.com/supabase/supabase/discussions/3540 with a bit more detail

if I call the signUp function like this:

js
const {error} = supabase.auth.signUp({email, password}, {data: {account_type}})

how do I get the data value in the backend?

I believe it's stored in the auth.users table. To view it you need an external postgres client. Although it looks like the UI is starting to add support for multiple schemas

Yes. Thanks for the information. I found it in the column

raw_user_meta_data

Awesome! Glad you got it working, have you got a trigger setup to automatically copy that to your own users table in the public schema? As the Auth schema is hard to work with if you use it as a foreign key

Oh. That exactly how I was planning to use it (foreign key).

I can get you an example from a project of mine if it helps? It uses a trigger so whenever a user signs up it makes a row in our own table that way it's easier to manage

Isn't trigger in Alpha preview yet?

Triggers are out fully afaik

Also there just a feature of postgresql not a supabase implemented thing

I would like to see your example project.

Sure! https://github.com/HarryET/github-chat

If you look in the database folder that has everything todo with our supabase!

How do we write a RLS policy for

auth.users

table? For purposes of a demo account and I want to prevent from anyone who can access that to update the password.

I haven't done it before but I think

auth.users

just like other tables, you can write the RLS normally.

I am trying to limit the file size a user can upload to a bucket. I thought it would be possible to use a RLS for that.

sql
(
  (bucket_id = 'avatars':: text)
  AND ((uid()):: text = split_part(name, '.':: text, 1))
  AND (((metadata ->> 'size':: text)):: integer <= 200000)
)

This is my attempt, but it does not work. This on the other hand does work:

sql
(
  (bucket_id = 'avatars':: text)
  AND ((uid()):: text = split_part(name, '.':: text, 1))
)

Is metadata not present, when inserting or updating an image? When I use the SQL console this query returns the correct objects, when uploading the files through the supabase web ui.

sql
SELECT * FROM storage.objects WHERE (((metadata ->> 'size':: text)):: integer <= 200000)

hey how can i return multiple rows with a rpc call to a postgres function?

do i have to wrap it to give me json data back like this? https://www.jeffreyknox.dev/blog/postgresql-functions-in-supabase/

Is there a way to implement 2FA for email/password login users?

2FA with email password

does supabase have alerting based on metrics available? i.e. if my db CPU usage goes above 90% send me an email

does supabase automatically check if session expires?

or refresh

I have 2 tables 'user_public' and 'user_uploaded_contents'. Both have user_id column referencing user.id. How does the query looks like to join those 2 using supabase js? I've tried multiple ways but keep having 'could not find a relationship...'

yes it does and it automatically grants new session token if you use the supabase js