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

Supabase

Hey there 👋  I'm trying to add OAuth to a Supabase app, I'd like to handle the login on the server-side, the issue is that Supabase is sending the callback with `#` instead of query params, any idea how to approach it?

**Example**: `http://localhost:3000/login#access_token=ooo&expires_in=3600&provider_token=ooo&refresh_token=ooo&token_type=bearer`

You need to forward the hash fragment to wherever you need it, there's no way to turn it into query params.

do you know the reason behind sending hash instead of query params? arent query params easier to work with? maybe it could be a possible change to make the dev experience easier

u can just declare winow as a const and then use window.location.href.split('#').pop()

Thanks, i will try to get it on the client side and send it to the server, not optimal at all.
I really don't understand why using hash and not query params

is it possible to set up cascading deletes from the supabase table editor UI?

how is it possible that altering the foreign key on a table would delete the data in my table.

Hey, I have a Supabase table that contains an array of strings.

I'm using supabase python. What's the best way to append/delete content from that array?

I don't want to pull the array then modify it then push the updated array once again. Can we do this without pulling the whole array?

In my opinion If this is your requirement you should just create a new table with a 1 to many relationship that way you will be able to quickly concatenate the values to become a array at runtime and it will be quick to update / modify the array by deleting rows of the new table.

That said are you after `array_append` as per https://www.postgresql.org/docs/14/functions-array.html

You can create a `rpc` and use these functions. 

Though I'm quite sure postgres is going to rewrite the whole field when you update using these functions and this is why a rethink of schema as per my first point is preferred.

```supabase.table('users').insert({"dao":str(member.guild.id),"username":str(member.name),"user_id":str(member.id)}).execute()
                         print(data3)```
 this is the insert qery
```({'message': 'column users.uid does not exist', 'code': '42703', 'hint': 'Perhaps you meant to reference the column "users.id".', 'details': None}, None)```
this is response, weird thing is im calling user_id not uid idk why its refrencing that

Also, what is the type of the user_id column?

might be related to this https://discord.com/channels/839993398554656828/843999948717555735/927089073439518720

also the users table has a column dao that has foreign key to daos.uid

manually adding data thru the dashboard works

Hmm that's interesting. Thinking about how best to replicate this on my end

Sure, could you give me 10 minutes though? Trying to finish up parts of a django  library

ohk but probably wont be able to reply much

u cn copy the code into another file and try it

Do you have any RLS or triggers on the users table?

Maybe there's more details in the database logs? It looks like something is mixing up your public.users table with the predefined auth.users

Hmm yeah do you  mind pasting the relevant section of the database logs, or the stacktrace of the error?

i cn but i cudnt figure out what part of the logs to look at cud u give me a query?

sorry, I'm not too sure about this one. Might not be a python lib issue per se  <@!380265309753311233>  <@!769558295559012372> <@!271586885346918400> wondering if y'all have any thoughts on this?

Might it be because there is a users table in the auth schema?

Tagging someone from JS land too to see if they have any thoughts: <@!107176742342402048>

So when we construct a query we update `session.params` to include filters and the such

But when we `.execute` them, we don't clear the old params out

So in the next query, the params from the previous query are also sent

```py
In [12]: client.from_("test").select("*").execute()
Out[12]:
([{'id': 7,
   'created_at': '2021-10-02T16:20:51+00:00',
   'names': 'Abcdef',
   'roll_numbers': '10115'}, ...
```
```py
In [14]: client.from_("test").select("*").eq("non-existing-col", "1").execute()  # errors out as expected
Out[14]:
({'message': 'column test.non-existing-col does not exist',
  'code': '42703',
  'hint': None,
  'details': None},
 None)
In [15]: client.from_("test").select("*").eq("id", "1").execute() # SHOULDN'T error, but...
Out[15]:
({'message': 'column test.non-existing-col does not exist',
  'code': '42703',
  'hint': None,
  'details': None},
 None)
```

Auth.users schema, it's a bit hard to read

I know because I noticed the same bug in my fork 😛

https://anand2312.tech/img/uploads/firefox_AkmPmFJjHk.png have to dig through the API logs to catch it

It's normal there are bugs, since we are in a public alpha status

We'll work on it and publish a version w the solution since it's an important bug

Any tentative date on when the fix can be published?

Hmm I can look into a fix about 25 hours from now but maybe the team might be able to get to it sooner if they're free

Yeah sorry about the bugs, we're still in alpha unfortunately 😅 and thank you for taking the time to report your issues! It will go a long way towards improving the eventual user experience

I think it’s best if I write the whole script again in js

if you need it urgently, I would recommend you do it

https://github.com/supabase-community/postgrest-py/issues/54

<@769558295559012372> you’re a rock star man  🚀

<@!387948445283123211> is the previous bug of match func fixed, cos for this ill hv to update to latest version

yep match is available in v0.1.1, are you still facing issues with the `match` command?

no i was asking so i can decide whether to update

Does any one know if there is a way to get who uploaded a specific file in a given bucket?

is it a problem if some queries using the supabase client you used '' and some you used ""

It shouldn't be a problem - string is a string, the client will serialise your query into a PostgREST call anyway. But you can paste an example where you think "" vs '' might make a difference.

u cn check the thread i made <#926838372411015209>

Hmmm, I'm thinking if only auth had another couple of methods to support sign-up emails containing a conf code instead of a link:

auth.confirmSignUpConfCode(email, confCode)
where confCode is a 6-8 char conf code

auth.resendSignUpConfCode(email)


(plus obviously the server changes too)

I setuped twitter auth in my app and I get back these things

How to get the bearer token from this? so I can call twitter API on behalf of the user

I need help getting started with local development for studio. more info in the discussion https://github.com/supabase/supabase/discussions/4698

Is supabase (including all its containers) running locally on your machine?

not really sure by what you mean including all its containers, but I would assume that you are talking about docker. I don't have any docker containers running, just localhost.

did you follow the "Running within a self-hosted environment" guide in the studio readme?
https://github.com/supabase/supabase/tree/master/studio#running-within-a-self-hosted-environment

also, https://supabase.com/docs/guides/hosting/docker

Hello, I'm new to supabase, i have installed `studio` and with `npm run dev`  it opens the next.js dev server but in order to make it fully function I followed the guide above,
with that `docker-compose -f docker-compose.yml -f ./dev/docker-compose.dev.yml up` does run the apps locally but if I update anything in studio app, it's doesn't reflect on docker logs when i restart it.
Can anyone please help me to understand what's the actual flow/process to develop supabase locally.?

continued here https://discord.com/channels/839993398554656828/1004321585508917278/1004322324251680819

access_token looks like a jwt, so it should be that

isn't that the provider_token? It should be useable  short after getting it. There will be problems with refreshing it, there's an issue about the somewhere in the supabase GH.

access_token is a JWT, but it's only good for Supabase APIs - not for the auth provider.

Hi guys. Been trying Supabase lately since yest and it's cool so far.
I'm kinda stuck with an issue.

So I'm trying querying a table which has zero rows and trying to check if a record with an ud exists or not. The query is returning data which is neither null nor undefined or an empty array. What does a select query return in Supabase js if it finds no relevant rows. 
I tried searching the docs but couldn't find much about this.

a query that matches no rows should return an empty array as data, plus some metadata

can you show the query and the whole result object? That should help with debugging.

(also, which programming language are you using?)

I am using Javascript.
Actually I'm running it in Cloud functions and am unable to debug with breakpoints due to some reason. 
Query is
const {data} = Supabase.from('tableName')
.select()
.EQ(aomething)
.Limit(1)

Console.log(data)

Something like this

On printing it's neither null nor undefined or an empty array as expected. What am I missing?
I am pretty clueless as what is in data coming in.

Ok
I checked now and it's working fine.
I am unsure how the same code didn't work previously.
Though I recall I did a change on my table prev where my primary key was set to int but I was inserting string primary keys. So I changed it to varchar. May be for this reason my records were not inserting. Btw, after the above code I do a check if any matches returned and do an insert accordingly.

When I run pg_dump in the Supabase dashboard SQL editor, I get a syntax error. Is this the appropriate place to run the command?

Can someone guide me to resources where I can learn how to return data by joining tables?
The official docs barely speak much.