Re: [Help-glpk] Mathprog > SQLite/MySQL > GNUPlot - (Graphing LP and MIP results)

[Nigel Galloway]

Last time this came up you rejected Excel due to having too much data for a 
spreadsheet. I have since created an Excel spreadsheet with two 1.5 million 
datasets and plotted them in various combinations and graph types. Changing the 
graph took about 7.5 secs. It is essential to use keybord commands to navigate 
the changes as any mouse drag and drop did take far too long. I agree with you 
that this is not a sensible use of spreadsheets, but Excel can use data in a 
database as a datasource. You won't get better graphs.

Another tool I use is qtiplot. Among the graph types that can be selected here 
are vector graphs (those graphs of little arrows which look like compasses in a 
magnetic field). You can choose other types, but the graphs are not as good as 
those produced by Excel.

If this is a business problem requiring a business solution then that solution 
is probably Crystal Reports. Crystal Report is a Reporting Application that can 
generate reports from various Data Sources like Databases , XML files etc. 

Sadly the output from glpk is not XML, but I have a program written in Ruby 
that converts csv to XML. Or it did, perhaps it will need changing for the 
modified glpk csv format.

See for my dreams come true:
http://www.threedgraphics.com/tdg/enterprise/sap/crce/?gclid=CO3zso-kmKICFRM_lAodyGQpXg

and note:
Change chart properties dynamically at runtime 

> ----- Original Message -----
> From: Noli Sicad <address@hidden>
> To: "address@hidden" <address@hidden>
> Subject: [Help-glpk] Mathprog > SQLite/MySQL > GNUPlot - (Graphing LP and     
> MIP results)
> Date: Fri, 11 Jun 2010 12:59:31 +1000
> 
> 
> Hi,
> 
> I have trying to find easy way to render business graphs from my
> MathProg MIP and LP results. R package works quite well but you have
> to prepare the in advance what sort of graphs to you like to have.
> 
> What really we need is dynamic graphing compatibilities similar  to
> ILOG ODM studio.
> 
> I think lately gnuplot supports SQL statement, if I am not mistaken.
> 
> Anyway, here what I found below
> 
> Generating Graphs with gnuplot, Part 3 Sqlite3
> http://www.linux.com/news/software/developer/26873:generating-graphs-with-gnuplot-part-3%3E
> 
> GNUplot from sqlite3 using plot special-filename
> http://schwehr.org/blog/archives/2009-05.html
> 
> Using GNUPlot to chart MySQL data
> http://www.krazyworks.com/using-gnuplot-to-chart-mysql-data/
> 
> Or anybody doing this already?
> 
> Noli
> 
> _______________________________________________
> Help-glpk mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/help-glpk

>


-- 
_______________________________________________
Surf the Web in a faster, safer and easier way:
Download Opera 9 at http://www.opera.com