Groups > comp.graphics.apps.gnuplot > #860 > unrolled thread

Plotting data from an SQL

Started by	pg <picanog@yahoo.it>
First post	2012-01-22 17:05 +0100
Last post	2012-01-26 04:01 +0700
Articles	4 — 2 participants

Back to article view | Back to comp.graphics.apps.gnuplot

  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

#860 — Plotting data from an SQL

From	pg <picanog@yahoo.it>
Date	2012-01-22 17:05 +0100
Subject	Plotting data from an SQL
Message-ID	<jfhc4v$ef8$1@tdi.cu.mi.it>

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.

[toc] | [next] | [standalone]

#866

From	Michael <proximum@land.ru>
Date	2012-01-25 00:50 +0700
Message-ID	<jfmr05$81b$1@dont-email.me>
In reply to	#860

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.

[toc] | [prev] | [next] | [standalone]

#870

From	pg <picanog@yahoo.it>
Date	2012-01-25 15:43 +0100
Message-ID	<jfp4e3$q8a$1@tdi.cu.mi.it>
In reply to	#866

Tks Michael,

from your answer I understand there is no way to do the same directly 
from  Gnuplot command line under Windows.
This way needs to pre-prepare data so that you lost the power of the 
interaction.

Under Linux piped input helps, so tath from Gnuplot command line you ca 
do the same you well eplained staying into the application.

I don't know if under windows, customizing something, could be possible 
enable the piped input.

In any case thanks for your answer.

Il 24/01/2012 18.50, Michael ha scritto:
> 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.
>

[toc] | [prev] | [next] | [standalone]

#872

From	Michael <proximum@land.ru>
Date	2012-01-26 04:01 +0700
Message-ID	<jfpqja$q2i$1@dont-email.me>
In reply to	#870

25.01.2012 21:43, pg пишет:
> Tks Michael,
>
> from your answer I understand there is no way to do the same directly
> from Gnuplot command line under Windows.

Well, if just I don't know the answer, it not means that there is no 
solution :)

[toc] | [prev] | [standalone]

csiph-web

Plotting data from an SQL

Contents

#860 — Plotting data from an SQL

#866

#870

#872