Re: [GENERAL] Postgres and GnuPlot

2005-05-09 Thread Ben
For the sake of the archives, I just found out that my problem was that: echo -e "Content-type: image/png\n\n"; ...actually throws in 3 newlines, not two. (Doh!) Fixing that means I now have a CGI that generates gnuplots from postgres entirely in the pipeline, withouut any annoying temp files. p

Re: [GENERAL] Postgres and GnuPlot

2005-05-09 Thread Ben
Well, there is this: http://www.varlena.com/varlena/GeneralBits/Tidbits/bernier/art_66/graphingWithR.html I thought it was overkill for me, so I went with the gnuplot method. On Mon, 9 May 2005, Hrishikesh Deshmukh wrote: > H..looks like i simply can't send the query results to gnuplot

Re: [GENERAL] Postgres and GnuPlot

2005-05-09 Thread Sean Davis
gresql-General" Sent: Monday, May 09, 2005 11:40 AM Subject: Re: [GENERAL] Postgres and GnuPlot H..looks like i simply can't send the query results to gnuplot without an intermediary!! So far my search results have not yielded anythingi guess intermediary is the only way to

Re: [GENERAL] Postgres and GnuPlot

2005-05-09 Thread Mila Boldareva
Has anybody tried using gnuplot to plot results from queries; there are some suggestions given in PostgreSQL Developer's Handbook but i have not any luck so far! Any pointers as how to send results from queries straight to a simple plotting utility (ex:gnuplot)! I use a text file as an intermed

Re: [GENERAL] Postgres and GnuPlot

2005-05-09 Thread Mila Boldareva
> Has anybody tried using gnuplot to plot results from queries; there > are some suggestions given in PostgreSQL Developer's Handbook but i > have not any luck so far! > Any pointers as how to send results from queries straight to a simple > plotting utility (ex:gnuplot)! I use a text file as an i

Re: [GENERAL] Postgres and GnuPlot

2005-05-09 Thread Hrishikesh Deshmukh
H..looks like i simply can't send the query results to gnuplot without an intermediary!! So far my search results have not yielded anythingi guess intermediary is the only way to !! :((( Hrishi On 5/9/05, Ben <[EMAIL PROTECTED]> wrote: > Heh. Funny you should ask; I spent a fair amoun

Re: [GENERAL] Postgres and GnuPlot

2005-05-09 Thread Ben
Heh. Funny you should ask; I spent a fair amount of time yesterday doing precisely this. Here's my gnuplot file: set terminal png small color picsize 1000 400 set style fill solid 1.0 border set title "Concurrent listeners" set xdata time set xlabel "Time" set ylabel "Cuncurrent Logged In Listen

[GENERAL] Postgres and GnuPlot

2005-05-09 Thread Hrishikesh Deshmukh
Hi All, Has anybody tried using gnuplot to plot results from queries; there are some suggestions given in PostgreSQL Developer's Handbook but i have not any luck so far! Any pointers as how to send results from queries straight to a simple plotting utility (ex:gnuplot)! Thanks, Hrishi --