<div>Other than gnuplot, you can always use libraries for your favorite language. For me that'd be Python, so each time I need to graph such thing from an SQL, I connect to my SQL via some library (or directly export it?) and then plot it via matplotlib.<br>
</div><div><br></div><div>So I basically agree with Simon, RRDtool isn't the tool for your needs in this case.</div><br><div class="gmail_quote">On Fri, Feb 10, 2012 at 12:01 AM, Simon Hobson <span dir="ltr"><<a href="mailto:linux@thehobsons.co.uk">linux@thehobsons.co.uk</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">lcsmdq wrote:<br>
<br>
>Hi, im novice in RRDtool; i want to graph some information quantity/time from<br>
>a SQL view. in thats graphs i'll see per hour/day/month/year like historical<br>
>info. which is the best front-end to do that???<br>
<br>
</div>RRD is (probably) not the tool for your needs. RRD is both a set of<br>
tools and a specific database format (the Round Robin Database). The<br>
database is specifically designed for the type of tasks it was<br>
originally written to, and obviously the front end tools are designed<br>
to work with it.<br>
<br>
The only way to graph your SQL data with RRD would be to export the<br>
data, import it into an RRD file, and then graph it. After that,<br>
you'd need to either start from scratch each time, or figure a way to<br>
export only new data for import into the RRD file.<br>
Note that RRD does not support "random access" for updates - updates<br>
can only ever move forwards in time. Ie, your updates must always be<br>
in ascending cronological sequence irrespective of where the data<br>
comes from.<br>
<br>
You can however add historical data - provided you start with the<br>
earliest data and work forwards.<br>
<br>
If you want to graph direct from your SQL data, then there are other<br>
tools available - GNUPlot comes to mind but I've never used it myself.<br>
<span class="HOEnZb"><font color="#888888">--<br>
Simon Hobson<br>
<br>
Visit <a href="http://www.magpiesnestpublishing.co.uk/" target="_blank">http://www.magpiesnestpublishing.co.uk/</a> for books by acclaimed<br>
author Gladys Hobson. Novels - poetry - short stories - ideal as<br>
Christmas stocking fillers. Some available as e-books.<br>
</font></span><div class="HOEnZb"><div class="h5"><br>
_______________________________________________<br>
rrd-users mailing list<br>
<a href="mailto:rrd-users@lists.oetiker.ch">rrd-users@lists.oetiker.ch</a><br>
<a href="https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users" target="_blank">https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>M. EMRE AYDIN<br><a href="mailto:emraydin@gmail.com">emraydin@gmail.com</a><br>