Re: [R] Does SQL group by have a heavy duty equivalent in R

From: Prof Brian Ripley <ripley_at_stats.ox.ac.uk>
Date: Tue 02 Jan 2007 - 01:22:00 GMT

On Mon, 1 Jan 2007, BBands wrote:

> On 12/30/06, Farrel Buchinsky <fjbuch@gmail.com> wrote:
>> Instead I used RODBC
>>
>> sqlSave(channel,RawSeq)
>> to push the table into a Microsoft Access database
>> Then a sql query, courtesy of the Microsoft Access Query Wizard a la design
>> mode.
>
> If SQL does prove to be part of your approach you might want to have a
> look at SQLite. Dirk introduced it to me back when we worked on
> Crusher. We use it for development and some production work. Main
> attributes: simple, fast and light weight.

And it works perfectly well with RODBC, so you don't need yet another package. RODBC even comes with SQLite examples.

BTW, 'fast' is rather misleading: SQLite is often fast for small tasks, but can be very slow compared to a more serious DBMS.

> Everything you for R need here:
> http://cran.r-project.org/src/contrib/Descriptions/RSQLite.html
>
> SQLite's home page:
> http://www.sqlite.org/
>
> And a Python connector:
> http://initd.org/tracker/pysqlite
>
> jab
>

-- 
Brian D. Ripley,                  ripley@stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

______________________________________________
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Received on Tue Jan 02 13:20:22 2007

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Tue 02 Jan 2007 - 15:30:27 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.