data module for database tables
data module was a great addition. have been using that pretty much everytime i can covert my data to csv.
but having database module to load data from one table would be just awesome.
Making backends for data bases is complex, as it covers a wide range of different databases and languages. A project like this would have to start with only a few of the most popular backends. We are currently considering a “connectivity” project that will do some of this.
Thanks for considering this module. Please let me know when its coded. I could really use this.
Well we are using mysql/python where I work and i am obviously writing code to slice and dice the rows to fit into highcharts JSON format.
But I don't think there are huge number of databases out there. If you work on the few major ones -- oracle,sql server, mysql and few languages -- java,c/c++,python,php -- you are pretty much done with 90% of the share.
Yes, I agree with all of this, but it all comes down to Pawel's question in the beginning of this thread. Which database, and which language. There's a huge diversity out there.
We have just released a beta for a Highcharts .NET wrapper, see http://www.highcharts.com/component/content/article/2-news/197-highcharts-net-wrapper.
Our plan is to continue building on this idea. Java and PHP would be obvious next steps, but again there are diversities.
You seem to have gathered a team to upvote this feature. What particular database/serverside integration are you looking for?
Thanks for your reply. Yes i understand databases live on the server. But so does CSV's. There are only handful of widely accepted databases on the planet ( Oracle, SQL server, MySQL) and handful of languages (java, variants of c, python). You should atleast write the wrapper for these and go from there.
You need to realize that you have built an excellent charting library, but the process of feeding data, is very cumbersome and requires a huge amount of development effort. You should do everything possible to make your product as much easily ingestible as possible.
Also , and i know i am stating the obvious, but most of the worlds data, resides in the databases. Whatever one wants to visualize, is sitting in a database table somewhere. If you want to make them write code to create 2 dimensional arrays for each series and points and axis, it will make more difficult to use your product fluently. Atleast whenever I think of creating a chart, its always the data ingestion process that makes it extremely difficult.
This feature would be very helpful. Thanks.
Came across this while working on my chart. This would be really awesome to have.
This will be very helpful.
Start with oracle/sqlserver/mysql with java,c++,python.
I am actually surprised this does not exist. You guys are building a data charting library and guess where does most of data live ?
Yes it would be really nice to have this. To finally be able to use the great charting library that you guys have.
the visualizer commented
We do lot of charting from data in database tables, especially from data returned from a SQL. I think you should start with charting a database table and then may be in next iteration chart results of a SQL query/. This would be a huge help.
I have been waiting for this ! i DONT want to work series by series, point by point, i just want to feed the data and forget about it.
This would be really beneficial. Ultimately all data is stored in databases. You should really make it easy for us to chart it without too much coding.
Greg Kemnitz commented
As far as which database is concerned you should work on the major players -- oracle, mysql, sql server and so forth. Same thing with language -- php, python , c++.
Greg Kemnitz commented
This is a great idea. We need to be able to visualize data inside a database table, or even taking it further the result of a SQL, as long as data is well structured. We are doing that right nw with copying the table data in an excel sheet and charting on top of it.
The language should be the one most commonly used in startups -- python, ruby and so forth. Python seems to be the clear winner.
Please Please implement this. I would definitely want MySQL as the first one, since people who use highcharts, often are startups. I personally am waiting for this module to buy highcharts licenses.
Paweł Fus commented
Which database would you like to use? And which language? I mean you can get data from various databases with many different languages. For example you can get data from PostgreSQL with .NET, PHP, Ruby etc.