Building data/statistical graphs from postgres data?

Question

I have a single table which stores bandwidth usage on the network over a period of time. One column will contain the date time (primary key) the bandwidth is recorded and the other column will contain that actual bandwidth value.

I need to generate some graphs (pie charts, bar graphs etc) and other statistical graphs from this data. However, I would like to do generation of the data on the database server rather than return all the data to the client for it to process and generate the graph.

My question is are there any libraries or techniques which help do this in Postgres?

solaimuruganv · Accepted Answer · 2012-09-27 12:37:45Z

2

this can be achieved by R and PL/R graphical development packages.

refer

answered Sep 27, 2012 at 12:37

solaimuruganv

30.3k1 gold badge22 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Erwin Brandstetter Over a year ago

At the time being PL/R does not seem to be ready for PostgreSQL 9.2. Should work with 9.1 or earlier, though.

JD. Over a year ago

I don't need the generation of the graphs as my client (flex or silverlight) will render the graph. Can I still use PL/R or do I have to write the queries myself?

Collectives™ on Stack Overflow

Building data/statistical graphs from postgres data?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related