Group by specific column

hey, can someone help me with the join tables bit of

supabase.from('table').select( ... )...

how do I specify what tables I want to select from, what columns they're joined by, whether it's an inner or outer join. The docs are somewhat confusing here

rpc it is 🙂

We had a discussion about how to do this some time ago - there's an example here (https://discord.com/channels/839993398554656828/869406062036529193/888521446316445737) and there's some more supporting information in the messages before it. RPC is also a good option if you're more comfortable with SQL

a similar example is on the docs page, but it's still not clear what part is for what and how to do different things, and I kept getting errors about "table.column" doesn't exist

rpc is better for what I want to do at the moment 🙂

Hi guys, I think that I’m going crazy, there is something about the doc that I must not understand correctly. How would you convert this query

SELECT urls.id, urls.name, array_agg(tags) as tags
    from urls
    join urls_tags on urls.id = urls_tags.url_id
    join tags on tags.id = urls_tags.tag_id
    group by urls.id

To a supabase query ? I came up with that but it’s not complete:

await db.from(`urls_tags`).select(`urls:url_id ( id, name ), tags:tag_id ( id, name )`)

Or is there maybe a way to directly use my Postgres query ?

Using SQL query with supabase-js

js
const image = useRef()

const file = image.current.files[0];
const { data, error } = await supabase.storage.from("image-posts").upload(file, {
  cacheControl: "3600",
  upsert: false,
  });
if (error) alert(error);

I cant seem to upload an image to a storage bucket, i get the error "[object Object]". And the image variable reference is being used on an

<input type="file"/>

.

Hi!!👋👋 Anyone know a way to search through multiple column? I tried this below but has not worked haha 😅

Looks like you are missing a pathname in the upload() before the file object.

I thought about making 2 req to get both results and use concat() to merge then but I realize it would bring some duplicated rows

path of what/where exactly?

if anyone know a way to make this req on NEXTjs helps as well haha

I'm trying to signIn but i'm always receiving this error, i don't know what it is :/

Oh i see the error, i'm putting this on the function and i get this error

ERROR: column \"student:basic\" does not exist (SQLSTATE 42703)"

how can i fix that?

you'll need to use single quotes if you want to insert strings

double quotes are for postgres idenfiers: https://stackoverflow.com/questions/41396195/what-is-the-difference-between-single-quotes-and-double-quotes-in-postgresql

It works! Thanks!

Could anyone help me please ?

Is there really no way to do a join via the library ?

i don't think your query would run tbh, you can do a join via supabase-js but afaik only if you have a reference to the table you want the join to happen in via a foreign key on the table you want to join from. could be wrong, i stopped using the client lib a long time ago. why don't you create a view and then just fetch that via the client lib?

Thank you for your answer ! What do you mean by creating a view ?

https://www.postgresql.org/docs/current/sql-createview.html, it's like creating a mask with a bunch of holes so you can only see certain things. you can't change what it's in the view itself

Awesome ! Thank you very much

Hey do you have document that explain how to structure the supabase tables ?

The document would just say "It depends". What works for one project may not work for other projects.

Is there any rate limiting? I keep getting:

type: 'system',
errno: 'ETIMEDOUT',
code: 'ETIMEDOUT'

Restarting the server fixed it, is there any way to prevent this for the future?