postgrest-js
postgrest-js copied to clipboard
supabase
`URI too long` error when supplying a sufficiently large filter
Bug report
Describe the bug
GET request fails on large queries
To Reproduce
async function getData(table: string, objectIds: string[], limit: number): Promise<Object[]> {
const data = await supabase.from(table).select('*').limit(limit).in('id', objectIds)
return data
}
Run with more than ~10-15 object IDs and it fails because the URL becomes too long for a GET request.
Expected behavior
If the URL exceeds a certain length, this should be submitted as a POST request instead, with the IDs in the body of the request
Linking https://github.com/PostgREST/postgrest/issues/2125.
If the URL exceeds a certain length, this should be submitted as a POST request instead, with the IDs in the body of the request
Planning to use the HTTP SEARCH method instead.
For now you can workaround this with rpc() as described here, example here.
I have the same issue.
const response = await supabase
.from('team_profile')
.select('id, team_id, profile!inner( identifier )')
.in('profile.identifier', identifiers)
.eq('team_id', teamId);
if identifiers are too many, or if they are too long, this will triggers Error: URI too long.
Because this code generate a get request, and it exceeds the maximum URI Length accepted by the server.
Same here, I have to batch my updates in order to avoid this issue which is pretty annoying.
Issue happening over here on Flutter also when querying more than 200 GUIDs using IN filter.
const response = await supabase
.from('products')
.select('*, supplier(*)')
.not('id', 'in', excludingIds)
....
As a side-problem, with RPC (without the Supabase magic) can't seem to find a way to easily obtain joined tables (e.g. supplier) like we do with .select('*, supplier(*)'). If you have any suggestions on how this is done without breaking the standard let me know.
Would like to receive an update on this as it is quite annoying not having the code in one place. Thank you.
@rovercoder If your RPC is defined as CREATE FUNCTION func ... RETURNS SETOF PRODUCTS then you can use rpc(func).select('*, supplier(*)'), the same as for tables.
I have the same issue. Is it possible to do a normal select query as a POST request?
Using an RPC method is not an option in our case because we're building our query dynamically based on some conditions and writing the whole logic as a Postgres function isn't a viable option.
This seems like a high priority bug to fix. I'm doing a filter on some data and want to do it via Supabase (or rather, in SQL, as opposed to JavaScript, for performance reasons). It should be possible to fallback to a different format and not be limited by URI length.
EDIT: It's not necessarily a bug, but it is something you'd expect to work without hiccup.
