o1lab

https://github.com/o1lab/xmysql - one command to generate rest api for any mysql database in seconds. (shameless plug - something i've been workng on)

This supports grouping, count and where as query params of api. I'll be happy to help - pls raise an issue if you get stuck. Thank you.

  xmysql now supports 
  + group by
  + group by, order by
  + aggregate
  + single file upload, multiple file upload and download file
  + where clause on list of resource
  + where clause on list of nested resource

  > xmysql now supports
  + where clause on list of resource
  + where clause on list of nested resource

  xmysql now supports
  + group by
  + group by, order by
  + aggregate
  + single file upload, multiple file upload and download file

parameters with underscore: I'd imagined to 've 'where' parameters in query fields like ?columnName=columnValue. Hence started with underscore - however I dropped where clause as I was soon sure that I was only covering small group within where clause and operators.

abbreviation of page to _p - I think I picked up that from hackernews where paging query parameter is p :).

fields: second one seems easy to use - I think I borrowed it from google youtube apis. They have concept of id,snippet etc which is higher level of abstracting ids, primary-info (respectively) in response

sort: may be I extended the concept of fields to sort. Since sort can 've only two directions.

Kibana and superset look awesome. I'll have a look at them.