After wrapping nextjs auth helper tags on _app.js this error comes

can you self host a supabase project that you build using the supabase cli?

If I run a DB query in the edge via Netlify, will it still be able to run?

I was trying to make a helper function to convert a

auth.users

row to json stripping away sensitive data. Using just

row_to_json

within the trigger function works perfectly fine. It would just make things "cleaner" and I'd especially like to understand why I don't get it working 😅 Following a few versions I tried, probably not all versions, though all error trying them in the Dashboards SQL Editor

sql
CREATE FUNCTION safe_json(_row json)
  RETURNS json
AS $$
  BEGIN
  RETURN row_to_json(_row)::jsonb-ARRAY['encrypted_password', 'confirmation_token', 'recovery_token', 'phone_change_token', 'email_change_token_new', 'reauthentication_token', 'email_change_token_current'];
  END;
$$ LANGUAGE plpgsql;

sql
CREATE OR REPLACE FUNCTION safe_auth_json(_row auth.users)
  RETURNS json
AS $$
  SELECT row_to_json(_row)::jsonb-ARRAY['encrypted_password', 'confirmation_token', 'recovery_token', 'phone_change_token', 'email_change_token_new', 'reauthentication_token', 'email_change_token_current'];
$$ LANGUAGE sql;

sql
CREATE OR REPLACE FUNCTION safe_auth_json(_row auth.users)
  RETURNS json
AS $$
  SELECT row_to_json(*)::jsonb-ARRAY['encrypted_password', 'confirmation_token', 'recovery_token', 'phone_change_token', 'email_change_token_new', 'reauthentication_token', 'email_change_token_current'] FROM _row;
$$ LANGUAGE sql;

sql
CREATE OR REPLACE FUNCTION safe_auth_json(_row auth.users)
  RETURNS json
AS $$
  SELECT row_to_json(_row)::jsonb-ARRAY['encrypted_password', 'confirmation_token', 'recovery_token', 'phone_change_token', 'email_change_token_new', 'reauthentication_token', 'email_change_token_current'];
$$ LANGUAGE sql;

I'm trying to create an entry if one like it doesn't already exist (i.e. if there's no UNIQUE conflict). I want to do this in bulk (it's for inviting users to a project) but if any of the rows conflicts, the whole op fails. I tried using

.insert(payload)

as well as

.upsert(payload, {ignoreDuplicates: true})

and both had the same issue... I'm using supabase-js (with Next.js)

Is the

filter

argument described in the guide page [1] would seem to follow the syntax of the

.or

filter [2] but in the API reference for RC2 it seems to reference the

event

argument instead. Can you confirm the correct syntax for the this parameter? [1] https://supabase.com/docs/guides/realtime/postgres-changes [2] https://supabase.com/docs/reference/javascript/next/or [3] https://supabase.com/docs/reference/javascript/next/subscribe

I have these 2 tables setup: room: -id groups: -id -members (I want to make this an array of foreign keys pointing to users table) A room can have multiple groups. and a group can have multiple users.

I'm developing an app with Supabase, and trying to use the JS SDK to fetch some information from the DB. When the app first run I got no problems at all, but when I refresh I always get

FetchError: Request with GET/HEAD method cannot have body

My code:

js
 await DiscordMessage.select(baseCols, {
        count: 'exact',
      }).gte('created_at', (() => startOfToday().toISOString())());

I dont know why this is happening :/

Hey! I installed TimescaleDB extension using web UI, however, I would like to upgrade to community edition since it enables more features I need. Is that possible while hosting on Supabase? Thanks!

Hey guys, I can promise you I could used

auth.uid()

and

auth.email()

inside my PostgreSQL functions like over a week ago. That's how I wrote my

delete_user

which I use with

.rpc()

from code:

sql
begin
raise log 'auth.uid(): %', auth.uid();
delete from auth.users where id = auth.uid();
end;

But now I noticed I can't delete my users anymore and I can see from logs the reason is that

auth.uid()

returns me

<NULL>

. It doesn't matter whether I do

SECURITY DEFINER

or

SECURITY INVOKER

for my func.

auth.email()

doesn't work as well. Did something happen over this week?

hi guys, i currently have a personal website that id like to link up with supabase but im not sure how, could anyone help?

Are there any best practices for when writing a function that you know will be queried many times? Like for counting views/like button?

Seeing an

update impacts too many records

when I try to trigger a mutation that changes multiple rows. I know I've got to be holding it wrong. What am I missing here? Both senderId and recipientId are definitely set correctly

mutation RequestAllTools($senderId: UUID!, $recipientId: UUID!) {
  updateToolsV2Collection(
    filter: { state: { eq: "ACTIVE" }, senderId: { eq: $senderId } }
    set: { state: "REQUESTED", recipientId: $recipientId }
  ) {
    __typename
  }
}

Typescript is barking at me when trying to fetch data with 2.0.0-rc.10 as follows:

const response = await supabase
            .from<Task>("tasks")
            .select("*");

I get a "No overload expects 1 type arguments, but overloads do exist that expect either 0 or 2 type arguments." error. I can't figure out what it's expecting as a second generic type parameter. Thanks!

I have been trying to filter by .gt() and .lt() on a column that is of type timez and it hasn't been working. Is it possible?

I am trying to sign users into my app using a QR Code. Previously, we would encode the email and password in the QR Code. My app would then fetch those credentials and use them to log in. I am trying to make this process more secure, but I want to keep the simplicity of the QR code sign in. Does anyone know of a way to do this? I was wondering if an OTP system would work, but supabase doesn't have the ability to create an OTP and then display that in the app.

I want to overwrite images with the same filename in my bucket. I am using upsert: true, which claims it will update it if true. Unfortunately this is not accomplished.

You can create a trigger On Insert/Update to the auth.users to insert/update the public.profile

Do you have a trigger setup in your database? normally this is caused by a trigger requirements not being met. Go to https://app.supabase.com/project/_/database/triggers and check if you have a trigger on the auth schema and get back to me.

Hello I have two tables and am pulling data from table 1, but I only want to pull rows that aren't joined to table 2. Has anyone done this in supabase js before?

As supabase uses deno for edge functions this poses a challenge for LSP configuration. The typescript files for the edge functions should use the deno language server whereas the other typescript files (at least in my case) should use the regular typescript language server. I'm using neovim and I'm getting deno errors in files that don't really use deno and vice versa. VSCode seems to by default only use denols on all the ts files so this is not a neovim specific problem apparently. Any advice on how to handle this?

Since Supabase webhooks do not support calling supabase edge functions directly, can I call them with a HTTP request? In case yes, how do I do that? In case no, are there any news on calling supabase edge functions through webhooks or is there a differnt approach to trigger edge functions on database inserts? https://supabase.com/blog/supabase-functions-updates#database-webhooks-alpha

Hey! Is there a way to delete the file cache instantly when deleting a file with

from.remove()

. Thanks in advance!

Is there anyway to get the row id back after an insert? I am using supabase_flutter 1.0.0-dev.9

I am updating an image via my app, that change is reflected in the supabase ui— correct modified timestamp and image priview. when I click "copy url" it goes to the old image. this is reflected on my front end as well with

getPublicUrl()

video of issue attached

As the title says, I'm currently trying to add a field to users who sign up. When I added

options

to the

signInWithOtp

function, instead of getting a OTP email I got a confirm email link. Is this currently not possible in V2?

const handleSignIn = async (email: string) => {
    setLoading(true);
    const { error } = await supabase.auth.signInWithOtp({
      email: email,
      options: {
        data: {
          onboarded: false,
        },
      },
    });

Hi there, I have more than 2 projects (+/- 4 right now) I'd like to have running but I wouldn't need all the added scale of the Pro plan. I would also turn them off/pause them often. How can i do this without paying 25$/month per new project :/ is there a way to have consumption based pricing and scale the projects from the free tier feature as need be? Thank you for your help with this

I have a page where I'm using paged data and I would like my users to be able to filter the data as they wish. Is it possible to have complex logic to conditions like this page shows: https://postgrest.org/en/stable/api.html#logical-operators ?

Is it possible to use connection pooling with supabase-js? Does it do it already? Or would I need to connect directly to the db using the connection string?

I am trying to update an entry in a table and whenever I run the PATCH request, it returns the following:

"Error in $: string at 'name=Updated'"