How do you connect S3 Storage/Spaces to Supabase?

Is there a correct way to set the session cookie without using the standard Auth login methods (Email, Magic Link, Phone, Social)? I saw the v2 changes here but it's a bit confusing: https://supabase.com/docs/reference/javascript/v1/upgrade-guide#cookie-methods Can Auth helpers packages be used without Auth Login? https://supabase.com/docs/guides/auth/auth-helpers/nextjs#server-side-rendering-ssr Any demos showing how to use this basic SSR in Next.js? https://supabase.com/docs/guides/auth/server-side-rendering

I am trying to run a function that is executed on new user creation events. When I am trying to use uuid.generate_v4() in the function, I get "function uuid.generate_v4() does not exist". I also tried using extensions.uuid.generate_v4() and I get a permissions denied for schema extensions. Apologies if a really dumb question... New to SQL/Supabase Here is the function: begin insert into public.api_keys (id, created_at, updated_at, api_key, owner) values (uuid_generate_v4(), now(), now(), uuid_generate_v4(), new.id); return new; end;

How can I get data encrypted with podium with JS from database. I tried but failed.

json
{
  error: {
    code: '42501',
    details: null,
    hint: null,
    message: 'permission denied for function crypto_aead_det_decrypt'
  },
  data: null,
  count: null,
  status: 401,
  statusText: 'Unauthorized'
}

I'm trying to use Auth Helper to implement Supabase Auth in Next.js. I followed the official documentation but Session is still null. Oddly enough, after a few login attempts, sometimes Session isn't null. When Session is null, the event of onAuthStateChange isn't called and there is no Cookie in browser. here is my code: 　https://github.com/tererun/supabase-auth-test thanks

Hey everyone, I'm trying to do a signup page where you can only signup if you have a certain access code. the users gets registered to the default supabase users while the access code is store in a table called "codes" that looks something like this: primary key: id code: text (the code) Obviously I don't want the codes table to be public to anon users. The issue I'm having is with the function to trigger before the query to signup the users. I can't figure out how to get supabase to process the access code used by the user. Any tips on how should I approach this? thanks

I started my project in the cloud, then I wanted to shift development to my local machine and push changes to staging, then to production like a sane person. So I setup the supabase cli, and used

supabase remote commit

then

supabase db reset

, it copied the schema from the cloud , but I also wanted the data there, so I used

pg_dump -d 'postgresql://postgres:xxx@db.xxx.supabase.co:5432/postgres' --no-comments -v >  dump.sql

then created a new migration with

supabase migration new dump < dump.sql

, but after running `supabase db reset`: I find this error:

Resetting database...
Initialising schema...
Applying migration 20230125074447_dump.sql...
Error: ERROR: schema "auth" already exists (SQLSTATE 42P06)
At statement 10: --
-- TOC entry 23 (class 2615 OID 26604)
-- Name: auth; Type: SCHEMA; Schema: -; Owner: supabase_admin
--
CREATE SCHEMA auth
Try rerunning the command with --debug to troubleshoot the error.

I'm aware of the

-N

argument in

pg_dump

that excludes a schema according to the given pattern, I don't want that because I want to clone everything from the cloud database including users?

I am using the Nuxt Library, when trying to login I just get redirected to the login page again. It seems like the cookie doesn't set. My Code looks similar to the one from the Demo. Chrome on Windows works fine When trying to login to the Demo everything seems to look fine. The app is deployed behind an traefik reverse proxy

I'm having trouble integrating Braintree payments using Deno. When I try to create a transaction with a payment method and create a customer. I get an error from the log like this.

TypeError: B.setTimeout is not a function
    at https://esm.sh/v104/braintree@3.13.0/X-ZHN2LzAuMTMyLjA/deno/braintree.js:2:11960
    at new Promise (<anonymous>)
    at Je.httpRequest (https://esm.sh/v104/braintree@3.13.0/X-ZHN2LzAuMTMyLjA/deno/braintree.js:2:11184)
    at Je.<anonymous> (https://esm.sh/v104/@braintree/wrap-promise@2.1.0/X-ZHN2LzAuMTMyLjA/deno/wrap-promise.js:2:1479)
    at Je.post (https://esm.sh/v104/braintree@3.13.0/X-ZHN2LzAuMTMyLjA/deno/braintree.js:2:10463)
    at Je.<anonymous> (https://esm.sh/v104/@braintree/wrap-promise@2.1.0/X-ZHN2LzAuMTMyLjA/deno/wrap-promise.js:2:1479)
    at Ur.create (https://esm.sh/v104/braintree@3.13.0/X-ZHN2LzAuMTMyLjA/deno/braintree.js:22:19972)
    at Ur.<anonymous> (https://esm.sh/v104/@braintree/wrap-promise@2.1.0/X-ZHN2LzAuMTMyLjA/deno/wrap-promise.js:2:1479)
    at Ur.sale (https://esm.sh/v104/braintree@3.13.0/X-ZHN2LzAuMTMyLjA/deno/braintree.js:22:20894)
    at Ur.<anonymous> (https://esm.sh/v104/@braintree/wrap-promise@2.1.0/X-ZHN2LzAuMTMyLjA/deno/wrap-promise.js:2:1479)

and here it's my source code

import braintree from "https://esm.sh/braintree@3.13.0?target=deno&no-check";

export const gateway = new braintree.BraintreeGateway({
  environment: braintree.Environment.Sandbox,
  merchantId: Deno.env.get("BRAINTREE_MERCHANT_ID") ?? "",
  publicKey: Deno.env.get("BRAINTREE_PUBLIC_KEY") ?? "",
  privateKey: Deno.env.get("BRAINTREE_PRIVATE_KEY") ?? "",
});

const result = await gateway.transaction.sale({
        amount: "10",
        customer: {
          id: user.id,
          email: user.email ?? "",
        },
        paymentMethodNonce: nonce,
        deviceData: deviceData,
      });

Every time my program deploys it always fails due to an unexpected statement with this vague error. It fails on prisma db push, didn't used to. I have pgbouncer in connection string and have restarted db multiple times. Any help is appreciated

#13 8.185    0: sql_migration_connector::flavour::postgres::connection::describe_schema
#13 8.185            with namespaces=None
#13 8.185              at migration-engine/connectors/sql-migration-connector/src/flavour/postgres/connection.rs:31
#13 8.185    1: migration_core::state::SchemaPush
#13 8.185              at migration-engine/core/src/state.rs:381

I've added a new column on Supabase so I did a reload on Hasura to see it. Well it sees it and the query works but when using REST it says: {"code":"validation-failed","error":"field 'result' not found in type: 'table1'","path":"$.selectionSet.table1.selectionSet.result"} I think the only way is to delete the schema and retrack? There should be a better way next time?

is it possible to create a sequence in a function? I tried something like:

sql
-- drop function c_sequence;

create or replace function c_sequence(sequenceName_input text)
returns text
language plpgsql 
as $$  
BEGIN
  CREATE SEQUENCE sequenceName_input;
  return sequenceName_input || ' created';
END;
$$;

but it won't pick up the value of sequenceName_input. Instead it uses it as a literal string and creates a sequence Named 'sequenceName_input'

How do you fix new public schema/table permissions from Supabase?? I've had to delete the scheme folder entirely then recreate in Supabase but I can't figure out how to get permissions back. I need it to be in Supabase because it does a created_at timestamp.

I have created a bucket with the name video and when i try to fetch all the buckets, i am getting empty bucketList. I also have the user logged in. I have added policy for selecting, updating and deleting. Please help me fetch the buckets. Thanks

Hi, it seems like SSL connections are not possible when using pg bouncer? I'm getting this when trying to connect through pgbouncer (i.e. port 6543)

psql: error: server does not support SSL, but SSL was required

Looking at https://github.com/supabase/postgres/blob/develop/ansible/files/pgbouncer_config/pgbouncer.ini.j2 it looks like ssl is disabled

Hello, I try to pass a List to the SignUp-method's metadata (along with some other values like firstname,...). Without the List of Strings, it worked as expected, but now it throws this error: > "ERROR: column "liked_list" is of type text[] but expression is of type text (SQLSTATE 42804)" The column "liked_list" exists as text[] in the appropriate table.

I attempted to upgrade to Postgrest 11 by pausing and then restoring my Supabase project (as directed by Supabase via email), but when I run

select version()

in query editor, I'm still seeing:

PostgreSQL 15.1 on aarch64-unknown-linux-gnu, compiled by gcc (Ubuntu 10.3.0-1ubuntu1~20.04) 10.3.0, 64-bit

And I'm also unable to order by fields in a foreign table, as is supposed to work per here: https://supabase.com/blog/postgrest-11-prerelease#order-by-related-tables. Is there a way to force it to update?

I am developing a chat application and have a

message

table. Each

message

row has an

id

column set as

int8

type. I am concerned that if the number of messages exceeds the limit for that data type, what will happen?

Hello everyone, as of today, when creating a new table, I cannot seem to find varchar as data type and also cannot find user table as part of displayed options when I want to refer to that table as foreign key. Any idea what'd be the reason for that? It is like this since a couple of hours now. // it's not a realtime-centric question per se, all mentioned tables above are real-time enabled. fyi.

Is it possible to restrict access to a realtime channel to the service role? Are all non-db channels public?

Hello, as described in the title, I'm using Google OAuth sign in. After signed in browser shows duplicated cookies both of localhost and superbase. Is there a way to prevent this behaviour?

How can I create and manage a session without requiring users to sign in to the app? Similar to the functionality on the website https://w2g.tv/en/, where users can create a virtual room with chat without having to register. Can this be achieved using Supabase Auth?

I read the docs for realtime and couldn't clearly understand the use of

channel.track

function. > Each client can use the channel's track method to store an object in shared state. > > https://supabase.com/docs/guides/realtime/quickstart#track-and-display-which-users-are-online What type of data should be passed to it?

If I generically pass

Database

type as stated here: https://supabase.com/docs/reference/javascript/select, should I get any IntelliSense when calling methods like

from

or

insert

or whatever at this point?

I want to change email template, i tried for several hours but i didn't find a way, is there a way to do this?

I'm new to supabase and a little too busy prototyping to do much research. Sounds like this project is postgres under the hood with an API layer between? Does that mean the scalability properties are similar to a single instance postgres? I.e. no horizontal scaling abilities. I like the product but I want to make sure it's ready for handling 1b records. Either that or I'll use NoSQL for the big stuff I suppose. Insight appreciated here.

I'm currently going through the documentation on how to setup auth with the sveltekit-auth-helper function and although everything is working fine, I'm having a hard time wrapping my head around how things work. For example, the docs mention that to do data fetching using RLS client-side, we need to import

$lib/db

in our component, but we need to use the auth-helper

getSupabase

when doing data fetching on the server. Why is that ? If my server load function passes the session + supabaseClient down to the client, isn't that already enough ? I read and re-read the documentation : https://supabase.com/docs/guides/auth/auth-helpers/sveltekit and https://supabase.com/docs/guides/getting-started/tutorials/with-sveltekit multiple times and also read the auth-helper function code and I just don't quite get it (yet). Another example is why the docs mention calling

getServerSession(event)

in the layout.server.ts and

getSupabase(event)

in the layout.ts to get the session, why call 2 different functions ? From Sveltekit docs, the client would have the session coming from the data of the server load function Maybe I'm missing something obvious here, I tried to test if this structure was to make sure we invalidate properly, but couldn't really find any answers. This is my first app with supabase auth and I am trying to understand better.

I have this code that is supposed to generate the signed URL.

ts
const fileName = 'whatever.jpg';
const signedUrl = await this.supabase.storage.from("images").createSignedUrl(fileName, 60);

When I run this I get the error

StorageApiError: The resource was not found

. Why would it complain about resource not being found when I am trying to generate the signed URL to put the resource at that location? Of course it doesn't exist yet since I haven't done

HTTP PUT

to the signed URL to upload the resource.

TLDR: How does

PostgresTransformBuilder.rollback()

work? ~~ Was reading through the

PostgrestTransformBuilder

API and discovered it has a

rollback()

method https://github.com/supabase/postgrest-js/blob/933b4d622ac1ef12b7cb19a8c163a4db4a8721d4/src/PostgrestTransformBuilder.ts#L230-L242 Jumped over to the tests, and sure enough it looks like it'll rollback a mutation https://github.com/supabase/postgrest-js/blob/94db7098ef9d75766b8ca84b1e888f34a3eb759d/test/transforms.ts#L217-L271 But when I gave it a try, the record remained in the database and was not removed. I haven't come across documentation on this method, but I did come across it exposed on the

SupabaseClient

so it seems like it can be used -- but not sure how. Anyone with success story on this one?

When using Discord OAuth the user does not get logged in and nothing actually happens other than the user being created. When using an email and password login everything works correctly. There are no errors and when using

useSessionContext

and

isLoading

does update. I am using NextJS 13 (no app folder). I am following along with this guide https://supabase.com/docs/guides/auth/auth-helpers/nextjs