hi everyone, has anyone tried integrating prisma with supabase? specifically the auth functions that supabase exposes, can prisma see those? getting this error when adding a trigger to a migration:

db error: ERROR: schema "auth" does not exist

in this github thread it looks like someone asks the same question and did not get a response / was asked to go to prisma: https://github.com/supabase/supabase/issues/1502, conversely in prisma's slack someone else asked as well and the response was to ask around here, but in the discord search i didnt see anything

Hey, im fetching some videos from a storage bucket, is there any way i can fetch them by data order? since im lazyloading and fetching them on the go i can't order them client side

Hey, why doesn't this log the user? Instead, it seems to be refreshing the page after login and the console clears

js
    const { user, session, error } = await supabase.auth.signIn({
      // provider can be 'github', 'google', 'gitlab', or 'bitbucket'
      provider: "github",
    });

    console.log(user);

Have you done all this https://supabase.com/docs/guides/auth/auth-discord ?

yea

The login is working, but I'm not able to log the user information or route the user somewhere after

It just refreshes the page and wipes everything

Is there any way to monitor the size of data transfer of database in a month? I am worried that I"ll reach the monthly transfer limit without noticing.

Hello supabase team Some time ago I released cavapi.com on producthunt(https://www.producthunt.com/posts/cavapi) and I just found out I get xp for that 😄

Hi! Is there any way you can have a combination of two columns in the database unique? For example if i have a table with

id

and

userId

as columns. I don't want

userId

to be unique and i don't want

id

to be unique. But the combination between them to be unique. Can that be done?

Yes, you can have a unique constraint that spans multiple columns as described here: https://stackoverflow.com/questions/14221775/in-postgresql-force-unique-on-combination-of-two-columns

Is there a 'supabase' way of doing it?

I mean like in the ui?

you should be able to do through the sql editor tab:

ALTER TABLE tablename ADD CONSTRAINT constraintname UNIQUE (userid, id);

Hey everyone! I need to transfer a Supabase DB to someone else, what's the best way of doing this? Is there a way for me to export my Supabase DB, then import into their Supabase DB?

Thanks!

Hello peeps, what the best way to handle prod and development environments in Supabase? Just create a separate project for different environment and have the database table synced?

I don't think having the database synced is a good idea

I was referring about having same columns/relations, not documents

Sorry for missunderstanding

one way i did it in the past is through pgadmin connected to the postgresql supabase instance, there you can dump the db to a file and restore it by loading that same file on the new instance

For some reason the query doesn't work. it just says

could not create unique index "index_name"

. i don't have any other indexes. One of the columns is a foreign key. is that okay? And none is unique. Am i doing something wrong?

Does the table need to be empty?

no there's no need for it to be empty, what command did you issue?

@User It worked now, but i needed to wipe the table 🤔.

ALTER TABLE invites ADD CONSTRAINT unique_invites UNIQUE (group_id, owner_id);

it's possible that some of the entries were violating the constraint, that'd be my guess

Maybe, and the data doesn't really matter. Thanks for the help!

Is there a way to create tables without using GUI?

Yes, in the SQL editor to the left

Hey Community! How are you doing? I have a question. Do you have any example using Supabase with user roles like, admin, reader, writer, etc and the policies for them on the tables? I'm watching some videos about it but so far the examples are things like: "It is logged?" and that's way too simple. Thanks in advance.