How can I do select count(*) with "group by" in supabase-js?

user_1993366 0
Viewed 783

How do I write a "group by" query in supabase-js?

In traditional SQL it would look like this:

SELECT COUNT(*), PLAYER FROM GAMES GROUP BY PLAYER

Using React and supabase-js, my code so far is like this:

    const { data, error } = await supabase
        .from('games')
        .select('count(*), player')

        // I need something like this: .groupBy('player')

How can I do group by?

supabase reactjs group-by
1 Answers

I believe this can only be done by using the RCP (PostgreSQL functions).

  • Unfortunately, I think this is the only way so far - but maybe this can be changed in the future.
  • With the current supabase-js SKD's you can only count rows with .match() method. But this will count occurrence of every row that matches the criteria—it won't group them (so you can't use aggregate functions on them after)
user_111011560
Related