Exactly 🙂

Is there a way the make edits to existing tables in the web UI? For example I am trying to change the type of a column and I get an error.

Might be an issue with the user for the UI not having rights.

can anyone help on this? 🙏

Today my snippets in SQL Editor are getting randomly rewritten and deleted. I've lost over a month of work. Is it possible to revert somehow snippets in SQL Editor to yesterday's date? Or even revert the whole DB if that'd revert the snippets.

I restored the DB backup from yesterday but the snippets are not restored. I'm desperate now.

Dears, I have a strange issue on user authentication with Angular 13 and Supabase.js client 1.29.4: with email-based authentication, everything works fine. With social authentication (Facebook, Google, and others), when the redirect has finished, the auth.session() method always returns null. Only a full refresh of the page retrieves the current (and valid) session. This behavior happens even in SPA and SSR. Any idea?

No changes from our side (only update Angular to the latest release (13.x) and Supabase.js client to 1.29.x

Maybe I have misunderstood something here. When I authenticate with GitHub as the provider, do I not also get a GitHub token to use in GitHub API calls? Also, all examples are using async/promises, but when I call

auth.signIn({provider: 'github'})

the page gets redirected to GitHub and the promise is lost.

Hello guys 🙂 Someone know how I can udate the version of my remote database on supabase? I got this error:

Error: Remote database Postgres version 130003 is incompatible with dbVersion 140001.

Oh ok I reverted to an old version of my cli and it seems to do the trick while waiting the prod database on supabase to be updated!

Yes it's correct, and you callback to your web app with access_token

But the access_token is only valid for Subabase, not GitHub. Correct?

The returned access_token is valid for Supabase session and it is stored into User (private) table of pgsql (I think)

That does explain a lot. I was trying to use the access_token to call GitHub's API. Thanks for the help. 👍 Now I have some rework to do. 👨‍💻

js
try {
      if (!event.target.files || event.target.files.length == 0) {
        throw 'You must select an image to upload.'
      }

      const user = supabase.auth.user()
      const file = event.target.files[0]
      const fileExt = file.name.split('.').pop()
      const fileName = `a1jg6w_0/${user.id}.${fileExt}`
      const filePath = `${fileName}`

      let { error: uploadError } = await supabase.storage
        .from('profile-pictures')
        .upload(filePath, file)

      console.log('uploading')
      if (uploadError) {
        throw uploadError
      }
      console.log('uploaded')

      let { error: updateError } = await supabase.from('profiles').upsert({
        id: user.id,
        avatar_url: filePath,
      })

      if (updateError) {
        throw updateError
      }

      setProfilePicture(filePath)

    } catch (error) {
      alert(error.message)
    }

this is the code thats running

I'm trying to make a RLS policy where anyone can get rows from a table but only specific information is returned, here's what i have so far but its giving me a syntax error:

sql
CREATE POLICY "Public profiles with minimal data"
ON public.profiles
FOR SELECT USING (
  SELECT id, preferred_name, identity_data - 'email' identity_data, access FROM public.profiles 
);

RLS policy

I tried the nextjs example from https://supabase.com/docs/guides/with-nextjs#intro but all I get when clicking login is

An invalid response was received from the upstream server

&

Kong Error
No API key found in request.

but I have one in my

.env.local

NEXT_PUBLIC_SUPABASE_URL="https://xx.supabase.co"
NEXT_PUBLIC_SUPABASE_ANON_KEY="anonpublic"

From what I read, u have to manually migrate your project from pg13 to pg 14 if u choose to. https://supabase.com/docs/guides/database#migrating-between-projects

Anyone having problems with storage now? I can't access items today 😦

Got it working again, it was unavailable for 30 min or so. All good now.

Anyone tried uploading to storage with a third party authentication platform ? I run into a FK constraint on objects table. error: 'Key is not present in table "users".'. As I am not using Supabase's built in auth, the FK constraint is preventing me from uploading to Storage as a sign in user from a third party auth. E.G Auth0. How can i go about solving this issue ? . I really dont want to modify the Storage schema.

How to return single item from DB using CURL

Hey everyone, this link in the docs is broken: https://supabase.com/docs/blog/2021/03/05/postgres-as-a-cron-server I got to it through search.

Hi guys! How do I join multiple conditions using the sdk.. ie. something like update a row if column a is x AND column b is y?

Is it possible Supabase Storage is down? My bucket doesn't appear and I can't access anything related to it...

I have Nuxt's API auth wired up with supabase's

setAuthCookie

, however, I'm now getting an

Auth session missing!

. I believe that's happening because the session does not exist during SSR—but how could I make the session available? Full context in this thread: https://discord.com/channels/839993398554656828/938468552984363028

seems so, at least intermittently/for some users (see comments above)

update with filter