Thank you! Do you know if functions/stored procedures protect against that when done through the dashboard?

yo! hey, does supabase somehow support custom data types?

i.e.

create type stat as (
  slug varchar,
  displayName varchar,
  base double precision,
  multipliers double precision
);

i mean, psql does support it - but is the GUI prepared for that? 🤔 i'm using it quite exhaustively

this is the table I'm trying to achieve:

base_rep: float8 | rep_multipliers: stat            | base_hp: float8 | hp_multipliers: stat       |
-----------------+----------------------------------+-----------------+----------------------------+
1                | [2, source_id, expires_at]       | 100             | [1, source_id, expires_at] |

context: am trying to build a small game using supabase 😄

Is there a result i could check when there is no more data to be pulled. I'm playing around with using infinite scroll loader i know about the

range()

option but i have no idea how to check whether there is additional data

I guess it's not relevant to supabase, it's just the logic how you handle the data. I use supabase with

useSWRInfinite

to handle infinite scroll. You can check my code. Hope this help you. https://github.com/trankhacvy/together/blob/8fe069627fba268b658b75c02665b1ef7f0e2da0/src/components/pages/home/Home.tsx#L10

I'm using something like https://www.npmjs.com/package/react-infinite-scroll-component For sure it's something about the code. I currently have something like

state = {
        items: null,
        hasMore: true
    }

    async fetchData(startIndex, endIndex)
    {
        let { data, error} = await supabaseClient.from("Udemy").select().gt("expirationTime", new Date().toISOString()).range(startIndex, endIndex);
        if (error)
        {
            console.log(error);
            throw error;
        }
        return data;
    }

    async fetchMoreData()
    {
        //Get current value in items. Consistently concatenate with 20 
        let newItems = await fetchData(items.length, items.length + 20);
        let concatenateItems = [...this.state.items, newItems]
        this.setState({
            items: concatenateItems
        })
    }

Still thinking out how to modify the

hasMore: true

gonna look at your code to see if i can adapt it 😆 thanks!

I think you can compare the

count

value with the current data length to determine

hasMore

https://supabase.io/docs/reference/javascript/select

Oh right that sounds good. The most it could do is one more "wasted" api calls

How user can recover password if user is authenticate with phone number?

@User @User @User please use the right channel to ask questions/help next time (#843999948717555735)

Hi there!!!

First time here

Ooops ps

🤢

can Someone help me with supabase and graphql

Sure, don't hesitate to ask help there -> #843999948717555735 :p

Thank you!

is there a function to use in order to calculate latency between supabase and my site? or should I just do a

.now

until the response is received?

I got this error when uploading a 120MB video to storage using supabase js:

{
  "statusCode": "413",
  "error": "Payload too large",
  "message": "The object exceeded the maximum allowed size"
}

but I can't find where to change the limit, somebody help?

Maybe it's a limit imposed by supabase?

well it sucks if it is, cause I have to switch to other storage provider and change a lot of things but I hope that is not the case 😅

oh it's in the FAQ What is the largest sized file I can deploy to storage? A big cat like a Lion or Siberian tiger, also Ligers are fine. If you are using the hosted platform there is a 50MB limit.

do database indexes appear anywhere on the supabase dashboard UI?

@User thx for checking out github chat! hopefully you and the rest of the team enjoy it 😄