supabase-py selects silently stop at 1,000 rows
@alandev03▲ 0 net votes
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.