Is the Client return capped?

[fangmarks]

I'm trying to get the amount of how many entries in my image table have a specific folder.

In the SQL Editor I get 6100 using this Query

SELECT COUNT(*) from images where folder = 'wolves' 

but when I use supabase.from<Image>('images').select().filter('folder', 'eq', 'wolves') and then data.length in my code, it doesn't get more than 1000.

So my question is, is the amount of entries you get capped?

[fangmarks]

managed to get the actual count by changing my select function to select("*", {count:"exact"})

[fangmarks]

Still a bit bad though, since I don't think I can get all the IDs of the rows though?

[steve-chavez]

Yes, there's a max of 1000 rows. You can change it on /settings/api -> MAX ROWS.

[fangmarks]

Thanks!