SEO

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

C.R.Vegelin wrote:
> 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
>

Perl with GD? MS Access/MyODBC could do it too. You may have to be
more specific.

-Ryan

On Friday 12 January 2007 12:51, C.R.Vegelin wrote:
> 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.

If you're using Python, matplotlib is an excellent package. If you want
something fully graphical, you can connect MS Excel (and OO Calc) to backend
databases and query data.

j

--
Joshua Kugler
Lead System Admin -- Senior Programmer
http://www.eeinternet.com
PGP Key: http://pgp.mit.edu/ ID 0xDB26D7CE
PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111

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

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/eu...ph-usd.en.html

Regards, Cor



----- Original Message -----
From: "El Cuy Volador" <cybercuy@gmail.com>
To: "C.R.Vegelin" <cr.vegelin@hetnet.nl>; <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
>
>

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. )

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/eu...rofxref-graph-
> usd.en.html
>
> Regards, Cor
>
>
>
> ----- Original Message ----- From: "El Cuy Volador"
> <cybercuy@gmail.com>
> To: "C.R.Vegelin" <cr.vegelin@hetnet.nl>; <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?
> unsub=brunobbmagalhaes@terra.com.br
>
>

Hi Cor,

Fusion Charts is Flash based... For example, if you need a bar chart
you just need to embed the file Bar2D.swf and send an XML to it using
params, or even a external url, but if you need a pie chart just use
the Pie2D.swf file instead... So the user just needs to have Flash
plugin installed, nothing more nothing less. And just to remember,
flash is now present on 99.6% of the world´s computers.

Take a look at their site, and specially on demo section.

Best Regards,
Bruno B B Magalhães

On Jan 16, 2007, at 2:08 PM, C.R.Vegelin wrote:

> Hi Bruno,
>
> Thanks a lot !! I feel very comfortable with your advice,
> because I prefer performance, maintainability, flexibility
> and connectivity with PHP, ASP, Perl a.o.
>
> But does your advice for client side means that clients
> need to have FusionCharts on their PC's ?
>
> Best regards, Cor
>
> ----- Original Message ----- From: "Bruno B B Magalhães"
> <brunobbmagalhaes@terra.com.br>
> To: "C.R.Vegelin" <cr.vegelin@hetnet.nl>
> Sent: Tuesday, January 16, 2007 1:02 PM
> Subject: Re: making graphs with MySQL data
>
>
> 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. )
>
> 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/eu...rofxref-graph-
>> usd.en.html
>>
>> Regards, Cor
>>
>>
>>
>> ----- Original Message ----- From: "El Cuy Volador"
>> <cybercuy@gmail.com>
>> To: "C.R.Vegelin" <cr.vegelin@hetnet.nl>; <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?
>> unsub=brunobbmagalhaes@terra.com.br
>>
>>
>
>
>
>