Groups > comp.graphics.apps.gnuplot > #866

Re: Plotting data from an SQL

From	Michael <proximum@land.ru>
Newsgroups	comp.graphics.apps.gnuplot
Subject	Re: Plotting data from an SQL
Date	2012-01-25 00:50 +0700
Organization	A noiseless patient Spider
Message-ID	<jfmr05$81b$1@dont-email.me> (permalink)
References	<jfhc4v$ef8$1@tdi.cu.mi.it>

Show all headers | View raw

22.01.2012 23:05, pg пишет:
> Is it possible to pass to the load command an SQL string to read data
> from an SQL db?
>
> I read this is possible (piped input) under Linux but I'm not be able to
> found the same (also with a package) under Windows environment.
>
> Any help will be appreciated.

For example, if you have a SQLite database.

plot.gp:
plot "data.dat" using 1:2 w linesp

plot.bat:
sqlite3 base.db "select x,y from tbl" >data.dat
gnuplot -persist plot.gp


You can change the first command if the batch file according to your 
database.

Back to comp.graphics.apps.gnuplot | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Plotting data from an SQL pg <picanog@yahoo.it> - 2012-01-22 17:05 +0100
  Re: Plotting data from an SQL Michael <proximum@land.ru> - 2012-01-25 00:50 +0700
    Re: Plotting data from an SQL pg <picanog@yahoo.it> - 2012-01-25 15:43 +0100
      Re: Plotting data from an SQL Michael <proximum@land.ru> - 2012-01-26 04:01 +0700

csiph-web