News for hackers. Stuff that matters.
Re:Show HN: SQueaLy – Fast track analytics for business by mclemme on Thursday May 11, 2017 @08:06AM (#14315400)
I'm working on something a bit similar, it's generating around 200 different recurring reports at the moment.

Did you do anything to make it work with large datasets? Is the web-frontend still responsive if a query returns 1 million rows for example?

Re:Show HN: SQueaLy – Fast track analytics for business by swapnil95 on Thursday May 11, 2017 @08:11AM (#14315423)
On the web frontend, we paginate the reports and so it is supposed to be responsive with large datasets. We tested this with around 10K rows, we'll surely scale-up our tests for this.

BTW which charting library are you using for your reports?

Re:Show HN: SQueaLy – Fast track analytics for business by mclemme on Thursday May 11, 2017 @08:31AM (#14315516)
On the few places in the frontend where charts are use I am using chart.js, which I'm happy with so far.

Most of the recurring reports simply spits out excel or csv files with no graphs.

Re:Show HN: SQueaLy – Fast track analytics for business by nrjames on Thursday May 11, 2017 @10:30AM (#14316256)
I'm also doing something similar and using c3.js for charts.
Re:Show HN: SQueaLy – Fast track analytics for business by no1youknowz on Thursday May 11, 2017 @08:17AM (#14315455)
Can you post your project?
Re:Show HN: SQueaLy – Fast track analytics for business by mclemme on Thursday May 11, 2017 @08:37AM (#14315540)
You mean the source? I am not in a position to post the source, it's a product I'm developing with one client (who has it running) and another prospective client.

We haven't had time to make a marketing/demo site for it yet, sales has been through networking so far.