Hello! Is there a way to do

ON DELETE CASCADE

in the UI or does it need to be done through SQL?

Hey, it looks to me (just investigated js library) that under the hood for Auth, it's authenticating and then storing that jwt returned in local storage for its entirety until it's invalid and you need to login again. Is this a correct interpretation? If so, I thought it wasn't secure to do so as it creates XSS risks? Thanks in advance, just learning!

Hey All, I am looking to create some grouping polices based on the authenticated users' group id that I have added. In the

auth.user

table I have added a uuid field that corresponds with another table's uuid field in attempt to create group permissions. I have been following this template, but I have not been able to get it to work. are there others trying to setup grouping rls policies. is this something that supabase is working on? https://github.com/supabase/supabase/discussions/1148

-- step 1: add agency_id to raw_user_meta_data
UPDATE auth.users
SET raw_user_meta_data  = auth.users.raw_user_meta_data::jsonb - 'agency_id' || '{"agency_id":"df56814f-46ab-4d1c-9e4e-6393e727b212"}' 
where auth.users.email = 'walter.k.jenkins@gmail.com'

-- step 2: create function
create or replace function auth.orgid() returns uuid as $$
     select nullif(
            ((current_setting('request.jwt.claims')::jsonb ->> 'raw_user_meta_data')::jsonb ->> 'agency_id'),    
            '')::uuid

$$ language sql;

-- step 3: set policy
create policy "allow read/write access to boards for users of the same organization"
  on public.notes for all using (
    (auth.orgid() = notes.agency_id)
  );

sql
-- create teams table
create table teams (
  id bigint generated by default as identity primary key,
  creator uuid references users not null default auth.uid(),
  title text default 'Untitled',
  created_at timestamp with time zone default timezone('utc'::text, now()) not null
);

-- teams row level security
alter table teams enable row level security;

-- policies
create policy "Users can create teams" on teams for 
  insert to authenticated with check (true);

ts
  const createTeam = (title: string) =>
    supabase
      .from('teams')
      .insert({ title });

Is returning

code: "42501"
details: null
hint: null
message: "new row violates row-level security policy for table \"teams\""

Please what's does the RETRYING_AFTER_TIMEOUT error status represent? I'm expecting it to reconnect after a the timeout like the error status displays. But that's not the case, I would like to know the default TIMEOUT for reconnection. Thanks!

I have table "assets":

CREATE TABLE assets (
  id TEXT PRIMARY KEY,
  title TEXT
)

I have table "assetmeta":

CREATE TABLE assetmeta (
  id TEXT PRIMARY KEY,
  accessstatus TEXT
)

I have a view "getpublicassets":

CREATE VIEW getpublicassets AS
SELECT * FROM assets LEFT JOIN assetsmeta ON assetsmeta.id = assets.id
WHERE accessstatus = 'public'

Then I run it:

SELECT * FROM getpublicassets LIMIT 100

When I EXPLAIN ANALYZE it says it is performing a loop for each row and it's slow. What can I do to optimize my view? Tried adding an index:

CREATE INDEX asset_public ON assetmeta (
    accessstatus ASC
 );

Doesnt seem to matter

Hello everyone ! I noticed that recently a warning indicating that “DB functions” are not production ready, that was the case before for Edge Functions, which now these don’t have the warning. So I’m a little bit confused on what should I use for production? DB functions or Edge Functions.

Hey, I've also posted this yesterday and got a tip but doesn't work. I have the Users table (The default one) And a profile table with the following fields: id, firstName, lastName, email, registeredToExam, paymentId All of them are nullable except ID so I dont get errors at write I have the following function put in place and the trigger:

create or replace function public.handle_new_user()
returns trigger
language plpgsql
security definer set search_path = public
as $$
begin
  insert into public.profiles (id, email, lastName, firstName)
  values (new.id, new.email, new.raw_user_meta_data->>'lastName', new.raw_user_meta_data->>'firstName');
  return new;
end;
$$;

-- trigger the function every time a user is created
drop trigger if exists on_auth_user_created on auth.user;
create trigger on_auth_user_created
  after insert on auth.users
  for each row execute procedure public.handle_new_user();

During the signup I send the following data:

const { user, error } = await supabase.auth.signUp(
    {
      email,
      password,
    },
    {
      data: {
        lastName,
        firstName,
      },
    }
  );

I made sure to validate the first and last name before I do this. yet, I get an error when creating the db, but I don't know why..

error in createUser { message: 'Database error saving new user', status: 500 }

Id really need some help here

so I want make a balance type on profile account generally I want use it as uint because I dnt want user over order something is this possible with supabase ? because I want limit if its reaches zero or sum balance isnt enough, it cancel the order/transaction

The migrations that work on my local DB aren't being pushed and I have no feedback as to why. Below is the migration file it's currently erroring on:

CREATE OR REPLACE FUNCTION public.tid(
    )
    RETURNS uuid
    LANGUAGE 'sql'
    COST 100
    STABLE PARALLEL UNSAFE
AS $BODY$
select
      coalesce(
        (nullif(current_setting('request.jwt.claims', true), '')::jsonb #>> '{user_metadata, tenant_id}')
    )::uuid
$BODY$;

ALTER FUNCTION public.tid()
    OWNER TO supabase_auth_admin;

GRANT EXECUTE ON FUNCTION public.tid() TO PUBLIC;

GRANT EXECUTE ON FUNCTION public.tid() TO anon;

GRANT EXECUTE ON FUNCTION public.tid() TO authenticated;

GRANT EXECUTE ON FUNCTION public.tid() TO dashboard_user;

GRANT EXECUTE ON FUNCTION public.tid() TO service_role;

GRANT EXECUTE ON FUNCTION public.tid() TO supabase_auth_admin;

COMMENT ON FUNCTION public.tid()
    IS 'Returns the currently logged in users tenant id';

I was following this article https://supabase.com/docs/guides/integrations/prisma#resources however once I try to migrate the database it fails at connecting to the db with the error

unexpected response from login query

any ideas?

Everytime I open the Storage tab, I receive this message: "Migration failed. Reason: An error occurred running 'pathtoken-column'. Rolled back this migration. No further migrations were run. Reason: column "path_tokens" of relation "objects" already exists"

I'm making a chat app, and for the purpose of this question I have two tables,

chat

and

users

.

chat

has some columns like where the message was sent in, the message contents, and the email of the person who sent the message.

users

has a user's email, name, and profile picture URL. Right now I have some code like this:

js
export const connectToMessages = async (channelGetter) => {
  return supabase
    .from("chat")
    .on("INSERT", async (payload) => {
      const newMessage = payload.new;
      console.debug("recieved message", newMessage);
      if (newMessage != channelGetter()) return;
      const { data } = await supabase
        .from("chat")
        .select("contents, users ( name, profile_picture )")
        .eq("id", payload.new.id);
      messages.set([...get(messages), data[0]]);
    })
    .subscribe();
}

But this means it's laggy because it has to make a whole new query for each message. Is there a way to fetch the user and send it in realtime, or does anyone have any other recommendations?

Hi guys, i'm using pgBouncer with my supabase project but the Pool Size is limited to 15. is there anyway to increase this ?

i haven't used supabase in a while. last time there was a settings section that had the db connection string. now that seems to be gone.

Hey there. I want to update my list of events when a user has made an update to it. Realtime seems to be the correct option for that but it's not working for me. I used the docs as an example and edited some of the variables. https://supabase.com/docs/reference/javascript/next/subscribe#listening-to-a-specific-table

typescript
supabase
    .channel("public:events")
    .on("postgres_changes", { event: "*", schema: "public", table: "events" }, (payload: any) => {
        console.log("Change in events", payload);
    })
    .subscribe();

When I make a change nothing seems to be popping up in the console. Environment: - React v18.2.0 - Supabase-js v2.0.0-rc.6

I dont get it keeps saying Cannot use import statement outside a module, I'm using node.js with vanilla JavaScript, but i insist on this being on the backend for security rather than using the cdn, which has worked, any help

If I get around 200 requests at once, around 5 times each day (but only 1 day), will the free tier be able to handle it? I will be creating a row with an id and a small array of text as well as fetching around 60 rows from a table (storing an image url and a text description).

Next.js 12.2 has been out since May, and we still do not have support for the new edge middleware with Supabase auth helpers. @User

I've been trying to get SSR working by passing the

sb-access-token

cookie value to

createClient

in

supabase-js

v2, but it's not returning a session. Any ideas why this isn't working?

ts
const supabaseClient = createClient<Database>(PUBLIC_SUPABASE_URL, PUBLIC_SUPABASE_ANON_KEY, {
    global: {
        headers: accessToken ? { Authorization: `Bearer ${accessToken}` } : undefined,
    },
})
const session = await supabaseClient.auth.getSession() // returns null

Hi friends, i tried to enable RLS for service_role. Then called the Edge function however i'm unable to get any data back. I tried the example code here https://github.com/supabase/supabase/blob/master/examples/edge-functions/supabase/functions/select-from-table-with-auth-rls/index.ts recommended by @garyaustin But with no success... when i disable RLS, it works The main purpose is to use the edge function to update the table.. and prevent client side users from updating it

I was trying to make a simple select query on SSR in sveltekit, but in the error section it gives me a Cloudflare HTML page with the "id.supabase.co needs to review the security of your connection before proceeding." stuff. Anyone know the solution?

supabase.storage .from("pics-profile") .upload("client\img\A029.jpg") any clean and beautiful code to the solution ?

Hello, I was wondering if its possible to pull the latest database changes from the remote and apply them locally without using migrations? I.e. like a straight dump?

hello i get error

Hey there. I would like to create an rpc that lets me create a new user when it is ccalled theough client side js. How do i do it?

Somebody knows how to upload a filelist of file on supabase, currently im on nextjs with typescript and i only know how to upload one single file at a time😫

Hi, any ideas how to setup eslint for supabase .ts functions? Not familiar with deno ecosystem and I'm getting the error on my hello-world function: An import path cannot end with a '.ts' extension. Consider importing 'https://deno.land/std@0.131.0/http/server.js' instead.

Using the JS Supabase client I'm trying to rename multiple files by calling storage.from("bucketname").move(oldpath, newpath); My issue is that some of the requests succeed with a 200 response and others fail with a 500 error stating Internal Server Error : Access Denied. In spite of this the rename/move operation still works as expected on all the files. I can't spot any obvious differences between the files or paths, same folder, same bucket with the same access permissions. Super weird. I could work around the issue by just ignoring 500 responses but if I can sort this out I can provide better error handling/notification to users when an actual failure occurs. Any help is much appreciated 🤔

Hello everyone! 👋🏻 I was wondering if there's any way to write an Edge Function that behaves like a transaction. I do have logic in my Database Functions and what I really find valuable of this way is that if any operation inside that function fails; the entire transaction fails and "reverse" any other writes to the database, ensuring that I perform an atomic operation once calling that RPC. On the other hand, what I don't enjoy a lot of this is that I need to write all of that logic in pgplsql, I'll prefer to have it written in TypeScript. But as long as I understand, the Edge Functions doesn't behave like a transaction when I have multiple operations inside (eg. a couple of inserts and updates), if any of these fails, the others that succeed will not rollback, ending with inconsistent data and undesired results. So, is there any way to this approach, or any other recommendation? Thanks a lot!