Easiest, Fastest way to charting bind to SQL db

General
1

hello, i am new to XOJO, i didnt see any built in charting module with XOJO, sorry if it exists, if not could you point me to the fastest easiest way to display charts in a XOJO Web App driven by a sql type db (SQLite, mySQL, etc)

thanks

2

LOL… sorry…
I am currently in the process of finishing a comprehensive Chart Module for my Tadpole SQLite manager.
It will allow you to write a simple script within Tadpole to produce very nice

  • LINE CHARTS
  • SCATTER CHARTS
  • PIE CHARTS
  • BAR CHARTS
    with control of most aspects of the chart… including reference lines, and range bands

here is an example (one of my test scripts]

GRAPH Type=line Table=glucose_graph 

TITLE 'Glucose Readings' Color=#000000 Font=system Size=24 
SUBTITLE 'R.David S' Size=36 
FOOTNOTE 'data collected from DS_Lockbox' Color=#ff7733 Font=arial Size=36 
LEGEND Pos=left Size=16 Width=80 

PLOTYBAND Color=orange Opacity=20 From=140 To=240 
PLOTYBAND Color=green Opacity=20 From=100 To=140 
PLOTLINE Color=red Value=140 

XAXIS 'Date Range' Color=blue Font=arial Size=16 
YAXIS 'mm/dl' Color=red Font=menlo Size=16 

XGRID Style=dotted Color=orange Minor=4 
YGRID Style=solid Color=gray Minor=1 

SYMBOL Color=red Width=2 Marker=+ Style=dot Size=3 
SYMBOL Color=green Width=2 Marker=o Style=dot Size=3 
SYMBOL Color=blue Width=2 Marker=x Style=dot Size=3 

SERIES kind 
XVALUE reading_dt mdy 
YVALUE datapoint 

END GRAPH

NOTE : this is not a stand-alone graph module… but I am considering making it one later

3

There is ChartPart (OSS), ChartDirector (From MonkeyBread) and others. If you look at the 3rd party products page, there are others.