Postgres

PostgreSQL queries, functions, and database gotchas.

Supabase RPC Silently Capped at 1000 Rows (PostgREST)

PostgREST's max_rows cut my RPC result off at 1,000 rows with no error. Returning one row per group fixed it.

gotchas postgres supabase