Do I have the info needed after a user signs in with Twitter to make requests on their behalf?

I'm inserting a row into my threads table and I want to only include a reference to the categories table if the user selects a category. I'd like to be able to just insert as usual (

{category_id: category}

and if category is null, the column stays null. The issue is I get an error stating that it cannot be inserted as a uuid. Thoughts?

Hi! I was wondering if it's possible to send the user credentials from my React client to my Nestjs API, in order to define the user right to make some actions (send an already authenticated users data to authenticate it in the backend before any action) My idea was to use the React Supabase client to auth users and then send the credentials to the API when the actions needs to be handled server side. I don't know if I'm planning this the proper way. Thanks in advance!

I do this on Nuxt 3

Hi Guys, I am trying setting the user using the refresh_token obtained by callback to my VSCode extension on the url fragment: This is my code:

js
// credentials object is an object containing the access_token, refresh_token created from the URL Fragment

// trying do a signIn
const data = await supabaseClient.auth.signIn({
            refreshToken: credentials.refresh_token,
})

I am doing it according to this example on React Native but in VSCode: https://supabase.com/docs/reference/javascript/auth-signin#sign-in-using-a-refresh-token-eg-in-react-native But, I did receive the

Request Failed

message on the

data

object:

json
{
    "user": null,
    "session": null,
    "error": {
        "message": "Request Failed"
    }
}

BTW I am using the

supabase-js

client V1.

In order to be compliant, we need to keep track of when a user accepts our T&C and what version of those T&C. The tricky thing is: it needs to be in a format that is non-editable. Any recommendation on how to make a table where the values are non-editable? Ideally the table could have a non-editable createdAt that is set in the creation of a new row and not by us manually

Im using

supabase-js

library and I wanna listen to every events on every table

js

const socket = new RealtimeClient(process.env.REALTIME_URL, {
    params: {
        apikey: process.env.REALTIME_API_KEY
    }
})

socket.connect()

const PTListener = socket.channel('realtime:public:*')


// BUG only DELETE works
PTListener.on('INSERT', (change) => {
    console.log('INSERT on PTListener', change)
})
PTListener.on('UPDATE', (change) => {
    console.log('UPDATE on PTListener', change)
})
PTListener.on('DELETE', (change) => {
    console.log('DELETE on PTListener', change)
})

but only only trigger on

DELETE

, but not on

INSERT

or

UPDATE

.

I am trying to get the

refresh_token

from an already logged user using

supabaseClient.auth.session()

when load the page but doesn't return that value. This is the code

js
import { supabaseClient } from '@supabase/supabase-auth-helpers/nextjs';
import { useUser } from '@supabase/supabase-auth-helpers/react';

const Onboarding = () => {
  const { user } = useUser();
...
  useEffect(() => {
    if (user) {
      console.log('session: ', supabaseClient.auth.session());
...
}

The value displayed is:

json
{
    "access_token": "user.jwt.tokenxxxx",
    "token_type": "bearer",
    "user": null
}

Why I can't access the refresh token?

I just created a self hosted version of supabase.

const { data: record, error } = await supabase .from('Blog') .insert({title: 'hi'}).single(); if (error) { console.log(error); } console.log(record); // undefined?

How would I get the current date as default value when using the date type inside supabase?

Hey guys, it is possible to copy paste normal JSON like:

[
    {
        "name": "Hero",
        "fields": {
            "btn_left": {
                "text": "Get started",
                "link": "/"
            },
            "btn_right": {
                "text": "Learn more",
                "link": "/"
            }
        }
    },
]

Into a json supabase column via the supabase gui? Thanks for reply guys ❤️

I have 2 tables users and user_roles my users table contains auth.uid() and nickname and my user_roles table contains user_id and a rolename (admin for example) now I want to query all users with role admin in my svelte app. How would I do that? Thanks in advance!

My goal is to filter the query results to only get posts (think any social media) with a specific tag. The tag is getting send as a search param in the url, and I can filter properly when there is a search param to filter, but I want to ignore the filter if it's null. Essentially, how can I void the

.eq("tag", null)

when the match case is null, that way I get all posts instead of none.

Hi all, I'm trying to use an UUID string as a parameter to upload it in supabase. The error I'm getting is the following:

{
  code: '22P02',
  details: null,
  hint: null,
  message: 'invalid input syntax for type bigint: ""'
}

Hi. I am using the service_role secret as the API key for the graphql setup. However, for tables with RLS protection I do not get any data back. If I turn RLS off the data is there. What do I need to do in order to make my admin key have full permission?

begin
  insert into public.profiles(id, username)
  values(new.id, new.user_metadata.username);

  return new;
end;

This doesn't work. It says that user_metadata doesn't exist in new. On signUp, I send data: { username }

I'm trying to follow the instructions on this github readme https://github.com/supabase-community/heroku-to-supabase But when I run the pg_dump I'm getting the following error:

bash
pg_dump: error: connection to server at "ec2-54-224-120-186.compute-1.amazonaws.com" (54.224.120.186), port 5432 failed: SSL error: certificate verify failed
connection to server at "ec2-54-224-120-186.compute-1.amazonaws.com" (54.224.120.186), port 5432 failed: FATAL:  no pg_hba.conf entry for host "152.171.245.125", user "myuser", database "mydb", SSL off

I'm wondering how to force SSL and how to get the cert for that matter, I don't know where on heroku that's supposed to be, thank you so much

Hi, I just upgraded to latest

rc

of Supabase to use the new auth component, unfortunately, now I get the error attached in the image. I am not doing anything complicated, my

supabaseClient.ts

looks like this (ignore the keys I have them correctly being passed):

import { createClient } from '@supabase/supabase-js';

// Create a single supabase client for interacting with your database
export const supabase = createClient(
  'https://xyzcompany.supabase.co',
  'public-anon-key',
);

Login.tsx looks like this:

import { supabase } from '@/utils/supabaseClient';
import { Auth, ThemeSupa } from '@supabase/auth-ui-react';
import React, { useState } from 'react';

const Login = () => <Auth supabaseClient={supabase} />;
export default Login;

This is on version 12.2.2 of NextJS - any ideas? I haven't messed around in the web world for a long time so I am guessing it might be something in my tsconfig that I am missing blindly.

I've structured my insert RLS policy to what I think would work based on the docs and my tables:

sql
(has_course(( SELECT course_id
   FROM thread
  WHERE (thread_id = id)), uid()) AND (user_id = uid()))

However when I save and try it, I get an RLS error. Then when I go into the policy editor, it changes to:

sql
(has_course(( SELECT thread.course_id
   FROM thread
  WHERE (reply.thread_id = thread.id)), uid()) AND (user_id = uid()))

Which might just be a more explicit version that Supabase automatically updates to? Either way, I can't seem to get this policy working right.

Hi. Like the title says I am trying to insert a record and get that record back in the data property of the response so that I can read the newly created id. But it is returning undefined. I'm using @supabase/supabase-js: v2.0.0-rc.6 with the service role key. sorry if this is basic, I tried the docs already with no luck.

1. While making changes it says failed to update settings. I am using Supabase auth here

Hello, how can I integrate images in the email template? url ? Thanks!

Is Supabase compliant to GDPR? I didn't find anything about it on privacy-terms.

I am following the Public Access example in the docs to allow "User can update own profile" (https://supabase.com/docs/guides/auth/managing-user-data) I am getting access denied for the policy:

create policy "Users can update own profile."
  on profiles for update
  using ( auth.uid() = id );

using this update statement with the supabase js client:

const { data, error } = await supabase
  .from('profiles')
  .update({
    ...formValues,
  })
  .match({ id: user?.id });

any idea why? This is on a nextjs page where the user is authenticated

Hello! I am using playwright in my app but I need to fetch some protected data by RLS. So my question is how do I authenticate playwright with my supabase user?

Here is the query I'm doing so far:

ts
const { data, error } = await supabase
    .from(health_facilities)
    .select('*, health_facility_categories!inner(*)')
    .eq('health_facility_categories.name', 'clinic')

Now, in my health_facilities table I have a city_id column with a foreign key to the cities table. How can I replace the city_id with the cities.name in my result?

We are considering to use supabase for one our clients next project. Because of regulations we need the server to be located in germany or at least within europe and we are wondering, if there is any possibility within the cloud version to choose where the servers are located or are we forced to use the self hosted version?

Hello, I'm trying to insert an array of objects into a supabsae column. It's an array of these kinds of objects, and it's only strings. { id: response.data.public_id, url: response.data.secure_url } The funny thing is that in supabase I get a lot of \ etc instead of spaces. How Can I deal with this? This is how it looks in supabase:

[
  "{\"id\":\"hostpictureupload/hjpxjha1tyysgnwi9w9z\",\"url\":\"https://res.cloudinary.com/duj052tmt/image/upload/v1661512384/hostpictureupload/hjpxjha1tyysgnwi9w9z.jpg\"}",
  "{\"id\":\"hostpictureupload/irrxsmu6ri6u9k0ibcgp\",\"url\":\"https://res.cloudinary.com/duj052tmt/image/upload/v1661512384/hostpictureupload/irrxsmu6ri6u9k0ibcgp.jpg\"}",
  "{\"id\":\"hostpictureupload/uzk1fmgoygeq3m2qxjlh\",\"url\":\"https://res.cloudinary.com/duj052tmt/image/upload/v1661512384/hostpictureupload/uzk1fmgoygeq3m2qxjlh.jpg\"}"
]

Why are there \ ?

Using Flutter, I have implemented Google and Facebook sign in, is it possible to get the public phone number of the user?