[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[O] wishful thinking: using SQL to process tables. in the meantime, use

From: dmg
Subject: [O] wishful thinking: using SQL to process tables. in the meantime, use R
Date: Wed, 20 Jul 2016 18:13:53 -0700

Hi everybody,

I was wondering if there was a way to join two tables given
a common column. I searched but found nothing.

it would be awesome to be able to process tables in SQLITE.
something like this:

#+BEGIN_SRC sqlite :var a=table1 b=table2  :colnames yes
  select * from $a join $b using column;

I think it is not that hard. The infrastructure is there already.
It is just a matter of creating temp tables (this is the major part missing
which implies making a create statement from the table, but given
that sqlite is very type agnostic, it might not be hard), 
load them from the CSV files
the execute the block. A db parameter might be needed
for a scratch database file, but it could be a temporary one if
none is provided.

But in the meantime, it occurred to me, it is simple in R to do the join
and might be useful to others:

#+BEGIN_SRC R :var a=table1 b=table2 :results value :colnames yes

merge can do left joins, right joins, full joins, joins, 


but there is nothing like the power of SQL to process tables, though.


Daniel M. German

reply via email to

[Prev in Thread] Current Thread [Next in Thread]