?

Well, if you skip using the supabase lib then you get to manage user tokens yourself 😉 You'll need to get authentication_token (or something like that) from the successful login response, and use that with all your other API calls. But: that token has a short TTL, so you'll also want to store the refresh_token somewhere too (those are single use, you get a new one on each refresh).

Hmmmm

that means I should just use the lib 😂

how do I get the authentication_token from the successful login response (it is not listed as part of the response) Please don't be angry about my questions. I love what SupaBase is about, I just want to work with it differently sometimes

Thank you for your assistance so far

I'm not angry by any stretch, but I am busy. Maybe someone else will have an idea, or you can look through gotrue-js code

Thank you

please where is the code? I just joined the discord server

Is there an example of a somewhat complex RLS policy? I'm trying to reference a foreign key in it and seeing an example would be great

Is there any option to get supabase tables schema?

Hi! I seem to be unable to create and edit custom schemas in Supabase Studio. Does anybody have an idea on how to fix this?

Hello, what I am reading in the docs is that supabase uses JWT for auth, correct?

Is there a way to use session cookies ?

Should I be committing the

supabase/migrations

directory to version control?

I am not an expert here, but as far as I know there is a way, albeit not as easy as JWT. You basically need to call supabase.auth.api.setAuthCookie() and supabase.auth.api.getUserByCookie() on your server side

Ah okay I will take a look

Any postgres experts here? How can I convert geolocation to readable text in this function? Postgis provides

ST_AsText

but not sure how to use it

sql
create or replace function public.nearby_deals(longitude float, latitude float, radius int)
returns table(id int, title text, description text, dealer uuid, geolocation geography(point))
as $body$
  select
    deals.id,
    deals.title,
    deals.description,
    deals.dealer,
    deals.geolocation,
    deals.location
  from deals
  where ST_DWithin(deals.geolocation, ST_SetSRID(ST_MakePoint(longitude, latitude),4326), radius)
$body$
language sql;

Did anyone create cron jobs? I want to create cron job which alerts users by sending email in certain time

What should one know if one wants to do open-source contribution in Supabase? Is there any video tutorial showing how to set up the project for that purpose?

Is there a way to get a user's email from the javascript client library using their ID?

do you mean for any user, or for the current user?

for current user you can look in supabase.auth.currentUser

Hey guys - is it possible to create a table where the rows would auto expire/delete after X days?

For any user

You'd need a custom view or function to expose that data. It's in a table in the "auth" schema, but I can't remember how it's called.

I'd make a policy that filters data by timestamp, and a separate periodic task that removes old data

Thank you! i'll look into implementing this