is it possible to filter on result from join? for example

let { data} = await supabase
        .from('points')
        .select('*,  quizzes(type)')
        .filter('quizzes.type', 'eq', `someth`)

Getting net::ERR_CONNECTION_TIMED_OUT on all GET requests today. Any ideas? My app (non-public) is hosted w/o it.

Does the supabase auth settings get saved outside of the tables? Recently ran a migration to a new db and the only thing I noticed I have to manually change was the auth settings for the project

Are Supabase Auth settings store outside of your database?

hello...still amateur with supabase ... does anyone know how to filter dates within an array of objects? I want to show entries that are after the current date (new Date()) and hide any dates that are before the current date. Is it possible with this object or do I need to save the data another way?

Ohh i thought it wud be part of body

Ohh okay i will look into it!

I've made a table called

team_members

and added a foreign key called

userID

which relates to

auth.users.id

but if I run

select userID from team_members

I get

column "userid" does not exist

... Please someone tell me what an idiot I am and what I'm doing wrong

if you need to reference a column that has uppercase, try it with quotes:

select "userID" from ...

that said, it's a good idea to only have column names lowercase + separated by an underscore, much like your table name

team_members

Thank you so much!

I need help! How to get supabase stickers/merch ?

How does one query the private auth.users table via the server-side js sdk? Is it not possible? because I seem to get null. You can run queries via the shell though. Don't plan on modifying any data, just read. Is there a policy blocking access?

^Also would be nice to have a method on the server sdk to get user data from auth.users by providing the user ID, kinda like the firebase admin sdk

push

Is it possible to delete a whole folder from storage per http?

How to get merch

Hello! When a user request a password reset, i want them to be redirected to

mysite.dev/recovery

. The option SITE URL that is on the supabase options doesn't seem to work All the email links have the

redirectTo=http://localhost:3000/

Why is that?

1. How to do a

select created_at as "created"

2. How to do a union with supabase js client

question about using supabase auth with vercel preview urls... seems like there's no way to set the auth redirect url dynamically? e.g. auth0 lets you set a "fuzzy" redirect url,

my-app-*.vercell.app

, so that branch deployments with unique urls can all share a configuration.... but "Additional Redirect URLs" can only support exact matches. Am I missing something here?

relatedly, this discussion question on github seems to not be entirely correct: https://github.com/supabase/supabase/discussions/2760

I'm not sure what language/framework you are using, but I overcame this in SvelteKit by dynamically creating the url on the client side.

ts
<script lang="ts">
  import { dev } from '$app/env';
  import { page } from '$app/stores';
  import { supabase } from '$src/utils/supabase';

  let email: string;
  const prefix: string = dev ? 'http://' : 'https://';
  const redirectUrl: string = `${prefix}${$page.host}`;

  const handleSubmit = async () => {
    await auth.signIn(
      { email },
      { redirectTo: redirectUrl }
    );
  };
</script>

I did a small write-up: https://www.stibbard.io/learning/dynamic-auth-redirect-sveltekit-supabase

Does anyone here use supabase storage but run your uploaded images via a third-party service to convert/compress them first? E.g. user uploads a .PNG and you convert to .WebP and then upload the .WebP to supabase storage?

Does creating views have any impact on foreign key relationships between tables? Some of my select queries only run if I delete one of my views. I'm getting a "more than one relationship was found" error if I keep it Edit: Ohh I see that having views creates ambiguity but I'm still a bit confused on why creating views causes that? Like what is happening under the hood when you create a view that would cause this?

Hey, I was wondering if there is any documentation on how RPC() works with row level security? I was trying to find docs for regular postgres as well, but couldn't find anything very clear

it should work in the same way? the tables referenced in the RPC query would have RLS applied, assuming the function is not

SECURITY DEFINER

+ created by a role that bypasses RLS

@User thanks, just read the postgres function docs and saw that. might be nice to add a comment to the docs for rpc()

Has anyone gotten this error when inserting? This just started today > Error: server certificate verification failed. CAfile: /etc/ssl/certs/ca-certificates.crt CRLfile: none

It's happening when I try to trigger a function

begin
  perform extensions.http_get('https://webhook.site/f0726ed2-a438-4536-a539-1f7a23b809ba');
  return new;
end;

you might want to look at a 3rd party service like Imgix, Cloudinary or Cloudflare's new image service. tl;dr -you host all your own images and then Imgix/Cloudindary proxies to them, doing streaming transforms on the fly. All transforms are handled with query strings. Next.js has a similar Image component that will also do ad hoc transforms but you have to host it on Vercel. hope that helps.

I am getting exact that problem today. Same code worked yesterday