S
Supabase•3y ago
Vengeance

URI Too Long

I for the life of me can't figure out why I'm getting URI too long when trying this query. I have it run in batches of 100, and suddenly, for whatever reason, sometimes it will throw this uri error. Even if I set it to one address, it still responds with that error. The address is never more than 42 characters, and most of the time the logo I'm looking for isn't even in my db. Any idea what is going on?
No description
3 Replies
garyaustin
garyaustin•3y ago
The http protocol has a limit (around 2k) on the length of the URL. .select() uses GET and so all of your .in() parameters are in the URL. You will have to break it up, or use an rpc call which uses POST and the parameters go in the body.
Vengeance
VengeanceOP•3y ago
You will have to break it up
Oh my god I wasn't specifying to use the chunk 🤣
No description
Vengeance
VengeanceOP•3y ago
The http protocol has a limit (around 2k) on the length of the URL. .select() uses GET rpc call which uses POST and the parameters go in the body
This is good to know, thank you :D

Did you find this page helpful?