Hi Cor and everybody,
well this is my first collaboration, as I have the time today...
Well, if you want to generate statistical charts so the user can have
an overview of the data, you could use simple HTML and GIFs, but this
would make your code impossible to maintain in a sort time. Course
you have specialized classes to do this, but or they are complicated
to use and customize or they can´t be customized at all... two years
ago I had the same problem for a HUGE ERP and CRM system, and the
cost of generating the charts on the server side would have make the
system unusable (We´ve tried, and it was impossible to have 25
persons accessing the statistical module at the same time).
Well, what a hell do I suggest? Client side! Let the user render de
chart, as we do with CSS and HTML, let the browser render it... How?
Well, After researching a lot, I found that FusionCharts (http://
www.infosoftglobal.com/FusionCharts/) is the most customizable and
flexible that exists. It uses XML as input that can be generated
easily within any scripting language as PHP, ASP, Perl, etc, and the
look-and-feel is also configured using XML, again easily generated.
And before anyone start pointing the fingers, I don´t have any
affiliation with InfoSoft Global in any shape or form, besides been a
happy client. :o)
Best Regards,
Bruno B B Magalhães
On Jan 16, 2007, at 11:43 AM, C.R.Vegelin wrote:
Thanks El Cuy, Joshua, Ryan,
Let me be more specific about making graphs with MySQL data.
Currently my project is in development phase,
using MS Access as front-end and MySQL as back-end with MyODBC.
My next step is to replace the MS Access front-end by PHP
(because I don't see any use of MS Access for a website).
However, I don't have any experience with PHP yet.
Before moving to PHP, I would like to test some chart possibilities,
with bar charts, line charts etc.
I am thinking of a charting engine as a "runtime component",
that makes charts depending on passed parameters, such as:
a) the result of a MySQL query or the query itself
b) parameters to specify the charttype, title etc.
Ryan wrote that MS Access/MyODBC could do it, but how ?
Joshua wrote that MS Excel (and OO Calc) could do it,
but then I have to instruct MS Excel how to chart per query ?
To give an idea of my chart needs:
http://www.ecb.int/stats/exchange/eurofxref/html/eurofxref-graph-
usd.en.html
Regards, Cor
----- Original Message ----- From: "El Cuy Volador"
<[EMAIL PROTECTED]>
To: "C.R.Vegelin" <[EMAIL PROTECTED]>; <mysql@lists.mysql.com>
Sent: Saturday, January 13, 2007 1:29 AM
Subject: Re: making graphs with MySQL data
C.R.Vegelin escribió:
Dear List,
I have a MySQL database (V5.0.x) and I need to make graphs.
Does anyone know about good utilities to make graphs ?
I would appreciate your expertise or links.
TIA, Cor
A very good one is BIRT (http://www.eclipse.org/birt/phoenix/) to be
deployed in a Tomcat or any other Java server. You can see some
tutorials and video tutorials in the examples section of the page.
Very
easy to use.
If you are using PHP, an option is jpgraph
(http://www.aditus.nu/*jpgraph*/). Not very complete, and quite
difficult to deploy.
A commercial solution is Fusion Charts
(http://www.infosoftglobal.com/FusionCharts/).
Try to be a little bit more explicit about the language you are using
ant the kind of graphs you need to generate.
Hope this links help you,
Regards,
Alvaro
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
