I’m thinking seeds, factories, and tests. Typically, I’d let those role dynamic.. but yea, maybe that’s not achievable right now. In this case, the emails aren’t real. Bogus users for testing. So confirming is out unless there’s a code solution.

I'm getting a disambiguation error, which I wasn't able to resolve from looking at existing issues/documentation around disambiguation. I have an app where

users

can subscribe to

pages

and submit

comments

on

pages

. I have a

users

table, a

pages

table, a

users_pages

table, and a

comments

table. I can currently pull a requested

page

, along with the

users

subscribed to it, with the following function. Is there anyway I can edit this the function below to pull all of the

comments

for the requested page as well? Each

comment

has a foreign key corresponding to

page_id

.

javascript
 const { data, error } = await supabase
    .from('pages')
    .select(`*, users(id, email)`)
    .eq('slug', request.body.get('slug'))

@User recommended doing it like this:

javascript
 const { data, error } = await supabase
    .from('pages')
    .select(`*, users(id, email), comments(*)`)
    .eq('slug', request.body.get('slug'))

— which results in this error:

javascript
{
  message: 'More than one relationship was found for pages and users',
  hint: "By following the 'details' key, disambiguate the request by changing the url to /origin?select=relationship(*) or /origin?select=target!relationship(*)",
  details: [
    {
      relationship: 'public.users_pages[users_pages_page_id_fkey][users_pages_user_id_fkey]',
      cardinality: 'm2m',
      origin: 'public.pages',
      target: 'public.users'
    },
    {
      relationship: 'public.comments[comments_page_id_fkey][artifacts_user_id_fkey]',
      cardinality: 'm2m',
      origin: 'public.pages',
      target: 'public.users'
    }
  ]
}

Can anybody recommend a way to troubleshoot this? Do I need to set up any other tables in my database, like a

comments_pages

table, or change the way I'm doing foreign keys?

Would there any be a problem with Prisma and why we should not use Prisma? I'd wanna know your thoughts on this guys. Personally I would want to use Prisma.

I have about 12 fields in my table that i want to

.select()

. I want to fetch all except one (email).

is there anything like "except" ?

.select(*).except('email')

Or do I need to explicitly fetch the 11 things?

You would need to explictly list them or you could create a view!

ooh A view! I don't know what that is! Time to google, thank you!

I'm unclear about Connection Pooling

Is it something I need to worry about in my app? I see that supabase has connection pooling available, and it's enabled for my database.

Is there anything else I need to do there, or am I now good to go to accept lots of users?

Aha! https://supabase.com/blog/2020/11/18/postgresql-views. I don’t see a supabase interface for these? Do I just write the sql and that’s that?

Yeah you have to just write SQL

Self hosted Supabase Studio (Dashboard) is now available

I'm getting a connection error saying

"could not extend file \"base/12662/16813\": No space left on this device

when trying to insert to my database. I'm on using a 1/3 of the database's alloted space. What might be going on here?

DB Pooling

Hi, please make it expendable like it is on firebase. Me and my friends are looking to move our projects to supasbase but its super annonying

site isnt working for me

whats happening

😒 no, dont tell me its the ghost in ma house

Boss, its working

the cookie session expired lol, just had to relogin

we good, aye 🤝

How to earn a contributor role? is it just a single pull req or any certain number? 🤔

Any contribution to a Supabase Project!

is supabase having issues right now?

Dosen't appear to be

My project keeps just refusing to load any data other than one single row and I thought maybe I messed up the code but I can confirm I haven't after loading it on my phone

for some reason it just refuses to load anything at some points then randomly starts working again

Cool!