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

[Juliet Jacobson]

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.
>