[R] Advantages of using SQLite for data import in comparison to csv files

[Gabor Grothendieck]

sqldf is layered on top of RSQLite.  Its not a separate facility.

On Thu, Jan 14, 2010 at 2:12 AM, Juliet Jacobson <julietjacobson at aim.com> wrote:
> Thanks for your answer. I hadn't found this possibility by web search.
> Since sqldf also allows the import of tables from csv files, complex
> SELECT queries and even joins on tables, I have the impression that
> there aren't any reasons for using a SQLite database to organise the
> data for R.
> But then why has the R driver for data import from a SQLite database
> been written?
>
> Gabor Grothendieck wrote:
>> You could look at read.csv.sql in sqldf (http://sqldf.googlecode.com) as well.
>>
>