[rrd-users] Generate graphs without a RRD?

[Simon Hobson]

Carsten Aulbert wrote:

>(2) Since the whole thing will be part of a interactive set-up (where
>people can access different time spans, zoom in etc), is it feasible to
>create a temporary RRD, fill it with data and then create the graphs if
>(1) is not be possible?


Yes, all you need to do is create a basic rrd file that covers the 
time period the user requests, and fill it with data from your 
database.

- create rrd file, see docs
- extract data from sql database, write query
- insert into rrd file, see docs again
- draw graph, see docs
- delete rrd file, "rm ${tempfile}"

All you need to do is write a script that works out suitable start & 
end time and performs the steps above.