I suggest you ...

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.

118 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
tarun shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
under review  ·  AdminTorstein Hønsi (CPO, Founder, Highcharts JS) responded  · 

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.

18 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • tarun commented  ·   ·  Flag as inappropriate

    Thanks for considering this module. Please let me know when its coded. I could really use this.

  • tarun commented  ·   ·  Flag as inappropriate

    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.

  • AdminTorstein Hønsi (CPO, Founder, Highcharts JS) commented  ·   ·  Flag as inappropriate

    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?

  • tarun commented  ·   ·  Flag as inappropriate

    Torstein,

    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.

  • samj commented  ·   ·  Flag as inappropriate

    Came across this while working on my chart. This would be really awesome to have.

  • todd commented  ·   ·  Flag as inappropriate

    This will be very helpful.
    Start with oracle/sqlserver/mysql with java,c++,python.

  • arnie commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    Oh this would be wonderful to have. No playing around with data and javascript arrays and what not.

  • vikram commented  ·   ·  Flag as inappropriate

    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.

  • chris commented  ·   ·  Flag as inappropriate

    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.

  • naval commented  ·   ·  Flag as inappropriate

    Awesome. Dont know how much javascript arrays have i played with to massage the data to fit into a JSON accepted by highcharts.

  • dave commented  ·   ·  Flag as inappropriate

    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.

    thanks
    dave

  • Greg Kemnitz commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

  • tarun commented  ·   ·  Flag as inappropriate

    The language should be the one most commonly used in startups -- python, ruby and so forth. Python seems to be the clear winner.

  • tarun commented  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base