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

Re: Plotting data from an SQL

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> (permalink)
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

Show key headers only | 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