Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

im basically wanting to allow users to "add" games to their profile

so each user can sub to games, in which like

ok, so you're trying to get data from `users_games` table through `game_directory`

the user can have many "games" from "game_directory" to their profile

so basically each column will contain a new entry for every game

yea in that case, `users_games` would have two rows

both rows would have the same user_id, with two different game_directory_ids

then i can just grab every entry that has their userid

so theoretically you could directly access that table

```js
let { data, error } = await supabase.from('game_directory').select(`*`).eq('id', user.id);
```

```
let { data, error } = await supabase.from('users_games').select().eq('id', user.id);
```

why is it returning undefined on page load?

Maybe I'm misreading your `.eq()` call above, but wouldn't that be pulling `game_directory.id` - which should be unique (and not a user ID)?

Do you have a `hosted_by_user` field (or something similar) which you can link to `users.id`?