Hey guys, im trying to use a lib from Expo, which can upload files to a URL in the background, but it only accepts an endpoint using POST. Is there any way i could upload a file to supabase storage via URL and not the supabase client?

When building you DB, do you use the JSONB type or do you simply use Text? Why use JSONB? What is the difference with JSON?

Is there a way to query if authenticated user satisfies the RLS checks without sending any data? As in, a way to first check permissions e.g. for INSERT, and then later send the data when user is ready to do so.

I've made a few PRs. How do I get the contributor role as well as XP for it?

I've been using Supabase as my database, but am now moving auth from Auth0 over to Supabase Auth. It's been going fairly smoothly, however I've now run into a roadblock. I'm using SvelteKit and all Supabase code is server-side. When a user signs in, their access token is stored in a cookie and read in

src/hooks.ts

. The user data is correctly fetched using

supabase.auth.api.getUser(accessToken)

. The issue comes in when I try to query my

profiles

table. I query it by the user's

id

. The

profiles

table

id

column is related to the

auth.users

id

column. Everything properly matches, but the query returns nothing. This is where things start getting strange. I have a

profiles.ts

file with helper functions which is what I use to call to Supabase. If I edit this file, SvelteKit hot reloads and the function then returns data as it should. However, just reloading the page does not make it return properly. As a sanity check I made it return the entire table instead of just the correct user, and it just returns an empty array. I don't think I've ever run into an error quite like this, any help would be much appreciated.

How do I use the

exists

function like

select exists(select 1 from contact where id=12)

in supabase?

I've been trying to get the

pg_graphql

functionality up over the last two days, but for some reason tables are not registering in the gql schema. https://github.com/supabase/supabase/discussions/6262 I've detailed most of my current troubleshooting steps here, but thought it might be worth checking here as well. 1. Fresh project with

pg_graphql

enabled. 2. Table

countries

created via the dashboard on the

public

schema. 3. No

countries

showing in gql schema.

json
{
    "data": {
        "__schema": {
            "queryType": {
                "name": "Query"
            },
            "directives": [],
            "mutationType": null,
            "subscriptionType": null
        }
    },
    "errors": []
}

Is it possible to access the auth.users table publicly? I would like the email and created_at to be public data...

bash
keeplearning@pop-os:~/CodeProjects/test-edge$ supabase functions deploy hello-world
Error: Platform linux/386 is currently unsupported for Functions.

Unable to deploy edge functions.

hey everyone, im practicing authentication at the moment with sveltekit RLS is on one of the issues im having is after i log out, and i sign in with another email, i can see the info from the previous session and when i hard refresh, then i see the correct data. Im not sure how to fix this in my store

export const user = readable(null, (set) => {
    set(supabase.auth.user());
    const unsubscribe = supabase.auth.onAuthStateChange((_, session) => {
        session ? set(session.user) : set(null);
    });
    return () => {
        unsubscribe.data.unsubscribe();
    };
});

hi

using rpc i keep getting this error yet using direct sql this works just fine

{"hint":"No function matches the given name and argument types. You might need t o add explicit type casts.","details":null,"code":"42883","message":"function st _astext(extensions.geography) does not exist"}

Hello @theuknowner! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

Hello @lavenderlav! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

I guys, maybe a stupid question but I don't want to have the option for a magic link. But I can't find any settings to turn it off. My auth sign is already set on email and password. But whenever the password is empty it still sends the user a magic link

Trying to understand supabase-cli migrations. Is there a way to start supabase without running existing migrations? I would like to keep a file with the whole schema [big sql file] around (so i can quickly inspect it). When making changes to database schema i have two options 1) hand written migration 2) change the full schema [big sql file] 2.1) run

psql -f schema.sql

against freshly started supabase instance 2.2) run a

supabase db changes

with 2.1 against a supabase with all existing migrations to get a diff 2.3) (check diff + update where necessary) apply diff to production to end up with a same state as in 2.1 currently when you run

supabase start

it seems to run all existing migrations so i can't easily execute 2.1) and i have to essentially hand write my migrations. Or is the intended workflow the other way around and i should not maintain a hand written

schema.sql

but instead do

pg_dump

of the final database to get it? But this would still mean i have to hand write migrations or do manual changes to the database (i prefer to do it in code).

Hello ! This thread has been automatically created from your message in a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

How can I make author_id field auto filling based on logged user?

Hello @Aruzo! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

Howdy there everyone I'm getting an error for "CreateClient is not defined" here is my code for the supabaseClient.js

js
// @ts-nocheck
const supabaseUrl = "XXX"
const supabaseAnonKey = "XXX"
// Create a single supabase client for interacting with your database
export const supabase = createClient(supabaseUrl, supabaseAnonKey);

note the XXX is where my url and key is. any help would be huge! I also did

npm ci

to clean install my modules incase that was the issue

why does the dashboard tries to apply sorting by itself if your table contains a column called

name

it applies a sorting always on name column for no reason, I have to always remove filter every-time I refresh page or open the table viewer again to be able to see my data sorted by id which should be the default.

I'm calling a plpgsql function in the same way that the generated API docs recommend (supabase-js):

js
await client.rpc<Foo>('create_foo', { name }).select().single();

function:

sql
CREATE OR REPLACE FUNCTION create_foo(
  "name" text
) 
RETURNS setof foo 
...

But getting this following error:

sh
404 Not Found: Could not find the public.create_foo() function or the public.create_foo function with a single unnamed json or jsonb parameter in the schema cache (undefined)

Any idea what I could be missing?

Hi, i'm trying to setup twitter oauth, but when i call

js
supabase.auth.signIn({
  provider: 'twitter',
})

i just get redirected to

https://<project-ref>.supabase.co

( is my projects ref) not

https://<project-ref>.supabase.co/auth/v1/callback

hey guys! I have this error that seems to come out of nowhere, I left my computer a few hours ago, and apparently now the connection to the database is not working:

Can't reach database server at `db.<my-id>.supabase.co`:`5432`

Please make sure your database server is running at `db.<my-id>.supabase.co`:`5432`.

I saw some other people getting this, but didn't find a solution... Nothing has changed in my db configuration

Does onAuthStateChange trigger in all open tabs when the user logs in via a magic link in a different tab? It seems like https://github.com/supabase/supabase/issues/2739 fixed this but it doesn't seem to work for me? This is my code-

useEffect(() => {
    supabaseClient.auth.onAuthStateChange((event, session) => {
      if (event === "SIGNED_IN") {
        supabaseClient.auth.api
          .getUser(session.access_token)
          .then(({ user, error }) => {
            if (user) {
              setUser(user);
            }
          });
      } else if (event === "SIGNED_OUT") {
        setUser(null);
      }
    });
}, []);

I can't seem to be able to edit my triggers and function hooks. Is this not something that the free plan can do? I am following along with this tutorial atm and it looks like Jon has the ability to edit his, but I cannot edit mine, I have to delete them and reimplement: https://egghead.io/lessons/supabase-automatically-create-a-stripe-customer-for-each-user-with-supabase-function-hooks

Hello @garyaustin! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

Hello all 👋 I've been playing with the headlessCMS Directus. I have it installed locally and it uses sqlite3 for it's DB. I need help converting the DB to postgresql 🥳 I learned how to dump

data.db

from my local instance into

data.sql

. I wish to import that file into Supabase but not sure how to?! 😖 I ran

> sqlite3 data.db
SQLite version 3.38.2 2022-03-26 13:51:10
Enter ".help" for usage hints.
sqlite> .output data.sql
sqlite> .dump
sqlite> .exit

then

> sqlite3 data.db`
sqlite> .output data_structure.sql
sqlite> .schema
sqlite> .quit

I now have

data.sql

with all data and

data_structure.sql

😉 Just don't know where to go from there. Been Googling for a while and most solutions seem to point to Rails and Gems 😕

Hi, I'm using the

auth-helpers

for NextJS and not sure if my issue is a bug or expected behavior. The app is a simple todo list with authentication. But once I'm signed-in and if I sign out in another tab, I'm still able to write to the table by creating new todos in the first tab. Is this expected?