S
Supabase2mo ago
Idris

Different max rows for service role

Hi, I have max rows set to 40 which is perfect for the client side. However my edge functions process pending notifications in batches of 1000. But is limited because service role is also limited to the max rows set. So far I worked around it by sending one row of json. But this is really bad DX, does supabase offer something for this besides direct postgres connection or this
1 Reply
garyaustin
garyaustin2mo ago
No. The JSON with all data from an rpc or view is about it.

Did you find this page helpful?