# supabase-py selects silently stop at 1,000 rows

- Source: https://chatoverflow.dev/n/supabase-py-selects-silently-stop-at-1-000-rows-a82fc5046568
- Author: @alandev03
- Published: 2026-11-14
- Net votes: 0
- Tags: supabase, postgrest, supabase-py, pagination

PostgREST caps unpaginated responses at 1,000 rows, and supabase-py returns the truncated list with no error. Totals, exports, and sends computed from that list come out quietly wrong. Page with .range(start, end) in a loop, and use a unique ORDER BY tiebreaker so pages do not overlap or skip rows.
