Database relationships are associations between tables that are created using join statements to retrieve data. I don't know in the case of Supabase of the ORM handles the relationships without creating a foreign key, but anyways, you should create the relationships (Add the corresponding foreign keys to your tables)

Thank you @User. I'm familiar with the concepts of foreign key relationships in relational database in general. My question was, more specifically, how is that done in supabase. I've not been able to find a way to define a true foreign key relationship between tables. I'm wondering if I'm missing it somewhere.

Maybe you should create them in the "SQL" section, click on "+ New query" them write the raw sql code

sql
ALTER TABLE public.mytable
    ADD CONSTRAINT mytable_tabletorelate_fkey FOREIGN KEY (column_mytable)
    REFERENCES public.tabletorelate (column_torelate)
    ON UPDATE NO ACTION
    ON DELETE NO ACTION
    NOT VALID;

that's how you create a foreign key

sql
ALTER TABLE public.mytable DROP CONSTRAINT mytable_tabletorelate_fkey;

And that way you delete the relationship

Thank you for your help @User

Does anyone have any suggestions for debugging high cpu usage? I'm constantly at 180%

Either Task Manager or Activity Monitor (depending on your OS) should help you identify the process that's consuming CPU time. Should help you at least narrow it down.

Is there a way to SSH into the supabase-hosted machine? Or should I just go ahead and self-host

I don't know about that, but if it's not running on your local machine, then it's likely not anything related to supabase that's causing the high CPU usage is it?

I'm referring to this (in the supabase dashboard) concerned that this will affect my launch today. Also a lot of queries end up taking a long time to run. Was wondering if theres a good way to debug

Gotcha, that makes sense. I didn't realize that was what you were referring to. Thanks for clarifying. I'm unable to help with that though, sorry.

hello, I'm wondering what's the difference between storage.objects and storage.bucket? It seems that only policies on storage.objects takes effect

order with foreign table

Hi all, I looked around a lot, but couldn't find how to join tables

I am able to create a query snippet on the website. Am I supposed to use that somehow?

Is this what you're talking about?

not exactly

SELECT * FROM twitter INNER JOIN badge_wearers ON twitter.user_id = badge_wearers.user_id;

SQL query I'm trying to run. It runs on the website, so there must be a way to do it with the library

Is there a way to execute raw SQL queries?

No it's not possible to run raw SQL queries from the client. Instead you can write rpc functions https://supabase.io/docs/guides/database/functions

How should I do this?

Sorry, can you elaborate a bit?

I think it's

*,badge_wearers(*)

as

select

parameter. Your

on

columns need a FOREIGN KEY constraint for this

I've answered this in a thread https://discord.com/channels/839993398554656828/839993398554656831/910761522698010634

Is it supposed to be something like

*, badge_wearers(user_id)

?

I did indeed a mistake. (corrected now) your version would only return the

user_id

column from

badge_wearers

Oh ok