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

Supabase

I guess it' hard to find. Should inherit the design from storage table.

Hi. How do I execute a WHERE NOT IN query?

I only see `in()` from the API reference

Does supabase support different environments ?

I would like to have a development version and a production version of the database. I would make changes to the development version and then merge the changes to production. Does supabase support such a workflow ?

Supabase does not currently support this kind of multi-environment solution just yet. However, it's in the works and will soon be avilable for public usage.

<@!231781964305137665> is there a thread somewhere expanding on what that's going to look like?

Has anyone worked with VueJS and Supabase real-time?

If so, how did you handle the subscriptions, did you use Vuex?

here the Fun project using Vue + Supabase Realtiem

https://github.com/zernonia/supabase-realtime-nextconf-clone

Unfortunately, I didnt use  Vuex/Pinia to store active user

But if I were to handle subscriptions with global store, I would utilize  Vue 3 Composition API `reactive` instead of `Vuex`

So even if I use email password auth user still needs to verify the email to login?

You can disable email verification in the dashboard

I think it'll be helpful if the docs specify the return object and its contents.
I'm trying to figure out if the URL of a file is returned after uploading to storage, does any one know this? Or I have to use the getPublicUrl method to get the URL of a just completed file ?

No, it doesn't, but after successful upload, you could use same path to call getPublicUrl.

Hi All, anyone around to help with a db issue? keed geeting time out on db creation.

Hey all, not sure if I am missing somethi8ng, my data is not showing up on the dashboard

Does anyone know how to do a WHERE NOT IN query?

How are you currently running `WHERE IN`?

I use Flutter,

supabase.from(table).select().in('column', arrayValues).execute();

if you do `supabase.from(table).select().not().in('column', arrayValues).execute();`

Does that work?

I tried the other day, 

not('column', 'in', ['value', 'valuedsd'])

Does not work, it just throws an unexpected [ ] charcater instead

That's very strange.

I'm working in JS so this might not be the same, but this example shows that `in` is a valid operator for `.not()`:

```dart
supabase
  .from("table")
  .select()
  .not("column", "", [])
  .execute()
```

Yeah it's pretty weird.

This is the exception I am getting

```
 "failed to parse filter (not.in.[])" (line 1, column 8)
```

Hi <@!761480500916256768> . It dosen't work in Flutter or my query syntax is wrong?

can you create an issue on https://github.com/supabase/postgrest-dart
thanks

i guess we didn't support list value properly for not()

compare not() https://github.com/supabase/postgrest-dart/blob/bf1c91f6848ff3e94c38276b449045052b20d3ca/lib/src/postgrest_filter_builder.dart#L20

and in() https://github.com/supabase/postgrest-dart/blob/bf1c91f6848ff3e94c38276b449045052b20d3ca/lib/src/postgrest_filter_builder.dart#L133

So basically I have to make it a string

(uuid, uuid, uuid)

hahah, yeah in the mean time can you try to escape your list properly before passing to not()

String _cleanFilterArray(List filter) {
    return filter.map((s) => '"$s"').join(',');
  }

Thanks man, regarding the ticket here it is https://github.com/supabase/postgrest-dart/issues/36

If team decides to add a support for List

Otherwise I think it would be good to involve into the README as example of using where not in

Does anyone know the progress with the realtime RLS security issues being fixed so I can use it on they client side 😄
I was hoping to see it in launch week 2, but no luck

Is anyone else facing issues with Storage? Images haven't been loading for about an hour already

<@&844001800214020128> can anyone from the team share your feedback on this?

As far as I understand, older projects will not automatically be migrated to 13.3, but this is something you can do by creating a new project then doing a backup and restore.

We are working on fixing some permissions issues first, then I'll be doing some testing of the procedure and I'll post a script for it.

I've done it myself, but I had to manually elevate my `postgres` user privileges temporarily, then set it back afterwards.

With the team I'll bring up the idea of doing the upgrade from the dashboard -- I'll see how feasible or desirable that might be, and if might have any possible problems.

In the meantime, I don't think there's anything in 13.3 I personally really NEED -- keep in mind 12.x is still working fine (as are all my projects still based on it) 😄

but shouldn't be this done automatically for atleast paid customers?

Not necessarily, as it may cause issues for some people.  Maybe if it's requested?  I wouldn't want a host ever touching my projects unless I specifically needed them to.

Okay, and the user's how they will be migrated?

Yeah users are just a table.  They migrate just fine - no changes there.

if you copy the client_ids and secrets over

but you also need to modify the callback URL in each provider because your database domain has changed with the new project

It says, team is working on migrating old projects.
Just noticed