Hello! I was wondering if there is a toggle of sorts that prevents batch deletion in the Supabase UI, to prevent things like accidentally deleting a ton of rows

Hoping I can get some help from folks here... - Been developing on Supabase for about 6 weeks... - This morning, get a pop-up/message in browser saying no projects found... - Refresh - same result - Log out and try to log back in - invalid credentials - Try to get reset email - been waiting for > 20 min - no email Completely DoA right now... Thanks so much for your help in advance

Hi. I'm using resetPasswordForEmail, which is sending me an email as expected. The link takes me to my nominated callback function, but const code = url.searchParams.get('code') gets me nothing. Although the docs state that "The query parameter is always code" there is no such query parameter on the url that I am seeing. const next = url.searchParams.get('next') returns my next function ok. There is a long hash tag - "#access-token=". Can anyone help/advise me? Thanks!!

Hello, why are the supabase auth discord scope guilds data of the user not exist in session?

Hi I'm doing a nested query that looks like this ``.select(, lesson:lesson_id(, course: course_id(*))); `` But i'm getting a typeScript error later in my code that is saying course can be of type single or array. How do I either tell typescript or supabase that this is a many to one relationship and course will should always be a single instance rather than an array?

sql
DECLARE
  slash_position INT;
  value int;
  entry_id int;
BEGIN
  -- Encontra a posição da última ocorrência do caractere '/'
  slash_position := strpos(reverse(new.short_url), '/');
  
  -- Extrai o valor após a última ocorrência do caractere '/'
  value := reverse(substring(reverse(new.short_url) from 1 for slash_position - 1));

  select id 
  from url_data 
  into entry_id
  where slug = value;

  update public.report_data
  set id = entry_id
  where id = new.id;

  RETURN new;
END;

erro :

"No operator matches the given name and argument types. You might need to add explicit type casts."

Hello Supabasers 🙂 I wondered if it was possible to run the SQL I use in the webUI via SQL Editor > New Query via the API? Python preferably. I don't want to insert data, but programmatically setup a table and search function. Is it possible?

is there a way to store user information on files? or vice versa?.

I am unable to use the dashboard/supabase studio. Whenever I go to any of the pages under the 'Database' icon (https://app.supabase.com/project/my_project_id/database/), there are a number of API calls to the

pg-meta

service They all work fine except for

/tables

, e.g https://api.supabase.io/platform/pg-meta/my_project_id/tables I consistently get the same error. Using the logs, I identified the query that's called from

pg-meta/tables

( see below ) When I run it in my SQL editor, its taking >30 seconds - is the 500 Error caused by a timeout on the query? I played around with the last line of the query, excluding various schemas to identify the bottleneck. I am using supabase as my database for a Strapi instance (headless CMS with lots of relations), and that schema is taking nearly 15 seconds on its own. What are my options here? I'd like to be able to use the supabase dashboard - I use Supabase Webhooks to notify external systems of changes to my CMS. https://cdn.discordapp.com/attachments/1111360080433139783/1111360081775304744/message.txt

Since today I can’t connect my flutter app anymore to, on my Mac hosted, local dev supabase instance. I get a connection refused error. iPhone is coupled via cable. URL is http://localhost:54321 and the anonkey is also correct. This was always working before. Not sure if the flutter upgrade today could be the reason but I doubt it a bit Anyone who knows how to fix this?

I'm currently working on adding multi-factor authentication to my SvelteKit app, but I've encountered an issue. I'm not sure how to handle the situation when a user leaves or refreshes the site before completing the verification of the MFA challenge by scanning the QR code and inputing the verification code for enrollment. In my code, I need a way to determine whether the user has left or refreshed the site before successfully verifying the MFA challenge. The problem is that when I call the enroll function to add another factor, it doesn't automatically remove the previous unscanned factor. So, I'm looking for an effective way to handle this situation and detect if the enrollment process has failed. Could anyone please provide some guidance on how to approach this?

The tables are only acsessed by a discord bot hosted on a single instance that I control personally. I'm not afraid anyone will steal the api key. Is it then okay for me to disable RLS, knowing nobody else can acsess the databse, or are there any threats I do not know about?

Is it possible to use below query in supabase JS select * from visas where current_date - country_arrival_date >= 30;

I have followed the guide pretty much to the tee and still having a problem, when I am trying to sign a user up with the supabase.auth.signInWithPassword(), I am getting a 500 error on client console. I am trying to do this in a client components but perhaps it's my lack of knowledge, but would really like help on it.

When starting the database with

supabase start

the schemas are not correctly loaded. I used to get

FAILED: 500 - Database error querying schema

when accessing the database the first time after a restart. That wasn't a huge problem, as the next call would then usually work. (I'm guessing the error triggered a reload). However, since I added an edge function to my setup, I can't access the functions through the usual RPC calls anymore. (Interestingly, the edge function has full access to all functions). Only when I reload the cache (either using

docker kill -s SIGUSR1 <container>

or using

NOTIFY pgrst, 'reload schema'

from studio) can I access the functions again. I tried to add

NOTIFY pgrst...

to my seed script, but that didn't help. Does anyone have a tip on how I could easily reload the schema? I'm running the self-hosted supabase as part of testing, and I would need to do this in an automated way. Setup: - Supabase version 1.50.12 - Archlinux (fully up to date) - the supabase instance has non-standard ports.

The docs in question: https://supabase.com/docs/guides/cli/managing-environments Running

supabase db remote commit

immediately generates a migration which cannot be applied (EDIT: to an instance started via the supabase cli) and fails. The offending line is:

CREATE EXTENSION IF NOT EXISTS "supabase_vault" WITH SCHEMA "vault";

This fails in the type generation CI with:

Error: ERROR: extension "supabase_vault" is not available (SQLSTATE 0A000)

.

Hello, csv import is not working for me, so i had to use the API for importing. Here's a part of my code. process.env.NODE_TLS_REJECT_UNAUTHORIZED = "0"; const supabase = createClient(SUPABASE_URL, SUPABASE_ANON_KEY); fs.createReadStream('transformed-results-test.csv') .pipe(csv()) .on('data', async (row) => { const newCompany = { first_name: row.first_name || 'N/A', last_name: row.last_name || 'N/A', job_title: row.job_title || 'N/A', reworked_job_title: row.reworked_job_title || 'N/A', skills: row.skills || 'N/A', past_company: row.past_company || 'N/A', company_city: row.company_city || 'N/A', company_linkedin_url: row.company_linkedin_url || 'N/A', revenues: row.revenues ? parseInt(row.revenues) : null, funding: row.funding ? parseInt(row.funding) : null, company_description: row.company_description || 'N/A', company_secondary_industry: row.company_secondary_industry || 'N/A', tags: row.tags || 'N/A', }; const { data, error } = await supabase.from('prospects').insert(newCompany).select(); if (error) { console.log(

Error inserting data: ${error.message}

); } else if (data && data.length > 0) { data.forEach((record) => { console.log(

Inserted company data: ${JSON.stringify(record)}

); }); } else { console.log('No data inserted'); } }) .on('end', () => { console.log('CSV file successfully processed'); }); Terminal response in the first comment

Not sure if anyone else is having this issue, but I'm unable to connect to my project ... tried a few different networks

I need to make authenticated fetch API calls through TLS using certificates, the only way that I found to make it is to use the unstable

Deno.createHttpClient

function. It works locally, but when I deployed to supabase at runtimes it throws an error

Deno.createHttpClient is not a function

. My guess is that it may be that supabase edge functions by default do not come with the

unstable

flag as

true

. Is there a way to make this work?

I'm following the example code from auth-helpers nextjs server components example, after successful google authentication the app redirects to my dashboard page from a middleware function . The thing is, I can see the auth code in my url search params. Is there a reason why this happens? I would like to avoid this if possible. Any help would be appreciated import { createMiddlewareSupabaseClient } from '@supabase/auth-helpers-nextjs'; import { NextResponse } from 'next/server'; import type { NextRequest } from 'next/server'; `// this middleware refreshes the user's session and must be run // for any Server Component route that uses

createServerComponentSupabaseClient

export async function middleware(req: NextRequest) { const res = NextResponse.next(); const supabase = createMiddlewareSupabaseClient({ req, res }); const { data: { session } } = await supabase.auth.getSession(); if (!session && req.nextUrl.pathname.startsWith('/required-session')) { // Auth condition not met, redirect to home page. const redirectUrl = req.nextUrl.clone(); redirectUrl.pathname = '/dashboard'; redirectUrl.searchParams.set(

redirectedFrom

, req.nextUrl.pathname); return NextResponse.redirect(redirectUrl); } return res; }` https://github.com/supabase/auth-helpers/blob/main/examples/nextjs-server-components/middleware.tsx

See subject

I am trying to make an architectural decision and I cannot figure out if Supabase bills by Database write (as firebase did). Will "Database Egress" be modulated by Database writes? 💵

i am trying to select a user row from a users table that has a column with an id in it that refrences to an id in another table which has name column and etc. How do i fetch the user from users table and have the name values of the other table using the foreign key

So I want to update a column ("quantity") in the table grocerystores anytime there is an insert, update ,or delete on the grocerystoreitems. Right now the first query does successfully return the SUM of the quantity field in the grocerystoreitems. However when I run this I get an error "Invalid SQL query" error. Right now I just want to make sure the function works by calling it in the SQL editor and then I am going to set up a trigger on it.

sql
CREATE OR REPLACE FUNCTION update_quantity(storeId bigint)
RETURNS void
LANGUAGE plpgsql
AS $$
BEGIN
  BEGIN;
    SELECT SUM(quantity) AS total_quantity
    INTO total_quantity
    FROM public.grocerystoreitems 
    WHERE "storeId" = storeId AND quantity > 0;

    UPDATE grocerystores
    SET quantity = total_quantity
    WHERE Id = storeId;

    COMMIT;
  END;
$$;

Hello! Recently I reached out to support and got our project enabled for early access to storage v3 resumable uploads. I tested out the simple Uppy example from the blog post (https://supabase.com/blog/storage-v3-resumable-uploads) in our app. On the staging environment, which is the project that was enabled by support, it's been working great! However, the same code is not working on local. Here's the relevant snippet:

const uppy = new Uppy()
  .use(Webcam, {
    modes: ['video-audio', 'audio-only']
  })
  .use(Audio, {
    showAudioSourceDropdown: true
  })
  .use(Tus, {
    endpoint: `${process.env.NEXT_PUBLIC_SUPABASE_URL}/storage/v1/upload/resumable`,
    headers: {
      authorization: `Bearer ${process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY}`
    },
    chunkSize: 6 * 1024 * 1024,
    allowedMetaFields: [
      'bucketName',
      'objectName',
      'contentType',
      'cacheControl'
    ]
  });

On staging,

NEXT_PUBLIC_SUPABASE_URL

is

https://<my-project-id>.supabase.co

, whereas on local it is

http://localhost:54321

. Locally, the upload results in

net::ERR_CONNECTION_REFUSED

. Is it possible to get the local instance to support the same? Am I able to do whatever it is support did for the staging instance but for my local? Thanks.

Hey fellow Python Supabase enjoyers (TLDR: skip to bottom for fix), I was tired with Supabase-py's poor documentation and getting a working solution for proper auth that doesn't break constantly so I made a custom class that should hopefully help solve these issues: https://github.com/supabase-community/supabase-py/issues/272 https://github.com/supabase-community/supabase-py/issues/185 https://github.com/supabase-community/supabase-py/issues/247 https://github.com/supabase-community/supabase-py/issues/440 I haven't added a workaround for https://github.com/supabase-community/supabase-py/issues/395, but if anyone would like to adapt it into the code on the gist you can see a workaround for it here: https://github.com/supabase-community/supabase-py/issues/399. This also won't solve the issue with redirect_to, as that is an issue with python gotrue's base64 encoding/decoding (https://github.com/supabase-community/gotrue-py/issues/246), but that should hopefully 🤞 get fixed soon since a fix was just merged to gotrue-py's main branch. __**TLDR: auth_handler function to Depend on https://gist.github.com/0xDeadcell/884fc080b9fd49a9721cffec09ef95c3**__

sql
DECLARE
  entry_count int;
  total_urls integer;
  current_type url_type;
BEGIN

  -- Obtém o subscription_tier do usuário associado à nova URL
  select COUNT(*) - 1
  into entry_count
  from url_data e
  where e.user_id = new.user_id AND e.type = 'free';

  -- Verifica se o total de URLs é menor ou igual a 10
  IF total_urls <= 10 THEN
    current_type = 'free'::url_type;
  ELSE
    current_type = 'payed'::url_type;
  END IF;

  -- raise exception 'total_urls %', total_urls;

  update public.url_data
  set type = current_type
  where id = new.id;

  RETURN NEW;
END;

i checked total_urls value so even that i have less 10 im getting payed on the table

We are using Supabase with Next.js as an admin dashboard and an API server. I want to use Supabase's auth system for 2 things: 1. I can pre-create a user's account by supplying an email address and some long random password. Then I can send them a password reset link for them to claim their account. 2. I can detect whether a user has confirmed their email address My questions are: (A) Can I send a user an email confirmation and have that set their

email_confirmed == true

, while still allowing them to sign in with their account even before email confirmation? (B) What columns in the database are set when a user confirms their email address? If I were to check just one DB column, which one should I check? (C) Can I consider the database table for

auth.users

(or a view of that table) stable in terms of an API? AKA can I rely on it for important auth decisions, or must I rely on Supabase SDKs? (C) If a user changes the email address for the

auth.user

entry, does the new email become "unconfirmed"? (D) Do OAuth signups automatically set the underlying email address as confirmed? (E) Can I have a successful password reset move an email address from unconfirmed to confirmed? This would be necessary for goal (1) that I'm trying to achieve above. Thanks.

anyone know why would this happen? my database is dead and not responsive, i tried restarting the database and even the whole project but no luck, been this way for an hour or so rn, any help??

Hi, I want to create a parameterized view in which when it is called one has to pass it parameters that will be used for filtering data in where clause. How can we create a parameterized view?