Hey team! I'm wondering how to make queries with one to many relationships. My specific example is an invoicing app where each

Invoice

has many

LineItems

. My db model is setup where the

LineItem

has a reference as

invoiceId

to the primary key of the corresponding invoice. I'm wondering how can query and create invoices that includes that line items themselves? The only thing I found in the docs is to include the foreign key relationship which I already have setup. So, I know I can query an invoice from a line item, but how do I query line items from an invoice?

I am using supabase object storage and I have uploaded static JS file can I update same static file keeping url of that object storage same?? I want to have multiple revisions but url should not change

Just checking.. are views available in GraphQL? Because they don't seem to be populated in the schema 🤔

Hey, I'm trying to delete "my" logged in user by using a rpc call to a stored procedure / function. I'm not sure how to do the workaround to allow the action from client. I know the docs says that this is an action that requires a backend call with service_key, but I don't have any other running backends for my project. I've tried the following: - Set role to

service_role

- Grant usage on schema with

authenticated

- Create policy on `auth.users`for delete to

authenticated

My response:

message: 'permission denied for table users',
code: '42501',

Any suggestions or other workarounds? 👼 My latest attempt:

create or replace function cleanup_user ()
  returns boolean
  language plpgsql
  as
  $$
    begin
      SET ROLE TO service_role;
      delete from auth.users where id = auth.uid();
      return true;
    end;
  $$

Looking for clarification on some concepts: We have Triggers, Functions, Function Hooks, and Edge Functions. I thought Functions Hooks were basically triggers? but then what are

Triggers

? And It seems like

Functions

are postgres RPC functions, but then what are Edge Functions?

I'm trying to set up a multi tenant database and am trying to create a new tenant and a user whenever someone signs up. I'm struggling inserting data via a trigger on a new row in auth.users since I'm trying to insert data into two separate tables (tenants and users).

Hi guys, do u know if there is any way to cascade deleting records from supabase with .delete().match() in javascript?

Trying to set up a RLS policy where if a column on another table contains the value NULL for the current user it gets allowed, otherwise it's not but I am having difficulties with setting up the policy. Anyone that can take a look with me?

Hi all, a question about the

!inner

join function in the JS client. Currently the data I get from the database is like the image on the left. The database returns me an array of object which contains another object called

images

with the

url

inside it. What I want to do is tell Postgres to return only array of

urls

from the the

images

table, which were obtained through the

!inner

join function via the table

item_image

. (Continue in the thread --->)

I can't fetch anything anymore. If I execute a simple query in the SQL Terminal in the supabase app, I get a

An error has occured: Failed to fetch

. Why is this happening?

When self hosting Supabase the Supabase-db container takes up 10gb of the docker file which is half of my total capacity:

Hello everyone! how can I implement to login flow with magic link in "native" applications?, for example an ionic app, since the email link will just try to redirect to a web url, thanks in advance!

getting error while changing phone number:

Hey guys, do you know what can be causing this error on my self hosted instance? 400 : Content-Type not acceptable: text/plain

I'm creating an Edge Function and want to use the example where the auth context is set, however, whenever I pass an authenticated jwt token, the user object remains null. What am I doing wrong?

const { user } = supabaseClient.auth.setAuth(req.headers.get('Authorization')!.replace('Bearer ', ''))
    console.log(user)

I'm getting a 403 on my local storage service (Docker). Request looks like this: http://192.168.1.119:5000/storage/v1/object/avatars/ Headers include authorization, apikey ( both ANON_KEY). I'm a bit clueless on this issue.. Everything looks fine in the config files. The fact that i'm getting a 403 indicates that the storage service is active and reachable. Anyone have any clue where i need to look? 🙈 The database and auth service work just fine.

Hello, I am implementing Supabase with Angular and I use the Supabase API from Typescript, the problem that I am seeing is that when I want to use a Postgresql function that receives parameters, since the format of the parameters is a JSON, I observe that in the payload of the call to the API end-point that data is totally visible, therefore totally insecure... do you know if there is something that can be done so that it travels encrypted or something similar. Thanks for your time

When putting in the wrong password when connecting to the postgres database, i eventually get locked out ( which is good). How long until I can try to log in again lol?

Hey, supabase doesn't update this value in the email confirmation. Can someone help me?

Hi all. New to supabase here. I am trying to select from a table in the "public" schema, and join it to the users table in the

auth

schema, but I get an error. Query:

let q = supabase
    .from<Message[]>('messages')
    .select('*, channel:channel_id(id, name), user:user_id(id, email)')
    .order('created_at', { ascending: false })
    .limit(100)

Error:

"Could not find a relationship between 'messages' and 'user_id' in the schema cache"`

Unable to deploy edge functions. Nothing happens after I enter "supabase functions deploy hello-world"

Hello everybody, I was wondering what I did wrong that my database function. It seems not to show up in RPC. The function is as followed:

create or replace function public.getDepotStats()
RETURNS TABLE(id uuid, name varchar, number varchar, owner_id uuid, created_at timestamptz,totalExports bigint, totalGainLoss float) 
language sql
SECURITY INVOKER
AS $$
SELECT depots.id,depots.name,depots.number,depots.owner_id,depots.created_at,
     (SELECT COUNT(*) FROM depot_exports WHERE depot_exports.depot_id= depots.id) as totlaExports,
     (SELECT win_loss_amount FROM depot_exports WHERE depot_exports.depot_id= depots.id ORDER BY export_time DESC LIMIT 1) as totalGainLoss
      FROM depots
      ORDER BY depots.name;
$$;

Using Flutter/Dart as a client I get the message:

PostgrestError (PostgrestError(message: Could not find the public.getDepotStats() function or the public.getDepotStats function with a single unnamed json or jsonb parameter in the schema cache, code: PGRST202, details: null, hint: If a new function was created in the database with this name and parameters, try reloading the schema cache.))

Any suggestions, ideas what I did wrong?

When I do a setAuth with my service token the user remains null, what am I doing wrong? Also the Docs state there should be an error object but there doesn't seem to be one?

Is there a way to inject securely store other data (app-specific auth stuff) in Supabase's JWT tokens?

I'm unable to create a simple if/else function in my database. If I use the example from postgresqltutorial.com it also fails. Any pointers would help..

Hi guys, new to supabase. I have a table of profiles and one of my columns, 'ownedItems', is an array of JSON objects. I want to retrieve the rows from this table if a value, namely 'itemAddress', in the any of JSON objects in the array matches a parameter 'redeemedItemAddress' that I pass in. Any suggestions on how to do this?

I'm trying to access the invited_at column in a database function when a new user is inserted. I have an if statement that says

if new.invited_at IS NOT NULL

The if statement itself works fine, however, invited_at is checked and is seen as null even though it's not. Any clue what's happening?

How do I pass user_metadata when inviting a user? Following the docs I get to the following statement however it appears that the metadata isn't set:

supabaseClient.auth.api.inviteUserByEmail('john.doe@example.com', {data: {first_name: 'John'}})

Hi all 👋 I'm trying to find a tutorial or other resource on how to use the

pg_sodium

extension. The only thing I've been able to find is an announcement and how to enable. Do you happen to know if there are official docs or a tutorial somewhere that could help me out?

Hey guys, i have a weird case going on and i dont know if it is the expected behavior. When a user enters my app for the first time, he creates his account via Phone Auth, only with a OTP and without a password. He can however create a new password for his account (auth.update({password: '...'})) It works fine, i can see his password on my database, but when i try to login again with the same phone number without a password, it lets me login without errors. Is that the expected behavior in this case?