Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

The status page has not been updated, I am  facing this on all projects,  (eu region)

support told me to use "tableplus" to connect to db so you can look into that <@!921303773962440704> but then i still cannot query any relational data so im gonna need to wait for fix regardless

Interesting, I am curious, do you frequently encounter issues with supabase?

I see, I am going to hold off migrating serious projects until next year maybe. I dont wanna be a victim of meme culture 😆

live video of me playing a horror game
https://vm.tiktok.com/ZSeP4RRaN/

Does anyone know why I am getting this error `Error downloading image:  Cannot read properties of undefined (reading 'from')` when doing supabase.storage.from("something"). It sayas that .storage is not there is supabase

ahh, the supabase version was not updated.

Hey guys,
New in here.

I would like to know if  supabase  provide single sign-on authentication

Supabase stores token in local storage but you can very easily refresh token

hey folks, I'm new to supabase and trying to figure out if it's right for me. So far, it looks amazing. I _think_ my only remaining question is quite simple: does supabase auth provide a way for me to generate access tokens for my users to hit my API?

If you use the access_token, it's not likely to last long enough, as the developer would have to re-auth frequently.

I run a developer API. Supabase handles user/developer accounts as well as the data, and I use a GQL server in front to handle requests for that data. A developer generates an API key (via a Postgres function), and then they send this key along with all requests to the API.

The GQL server:
 - Checks that the key exists and belongs to a user
 - Stores details of the request, which can be used for analytics but also allows calculation of how many API calls they've used in the current billing period

If the key is invalid or they've exceeded their API call quota, an error is returned.

Developers can have multiple keys, and this provides a way for them to perform analytics but also to revoke a key should they need to.

can I ask what your postgres keygen function looks like?

and can I ask, do you expire these keys? Or only disable them once revoked

because I could imagine just punching out my own JWTs which encode the associated user_id

There's a few different ways to do it.

There's a ULID option, which uses the pgcrypto library (already included with Supabase extensions): https://gist.github.com/kohenkatz/363eac0f4cef0da6c6d1690b96c4ab02

Using a JWT would also work, and the PGJWT extension is already installed on Supabase. I'm not sure how you'd be able to effectively revoke such a token though.

Even just generating a UUID might be enough and that's a really simple option to implement.

As long as it's unique and has enough entropy to be resistant to collisions, and you have some way of linking a key to a specific user, there's probably hundreds of different ways which would work.

i.e., new user in my supabase -> generate an access token for them and give it to them -> they use that access token when querying my API

I get the access_token after a user logs in, and I store that in a cookie. I can use that cookie to determine if they have access to my api or not.

Hmm but is that an appropriate thing to hand out to them explicitly? What's the refresh interval on that token?

I suppose it's probably fine to hand out as long as I suggest they keep it private. I'm thinking for like making `curl` requests (My API is a developer API)

If there is many to many relationship between 2 tables then can I use upsert in such scenario? Books table and author table. Single book can map to multiple authors and single author can map to multiple books. In such case if I want to change some meta data depending on book id and author id then is it possible?

Should I use .upsert().match() and inside match query based on book id and author id

Quick q, how do I get signedURL for multiple files

has anyone tried to implement push notification while using supabase as backend for an app? what platform did u use?

Is there a way to integrate a mail client API like Postmark with Supabase API? Something which is referenced here https://github.com/supabase/gotrue/pull/133

Yup, since supabase doesn’t care how you manipulate the DOM. You can use vanilla JS, jquery, or one of the many modern frameworks.

supabase dashboard having issues? i can't log in

This should be resolved now, please try again and report back here if you are still having issues.

same here, did you re-authenticate with github? i had to and the app name was supabase (prod-gotrue)

This is fine, I have spoken with the team and it's definitely the correct Supabase.