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

Supabase

Guys please can you help me. I posted the question on <#869410418567831602>  channel

hello, do you know if i can get a random object during the request ? right now my request get an array of all the object in the table, and after i just generate a random number between 1 and the length of the Array and only show the object where id = the random number

Why not get a count of the table and then do your random number generator and only get the id you choose randomly? Guessing you're worried about payload size

```async function getRandomQuote() {
  try {
    const { data, count } = await supabase
      .from<definitions['quotes']>('quotes')
      .select(`
        quote,
        songs (
          listen_url,
          title,
          albums (
            cover_url,
            name
          )
        )
      `, { count: 'exact'}) 

    const randomQuoteId = getRandomId(0, count!)
    return data![randomQuoteId]
  }
  catch(error) {
    console.error(error)
    return error
  };
}

function getRandomId(min: number, max: number){
  return Math.floor(Math.random()*(max-min+1)+min)
}

export default getRandomQuote
```

that is what i do, in fact i don't have a lot of data so i don't think it's an issue for now i just try to optimize the way to do it

U can try adding order by random() in request. If that doesn't work, then please create a function that does this query from postgres procedure functions

supabase.from(..).select(...).order("random()")

https://stackoverflow.com/a/14450321/1627904

This is an example of why I dislike the Discord platform as a place to ask for help, this was answered yesterday by someone else and now that thread is gone, so the same question has to be answered again today.

oh too bad thread just stay 24hours on free plan, i just arrived today on the discord do you remember who answered or who asked so i could i ask him, thanks

I don't actually, I was just looking for the thread and noticed its gone

The best place to ask these sort of question is on the Supabase GitHub discussion, I just found similar question answered there just now https://github.com/supabase/supabase/discussions/2299

Thanks i will look there, didn't know about github discussions

it just means there's a lot thats subject to change

how do people generally handle the casing of responses from Supabase to their frontend apps? Supabase of course returns data in camel_case, and it's generally preferred to use snakeCase on the frontend. Are you all creating your own converters? Is there a library you're using to handle this? One thing I like about NestJS (obviously that's an ORM and Supabase isn't), is that you can utilize a `@mapResult()` helper to fix this.

I just realized that I totally got this backwards. Supabase of course returns data snake_case, and frontend generally prefers keys in camelCase. Anyways, question still stands!

hello does supabase has cloud functions? i need CF for sending email with pdf

Not at the moment, also please check out the supabase website and blog for features that are available.

Not yet, but check out https://supabase.io/blog/2021/07/30/supabase-functions-updates

There's still no way get some sort of UI for a self-hosted Supabase instance is there correct?

awesome, so it will be exists but on progress 😍

Hello friends, does anyone know where to find examples of complex queries? Like matching values from another table?

But if you mean the "native" one, it's not available yet

Yeah, the native one, I have pgadmin for the database but might switch to self-hosting soon but am mainly holding back because of the website UI for other things

Is there documentation on how to send a node js fetch request to create a record in supabase?

How can I store IP address when an user logged in?

It seems that supabase doesn't support to tracking user session. For example getting ip address from user, verify captcha. It will be a problem if an attacker using signUp endpoint and send many requests for creating new users

could you move these questions to the <#843999948717555735> channel please

can you move this to <#843999948717555735> or <#869406062036529193> please

bro did you upload profile image using supabase, is there a documentation about uploading and fetching?

i have a question in <#843999948717555735> 🙂

```json
{
  "statusCode": "404",
  "error":"Not found",
  "message":"The resource was not found"
}
```

Supabase is just taking some time after a new directory is created

I need to refresh the page for some reason