Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail
From: Michael <proximum@land.ru>
Newsgroups: comp.graphics.apps.gnuplot
Subject: Re: Plotting data from an SQL
Date: Wed, 25 Jan 2012 00:50:21 +0700
Organization: A noiseless patient Spider
Lines: 22
Message-ID: <jfmr05$81b$1@dont-email.me>
References: <jfhc4v$ef8$1@tdi.cu.mi.it>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Tue, 24 Jan 2012 17:49:58 +0000 (UTC)
Injection-Info: mx04.eternal-september.org; posting-host="xRgEVutvq4120NtV0lKpag"; logging-data="8235"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX19anPrHa9QjgByq16iPzE1q"
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.24) Gecko/20111120 Icedove/3.1.16
In-Reply-To: <jfhc4v$ef8$1@tdi.cu.mi.it>
Cancel-Lock: sha1:MLYOlKxri+35TEEQnuX1M2sFYgI=
Xref: x330-a1.tempe.blueboxinc.net comp.graphics.apps.gnuplot:866

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.