This sounds like a use case for a many good many relationship with bridge table

Have you thought of that?

single() will throw an error if there are NO rows returned (eg, there must be exactly one row) maybeSingle() will allow you to select one row, but also allow none (there can be one or zero rows)

Hey! Is there perhaps a live update going on in the dashboard? Facing some couple of issues 1. Can't create table with primary other than int* 2. Table is created without columns even after error in

1

occurs 3. Can't change primary key type for empty table even if i set

int*

in

1

4. Can't see default value field when editing primary key The below screenshot is for

3-4

Hi! I get an error trying to bulk upsert in to the following table. Error message says: All object keys must match The array I'm trying to upsert looks like this:

[
  {
    id: 'si_KFtDgimqIKkY6q',
    subscription_id: 'sub_1JbNQoEXkCyWFmfFwTxz6Ewu',
    user_id: '8f6cb53b-4a97-4297-a722-727cb2e6f335'
  },
  {
    id: 'si_KFtDSFw9pGCr6G',
    subscription_id: 'sub_1JbNQoEXkCyWFmfFwTxz6Ewu',
    user_id: '8f6cb53b-4a97-4297-a722-727cb2e6f335'
  }
]

Anyone has a clue?

Hi, we are developing a new webapp using NextJS and Supabase. Since yesterday afternoon, Supabase stopped sending the magic link for email sign-up/sign-in. Our code base hasn't changed in the last two days so we don't think our code is causing a problem. Here is the error message we get from Supabase server: time="2021-09-19T14:14:00Z" level=error msg="500: Error sending magic link" component=api error="Error sending magic link email: gomail: could not send email 1: 421 Domain app.supabase.io is not allowed to send: Poor mailing list quality" method=POST path=/magiclink referer="https://www.getskylls.com/" remote_addr="67.149.210.16:60346" request_id=bcfb3554-0653-4dbc-9e84-a5d2446aae11

Magic link email is no longer sending

is there a way to perform full text search on multiple columns?

Is it possible to access Supabase storage S3 directly, just like Database?

And i am not alone https://discord.com/channels/839993398554656828/839993398554656831/885596013132382249

Not at the moment. We'll be working on allowing you to BYO s3 bucket in the future, which should give you complete control over the storage files

Great! Thank you

I dropped public schema aaand now i have this error )

code: "42501"
details: null
hint: null
message: "permission denied for schema public"

Tried to fix it with "GRANT USAGE ON SCHEMA public TO authenticator;" But it does not helps (

Start a new project and it will be there, also I wouldn't recommend dropping any schema you didn't create in the db yourself

I also found that solution in the web ) But i dont want to create new project, i have a lot of dependencies (Discord auth, client env. variables)

If you've dropped the schema, it means that the schema itself is gone. I'm curious why you dropped it in the first place. I'm not sure if the default config for Supabase has anything going on in the background that links in with the public schema, but either contact support through the feedback widget in the dashboard, or recreate the project.

Thanks. I will use ‘maybeSingle()’ then.

Hi everyone, I need a bit of help. Is there a way to configure the MS endpoint for Azure auth? Supabase directs you to the common/login endpoint and I want to use a tenant specific endpoint so that I don’t have to enable multitenant AAD on Azure. Please help. Thanks.

I am not receiving magic link emails for signup/logins anymore, anybody else?

now they arrived

I'm not getting them either

yep still waiting on the new one 😄

One came through after ~5 mins but went to spam

I have a similar use case and I think it's not available yet for postgresql. Alternatively, you can store the ids and make a second query to get their data. You can also create a "middle-table" to manage the many-to-many relation (foreign keys are subscription_id and price_id) and, from there, using both foreign keys, access both tables

How exactly would I protect a download so that only people logged in can use the link? I'd need to do some kind of auth checking on the server that supplies the download right?

is this the correct syntax to listen to changes on the multiplayer table and on the

room_name

column that is equal to

que

?

supabase.from("multiplayer:room_name=eq.que")
  .on("*", (payload) => {
       console.log("Change received on que room", payload)
   }).subscribe()

As long as the room name is actually

que

and not a code-level variable called

que

, then yes, that looks correct

well the thing is that if I use id like

multiplayer:id=eq.23

it works, there is a room_name with a value of

que

it is type

text

Hello, all 👋 Quick question about disambiguating queries –

In my project, I have a

rules

table, a

channels

table, and a

rule_channels

table that stores the relationships between those two, like this: