Can I get sudo access to your servers?

It happens quite often to me that I add a table, press save and some error occurs - any chance to save the progress? 😱

I also feel like an idiot because I'm too lazy to write the SQL code instead (which would be more robust) - but if there is a UI, why not use it

is there anyone who has connected front end of Directus CMS (https://directus.io/) to Supabase database? How did you incoporate the API key as header to each request that Directus makes to the database?

Does anyone have an idea?

Getting these kind of errors after importing anything from supabase:

node_modules/@supabase/gotrue-js/dist/main/GoTrueClient.d.ts:169:16 - error TS2304: Cannot find name 'ApiError'.
    
    169         error: ApiError | null;
                       ~~~~~~~~

I have many supabase projects; its a first for me 🙂

Okay

I fixed it by upgradiing angular cli and core from 9 to 13 ;p

Directus with Supabase database (Postgres)

worked! 🦾

For RLS policies with joins, the docs recommend:

create policy "Team members can update team details if they belong to the team."
  on teams
  for update using (
    auth.uid() in (
      select user_id from members
      where team_id = id
    )
  );

How does this compare performance wise to:

create policy "Team members can update team details if they belong to the team."
  on teams
  for update using (
    id in (
      select team_id from members
      where user_id = auth.uid()
    )
  );

Also what's the best way to profile queries with RLS enabled on Supabase?

Hey guys i have a weird issue, when i do that in backend

const { data, error } = await supabase.auth.api.createUser({
      email: 'xxxxxxx@gmail.com',
      password: 'xxxxxxxxx',
      data: {
        first_name: 'Martin',
        last_name: 'Donadieu',
        job: 'test job',
        role: 'doctor',
      },

    })
    console.log(data)

the log is egal to this :

{
  id: 'b78b7f9c-0bb9-4ba5-9763-bb92c09d5fe2',
  aud: 'authenticated',
  role: 'authenticated',
  email: 'xxxxxxx@gmail.com',
  phone: '',
  app_metadata: { provider: 'email', providers: [ 'email' ] },
  user_metadata: {},
  identities: null,
  created_at: '2021-12-10T03:53:38.81179Z',
  updated_at: '2021-12-10T03:53:38.813587Z'
}

None of my data are saved, did you already got this bug ?

Oops, just saw this. Ultimately, a very helpful Supabase engineer had to roll my databases back to an earlier build—turns out I was hitting an edge case in the new system. But, for the historical record, nope, I wasn't getting any error messages at all when I hit these bugs—just subscriptions that never actually received any updates.

Hey guys, I'm trying to filter with inner joins using

!inner()

and using exactly the same code in docs. But it takes forever to load and gives

"error":"FetchError: invalid json response body

reason: Unexpected token < in JSON at position 0

. PS: Relation is many-to-many. So there is another table called "posts_tags" which includes ids of posts and tags. The Code

const { data, error } = await supabase
  .from(‘posts’)
  .select('*, tags!inner(*)')
  .eq(‘tags.name’, ‘tag-name’)

Edit2: I added

.range(0,0)

so it will return the first row it finds. It works even with name but still incredibly slow. When I make

.range(0,1)

it takes forever again and gives to error above. Verdict:

!inner()

is painfully slow. Is there any way to query through M2M tables?

Hey, when doing this for 1 to 1 relation:

select(
  name,
  survey (
    title
  )
)

survey is returned as array. How to return it as a single element?

https://supabase.com/docs/reference/javascript/single https://supabase.com/docs/reference/javascript/maybesingle

hi guys! does anyone know if I can filter based on 2 conditions in real time subscriptions? e.g. I wanna do:

const votes = supabase
      .from(`votes:user_id=eq.${userId}&date_id=eq.${dateId}`)
      .on("DELETE", (payload) => {
        setHasVoted(false)
      })

using an

&

doesn't work, not sure if this is possible and what the syntax would be

hello people; am i missing something? trying to create a function hook following an egghead tutorial; everytime i click on add http parameter it show object object as in the printed screen =[ liking it so far, looks like a bug to me but thought i'd ask anyway; i`m on a mac m1, tried safari and chrome the console log is on the print as well, it's empty

@User i am working on the PR for the light themed project api docs. i am already using tailwind classes. the background for the docs page is a

linear-gradient

and i can't seem to implement a tailwind class inside

tailwind.config.js

that would set the gradient as a

background

rather than

background-color

. is there any way to do that?

white: 'linear-gradient(90deg, #ffffff 50%, #eeeeee 50%)',
black: 'linear-gradient(90deg, #1f1f1f 50%, #2a2a2a 50%)',

i'll DM you, save spamming the channel

Discord server issue? Every time I restart my Discord, I've lost the server shortcut in the left bar, and I have to get back in through the invite link. Is that something on my end, or is this a server default/feature? Can I change that somehow such that I can remain logged-in on the Supabase Discord server?

Hey there, I just wanted to ask about GraphQL And Flutter. I saw you released the PG-Graphql. However, I wanted to ask if this also helps with handling Authentication for GraphQL?

My use-case is that I hope to use GraphQL on Flutter Mobile App as it is, and that I can also handle Authentication with GraphQL as well too. Is that possible?

https://news.ycombinator.com/item?id=29430720 Here they are talking about Authentication as well too, but can I hook on the extension to also possibly create / delete / authorize users to my resources?

Hey guys, I got 2 projects running the exact same code on 2 different db, realtime updates are only working on one of them. I can see the websocket is connected, receives heartbeat on both project, but on the 2nd one I don't receive any payload. Both db are configured exactly the same (same RLS, users, etc).

I don't know where to look anymore to get this realtime working again.... Should I dump and recreate a new db ?

I already check Replication in Database section, supabase_realtime is checked for all, and source is good

In the non-working project the websocket's payload is empty when joining. in the working one there is the user_token inside the payload.