News for hackers. Stuff that matters.

A comment on Ask HN: How to run queries on 20B clicks log.

Re:Ask HN: How to run queries on 20B clicks log by o1lab on Friday November 10, 2017 @04:59PM (#15673408)
You mention about making it available to customers - are you looking for APIs ?

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.

[ Parent | on HN ]
Re:Ask HN: How to run queries on 20B clicks log by andrewgrowles on Sunday November 12, 2017 @10:05AM (#15681078)
This is not going to perform well with this amount of data. HTTP Response times for queries are likely to timeout. Needs a job-based queue.
[ Parent | on HN ]