News for hackers. Stuff that matters.
Re:ChartSQL: Create Charts and Dashboards from SQL by sida on Saturday November 15, 2014 @11:21PM (#8613433)
Chart.io et al are awesome. But all of them are extremely expensive. Chart.io for example starts at $1000 per month and periscope.io starts at $300 per month.

It is frankly not very affordable for a bootstrapped startup.

My questions are how easy is it to host this thing. (It would be perfect if someone makes a deploy to heroku button so that we can just do this in one click)

Re:ChartSQL: Create Charts and Dashboards from SQL by rrggrr on Sunday November 16, 2014 @12:46AM (#8613545)
Chart.io was too expensive and we bailed on it, but not before we tried to negotiate a discount to no avail. Chart.io pricing model would benefit from more flexibility and options.
Re:ChartSQL: Create Charts and Dashboards from SQL by rgrieselhuber on Sunday November 16, 2014 @08:29AM (#8614162)
As someone who sells a product in a similar price range, your point is understandable but quite difficult to cater to from a vendor's perspective. Both Chartio and our product involve spending some time with the customer up front in order to really make it work for them. A lower price point plus monthly contracts plus churn as a result of finicky customers is the mark of death for SaaS startups.
Re:ChartSQL: Create Charts and Dashboards from SQL by rrggrr on Sunday November 16, 2014 @05:08PM (#8615656)
The problem is one size company fits all pricing. Small business who can benefit the most from SAAS (and have the least regulatory/bureaucratic resistance) can't justify enterprise or middle-market pricing. And the valuation/exit strategy for most SAAS offerings is quantity of users, not profitability - like it or not. I predict either Chart.io changes pricing or its market share is eroded by FOSS and cheaper alternatives like: http://idl.cs.washington.edu/projects/lyra/
Re:ChartSQL: Create Charts and Dashboards from SQL by rgrieselhuber on Sunday November 16, 2014 @08:32PM (#8616374)
> And the valuation/exit strategy for most SAAS offerings is quantity of users, not profitability - like it or not.

That's not true at all.

SaaS companies are valued on recurring revenue, lifetime value, retention and future cash flow. Number of users is almost irrelevant as long as those metrics are moving up and to the right to a healthy degree.

Chart.io has already changed their pricing once and I share your prediction that they will change it again: to charge even more. And grow further as a result.

SMBs are a tough market for SaaS companies with a product that has any complexity whatsoever, both in terms of usage and distribution.

Re:ChartSQL: Create Charts and Dashboards from SQL by rrggrr on Sunday November 16, 2014 @11:57PM (#8616909)
Lets meet again in a year. SAAS is a falling knife. I bet 20 Satoshi on it.
Re:ChartSQL: Create Charts and Dashboards from SQL by rgrieselhuber on Monday November 17, 2014 @03:09AM (#8617299)
Been at it for 4 years already and SaaS wasn't always this hot.

Edit: what exactly are you wagering on?

Re:ChartSQL: Create Charts and Dashboards from SQL by atmosx on Sunday November 16, 2014 @04:52AM (#8613839)
Does Chartkick (highcharts) and other open source libraries not support your use cases?!
Re:ChartSQL: Create Charts and Dashboards from SQL by radicalbyte on Sunday November 16, 2014 @06:12AM (#8613969)
That's because it's targeted at the Enterprise, where it's not uncommon to pay $100-$200k in yearly licensing for comparable software.
Re:ChartSQL: Create Charts and Dashboards from SQL by cmelbye on Sunday November 16, 2014 @01:53PM (#8615027)
The point is, there's obviously demand for this from companies that won't pay thousands/month for it, so it's a question of who will build it for them.
Re:ChartSQL: Create Charts and Dashboards from SQL by ChikkaChiChi on Sunday November 16, 2014 @12:24PM (#8614751)
That doesn't make it right.
Re:ChartSQL: Create Charts and Dashboards from SQL by infinite8s on Sunday November 16, 2014 @03:43PM (#8615363)
How does that make it wrong? Obviously people are willing to pay that much for those solutions, otherwise they would lower their prices.
Re:ChartSQL: Create Charts and Dashboards from SQL by cerberusss on Tuesday November 18, 2014 @01:29AM (#8622680)
If you're in the GNU/free software camp, it's wrong to charge for closed-source software. Perhaps that's what your OP ment?
Re:ChartSQL: Create Charts and Dashboards from SQL by palmeida on Sunday November 16, 2014 @09:09AM (#8614220)
I am working on a similar product Viur http://www.viur.pt with a very flexible pricing targeted to startups, small and mid-size businesses. Our private beta is going live for our subscribers in the next few weeks.
Re:ChartSQL: Create Charts and Dashboards from SQL by whouweling on Sunday November 16, 2014 @04:49AM (#8613831)
I'm currently working on a similar (hopefully more simple and cheaper) product MetricBoard (direct demo: https://metricboard.io/webui/demo)

Although this currently only let's you push metrics via the API or upload a CSV. I personally would not be comfortable having a 3th party connecting directly to my database.

The product is still in development but I would love to get some first feedback / user testing.

Re:ChartSQL: Create Charts and Dashboards from SQL by sida on Sunday November 16, 2014 @01:27AM (#8613596)
Upon second look I believe I misunderstood the purpose of the project.

I initially thought the project was a subtitute for chart.io. However, it seems like the project is about "collect and visualize data".

It is not to visual data by connecting to your own database. Rather it allows you to import data from an mysql database

Re:ChartSQL: Create Charts and Dashboards from SQL by timmclean on Sunday November 16, 2014 @02:19AM (#8613656)
In case this is helpful: I interned at a company, Polychart, where we built a product similar to chart.io that is now open source and can be self-hosted: https://www.polychart.com/
Re:ChartSQL: Create Charts and Dashboards from SQL by pca2 on Sunday November 16, 2014 @11:22AM (#8614556)
Looks neat. However it appears to actually only support MySQL, despite it's website's claims
Re:ChartSQL: Create Charts and Dashboards from SQL by bjelkeman-again on Monday November 17, 2014 @01:57AM (#8617169)
Maybe we need to help them get wider support then.
Re:ChartSQL: Create Charts and Dashboards from SQL by danmaz74 on Sunday November 16, 2014 @03:00AM (#8613704)
Looks really interesting. Have you got any idea why they open sourced it?
Re:ChartSQL: Create Charts and Dashboards from SQL by bjelkeman-again on Sunday November 16, 2014 @10:00AM (#8614311)
Thanks. Just what I needed.
Re:ChartSQL: Create Charts and Dashboards from SQL by paulasmuth on Sunday November 16, 2014 @12:06PM (#8614702)
You didn't mistunderstand the purpose (However it's not an explicit goal of FnordMetric to substitute chart.io)

Here is an example that connects to a MySQL database on localhost: https://github.com/paulasmuth/fnordmetric/blob/master/fnordm...

Note that the IMPORT statement might be a bit misleading. The IMPORT statement only creates a "virtual table", it doesn't actually copy any data. As much of the query as possible is pushed down into MySQL/the external data source and the charts will be generated from the query result that is returned by the external data source.

Re:ChartSQL: Create Charts and Dashboards from SQL by paulasmuth on Saturday November 15, 2014 @11:30PM (#8613442)
A "deploy to GCE" button is something I am planning to add in the next weeks.
Re:ChartSQL: Create Charts and Dashboards from SQL by ams6110 on Sunday November 16, 2014 @11:18AM (#8614541)
It's generally not very difficult to get SQL query results in JSON rather than tabular format and then feed that to your favorite charting tools.
Re:ChartSQL: Create Charts and Dashboards from SQL by paulasmuth on Sunday November 16, 2014 @11:22AM (#8614557)
However that means you have to write a heap of reptitive glue code (or sed incantations if that's your thing) to mangle your SQL Results into the JSON format your charting tool wants. If you run a lot of ad-hoc queries you have to waste a significant amount of time on this boring legwork that could much better be spent on interesting tasks.

FnordMetric aims to fix that by extending standard SQL; it allows you to express the data query and the chart specification in a coherent fashion (SQL).