Forum Stats

  • 3,872,571 Users
  • 2,266,444 Discussions


Create a timeseries chart

VePuli-Oracle Member Posts: 22 Employee
edited Aug 1, 2016 10:36PM in Node.js

Any example on how to plot a chart based on data from sql ?


  • Christopher Jones-Oracle
    Christopher Jones-Oracle Member Posts: 1,656 Employee
    edited Aug 1, 2016 10:36PM

    Plotting is generally done in the browser, so Node is only used as a web service to return data in a consumable format (e.g. JSON).  I've had fun using d3.js and rickshaw for plotting.  The Node considerations are to make sure that unnecessary browser page refreshes (ie queries) are eliminated (to reduce system load).  Use a session pool in node-oracledb.  Depending on your data requirements, look at using Oracle Database's JSON datatype support.