👋

Hows it going

I've seen that, can you help me understand how can I further add different validation checks and report back a custom error depending which vaidation failed.

I have a question, is there any way to set a custom Domain to the user and a custom Email client with the non-self hosted version of Supabase? This isn't really an issue for me right now trying it out (and it's been awesome so far) but for consistency purposes, it would be nice If we can use our own email client and domain even if it just proxies to the generated URL. Unfortunately I cant just stick a CNAME over it because something something cloudflare.

Example: One end point is to create customer /customer Now I want to validate before customer creation that the zipcode enterered must match the City name. ( Gives out error Zipcode and city mismatch) Or if the city name has non english characters (Gives out error Invalid characters in "city" or "state" or "country")

Hello 👏

I want to be able to filter by people based on a bunch of booleans. My query in english is something like:

I'm wondering how I should store all of those fields. I've got a column for role and country, but the rest I'm not sure about. Should I have a new field for each of those (wp / rails / django / node / etc — there would only be 10-15 max), or Should I store that in a jsonb column instead?

I'm guessing the jsonb query will be much slower than if everything was in its own column, but I wonder would it be noticeably slow for a small dataset (1000 records or so)

This is my current reference point, but wanted to do a quick double check 🙂

I have a

users_pages

many-to-many table. The users in this table are stored by

user_id

foreign key. I'm trying to display all of the

email addresses

, for every user that belongs to a given

page

. So I need to find all of the `user_id`s for a requested page — and then pull the

email addresses

associated with each of those `user_id`s. Something like this:

javascript
        const { data, error } = await supabase
        .from('users_pages')
        .select(`*, users(email)`)
        .eq('page_id', PAGE_ID)

What query should go into

.select()

, in order to return the

email addresses

from

users

table?

visual API builder

many-to-many

Is it ok if I store JWT secret provided on supabase dashboard in backend services written in Nodejs, Java or Golang?? I want to let know that current user logged in on backend services

I also want to use bull queue which uses redis is it possible to connect it with supabase? https://github.com/OptimalBits/bull

hi guys

In the recover password, receveid a message "Send password recovery failed: Error recovering user"

Recovery password

Is there any plans for additional pricing tiers?

Is it accurate that there's no way to query

auth.users

? As such, is it recommended to create a

public.users

table? Context: Trying to fetch a user's email from a

user_id

foreign key, can't query

auth.users

?

Beautiful, thank you so much @User!

You don't need a new table, you can fetch the data with a view in the public schema, for example: CREATE VIEW public.get_user_email AS SELECT u.email FROM auth.users AS u WHERE auth.uid() = u.id;

FYI that created an empty view for me. But I suppose it makes sense to create a public.users or public.profiles table in any case, given that more information could eventually be added beyond email address

What do you mean empty? NOTE, the WHERE clause at the end - if auth.id() is empty (which would be the case if you are testing the view through the Dashboard editor), then you would get no rows. You can replace this where clause with whatever you want, but you need to ensure rows are properly secured

And yes, you can also create another users table if you need to add more data - it's a matter of design

Got it, thank you again for the insight and help!!

Hello

How can you reload the schema cache in the Supabase UI? (https://postgrest.org/en/latest/schema_cache.html)