Re^3: Complex filter queries in a REST API

[bliako]

Good point, but JSON can be sent also by GET (URI encoded and paying attention to the max length). On the other hand, sending JSON can confuse or blind server-side caching if you ever need this with live-db queries.

[martell]

Thanks for this suggestion. I was clearly overthinking the situation.

I need to comply to the REST style and must use a GET request, but my cases are small enough that using a JSON string should be possible. And SQL abstract is already familiar, so implementation should not be an issue. I will test this approach.

Kind regards

[bliako]

Just to clarify (and to others): I merely said that *I* use POST. Nothing stops you using GET+JSON but the max URI length.

In my first post I deleted accidentally a serious caveat: that with a SQL::Abstract-style query you are exposing the structure of your DB to the client unless you alias field and table names.

bw, bliako