Hey I'm trying to import a fairly large CSV (220k+ rows) into Supabase as a table. I keep getting "An error has occured: NetworkError when attempting to fetch resource." I'm currently on the free tier. Is this a tier issue? Should I be on a paid tier for a table of this size?

For RLS, I have a table where I have set a column as user_id. In my RLS policy, I check if this user_id row value matches the current user_id using the given function. Is this the right way to do this? Also - how do I prevent a user from adding rows with arbitrary user_ids? I want to auto populate the user_id column Any leads are welcome, thanks!

Hi, what are the best practices to secure a backend route(nodejs) which can update raw_app_meta_data to add additional information to a user like "trial", "premium" etc.? This should only be available to a signed-in user with "admin" rights. As far as I see there is no possible to add different roles to the JWT or do I miss something out here? Any helpful tipps/ideas are welcome.

Are database functions called by rpc susceptible to SQL injection?

Hey, when I enable RLS and enable a policy that allows the service_role to read, I still get an empty array as a response of the HTTP request. I'm using service_role api key in the headers of the request (tried with apikey, and authorization, and both) Any idea? Policy is :

CREATE POLICY "Enable read for service_role" ON "public"."listings"
AS PERMISSIVE FOR SELECT
TO service_role
USING (true)

I have a question regarding hosting supabase using docker. It seems that some things do not work as on the supabase platform (e.g., functions can't be found anywhere). It also does not seem possible to create backups for the database (it says something about going pro but clicking that will not lead anywhere). Is there something I'm missing or is there documentation on how to get that part working?

Hello @bhaskar! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! 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.

Hi, are there some workings on Functions being made or something? Cus I've noticed spike in execution time of those.

Hi, I'm having issues when tryin to deploy a Function. CLI is returning Error: Failed to create a new Function on the Supabase project: {"message":"Internal Server Error","errorEventId":"d15a4384a9ec47b3a3c910138e68e09e"}

Where would I go find API docs for Supabase's API? Because of an issue with a dependency I can't use the supabase client, so I need to resort to making requests to the API directly.

Is it safe to expose Supabase URL and Anon key? I'm looking at SvelteKit tutorial and those variables are exposed there since db.js is a client-imported module, not a server endpoint

What are best practices to use with supabase functions and git? Do I keep .branches folder? Or config.toml file?

How is not everyone here affected by the following issue?: https://github.com/supabase/gotrue-js/issues/323. Currently refresh tokens in supabase-js are not handled properly, meaning that you need to either extend the age of the refresh token (insecure) or your users will need to relogin in every time. Making supabase (specifically auth) unusable currently in JS. Is there something I am missing?

Anyone facing issues on opening the SQL editor on the studio? Been showing a 500 error all morning. Thanks

Queries timing out in supabase

why is this returning an error: "Failed to run sql query: cannot change return type of existing function": create or replace function auth.uid() returns text as $$ select nullif(current_setting('request.jwt.claims'::text, true)::json->>'uid', '')::text; $$ language sql;

Hello @SunilGupta! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! 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 @rbkayz! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! 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 does anyone keep track of migrations or changes within a migration? Is it better to have large but few migration files or small but many migration files? I see recommendations like knex.js or ley or Prisma. However, at the end, it's hard to see what has overall changed. How many migration files do you have for your projects (10s, 100s, 1000s)? Does having more slow down development?

Could I build this app with SUPABASE? So basically I want (WEB3 wallet authentication) that I can make with code but its not directly supported by SUPABASE authentication, could anyone help me a little bit and tell me if this is even possible and how.

Hello @Marc A! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! 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.

Edge Functions have been misbehaving. Currently receiving a 'socket hang-up error', when trying to call it. Is there an issue? cc:@sidharth28

If i buy a domain can files in storage use that domain as a root or is it always my project random id

Hey! Does anyone know how to decrypt the phone confirmation token generated by the otp? I'm trying to do some automated testing.

I can't seem to get any events in realtime

Hey can someone explain why this function

js 
supabase.from('note').insert({
  note: 'dasasddas',
  supplier_id: 54,
})

doesn't insert anything into the db without the await. I understand that we can't use the result right away, but why is nothing inserted into the table ?

Hello everyone. I have just discovered Supabase and am very interested in doing my first tests. One of the top questions I have is related to Edge Functions: is it possible to trigger an Edge Functions via a "real time" database trigger? A practical example would be to "listen" to a change to a record (or an insertion of a record) into a certain table => to launch an Edge Function which would send an email Many thanks

Hello, newby asking here Is there a way to overwrite a native supabase api? For example, when calling the API of /rest/v1/todos make other validations and return more fields based on those validations

We created an "Edge Function" that is maybe the kind of thing you mean. https://github.com/sillsdev/sil-font-analytics/blob/master/supabase/functions/report-font-use/index.ts

what's the failed login cooldown period? trying to migrate instances and the existing db is rejecting my connection