Have issue (or that's not an issue?) with querying item from database. At moment when

land

has

artifact

and artifact value isn't null query returns item object perfectly. Whenever

land

doesn't have any

artifact

query returns

null

instead of queried object. E.g. Land #0 has stored artifact id. E.g Land #1 doesn't have stored artifact id (null). Any ideas how I could solve that (both lands (#0, #1) suppose to return result with or without artifact)?

js
const { data } = await supabase
  .from('lands')
  .select('artifact!inner(*)')
  .eq('id', id)
  .single()

Good day to all, I would like to know or if someone could help me, I am trying that the registration information is also assigned to a table, but only remains in the authentication part in the user section, to send it to a table how could I do it? thank you for your help, happy day

Hey all! Does anyone know why my API url differs? 1. In the Studio (

http://localhost:54323/

):

http://supabase_kong_<my_project>:8000

2. In `supabase start`:

http://localhost:54321

I'm trying to join two tables with identical columns. I'm getting:

UNION types timestamp with time zone and text cannot be matched

Hey all! I'm using NextJS and have the following problem. I can access the supabase client from my the client/browser but in SSR I get the error:

"Request Failed"

. Anyone know what might be the cause?

The docs say "Data imports - import directly from a CSV or excel spreadsheet." but I can't find how to do that after the table is already created

I am trying to use function hooks and I am just finding out it is only available for new projects. is there a way I can migrate my database to be a new project so I can use function hooks ?

I am getting this error when I do

await supabaseClient.auth.signIn({email, password,});

and it is crashing my application. This was working for months and suddenly started today with no changes to the code

FetchError: invalid json response body at https://REACTED.supabase.co/auth/v1/token?grant_type=password reason: Unexpected token < in JSON at position 0
    at /node_modules/node-fetch/lib/index.js:273:32
    at processTicksAndRejections (node:internal/process/task_queues:96:5) {
  type: 'invalid-json'
}

Hey Hey! Does anyone know if supabase local dev server supports exposing the studio to local network?

Hey, I am creating some sort of Crypto Wallet where you can login with email/password. Now the thing is that i have to store a users Private Key upon wallet creation. A little problem is, that key has to be encrypted and even the database admin shouldn't be able to find it out. It should only be retrievable by the authenticated user himself. Does someone have an idea on how this could be made possible? Thanks alot in advance!

Hello, I'm trying to figure out if I should go with Supabase. One of the requirements that I don't seem to be able to find information on is user roles. Let's say I would like to add a role to my users, which will allow them to do different things based on the defined role. Perhaps an easy example is that I would like some users to get the "admin" role but not limited to the "admin" role. I might have a role named "jobseeker" or "employer" or "dev". Is this possible with Supabase and where can I find more information about it?

Planetscale vs Supabase vs Aurora. Aurora clearly mentions it's 128 TB limit. Why is Supbase not sharing all the limitations of its database?

Hello, can someone help me with this issue - https://github.com/supabase/supabase/discussions/7657 ?

Hi, realtime + RLS only can work in DELETE event. pls help, thanks 😀

Is anyone having trouble with login with email & password?

Any iead why in edge function

console.error('toto')

is not visible in the logs but

console.log('toto')

work ?

Hey! How can I pay Supabse from Russia?

Hi, anyone else using Supabase with SvelteKit?

Hi, how can I build the project to test it on a Raspberry (arm archirecture)?

Hi everyone, I'm starting with superbase local environment and I'm having this error after run

supabase db remote commit

and check the migration with

supabase db reset

the error is:

Error: Error starting database: ERROR:  cannot drop function graphql.cache_key(regrole,jsonb,jsonb) because extension pg_graphql requires it
HINT:  You can drop extension pg_graphql instead.
ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR:  current transaction is aborted, commands ignored until end of transaction block

I'm using

getPublicUrl

and it returns the wrong url, the bucket name is listed twice. Before I file an issue on GH, wanted to make sure I am using correctly.

export async function uploadImage(imageFile) {
    const bucket = client
        .storage
        .from('avatars');

    const { data, error } = await bucket
        .upload(imageFile.name, imageFile, {
            cacheControl: '3600',
            upsert: false
        });

    if (error) {
        console.log(error);
        return null;
    }

    console.log(data);

    const url = bucket.getPublicUrl(data.Key);

    return url;
}

does supabase expose some identifier token for the request, like ip and or user agent? skimming postgrest docs/issues i found

current_setting('request.header.user-agent', true)

but in all my tests this returns

null

use-case: i want to allow anonymous users to add "claps" (like Medium), but with a limit of claps per-IP or some other identifier

Hey all. I am having the issue with the supabase studio

Connecting to Default Project

which spins forever. The DB is working though as I can access all tables w/ prisma studio. Is there anything I have to do to make it work? Running M1 Max

Is it intended that

queryParams

aren't passed on to the provider sign in URL? E.g. I have the below code which redirects to the Discord page, however

prompt: none

is never added to the URL.

await supabase.client.auth.signIn({
  provider: 'discord'
}, {
  scopes: 'connections guilds email identify',
  queryParams: {
    prompt: 'none'
  }
});

Hey everyone, I seem to be having a problem using ngrok + nextjs api + supabase functions... https://egghead.io/lessons/supabase-automatically-create-a-stripe-customer-for-each-user-with-supabase-function-hooks I am using RLS on my "profiles" table and I think it is causing an issue where I am unable to update the

stripe_customer

column. Some notes... 1. When the API runs via the ThunderClient testing UI, a stripe customer is created and whichever email I hardcoded in the POST body is added to the Stripe Customer Dashboard. 2. When the API runs via the

user flow through my app

, the "email" [ shown below ] .... is not displayed in the stripe customer dashboard.

js
  const customer = await stripe.customers.create({
        email: req.body.record.email,
    });

    await supabase.from('profiles').update({
        stripe_customer: customer.id
    }).eq('id',req.body.record.id);

I am not sure what could be causing this issue other than RLS and the use of ngrok.

How can I make Supabase REST API return the inserted row? Right now it responds with

{"message":""}

What's the difference between Owner and Developer roles in an Organization? Debating if making company's admin the Owner will make them the bottleneck if I need to make new projects, changes etc

Has anyone else been getting "Token has expired or is invalid" errors in the past ~6 hours?

Which migration tool would you recommend with supabase. Supabase CLI migration seems to open mamy doors for data loss. I am thinking of using prisma just for migration. And than use supabase-js. Domt wanna use prisma as an ORM because they dont have a dart client. I want the same backend logic for web and mobile app.

How to set a column value to null from web dashboard?