On Wed, Feb 18, 2015 at 9:53 AM, Richard Hipp <drh at sqlite.org> wrote: > On 2/18/15, Jim Callahan <jim.callahan.orlando at gmail.com> wrote: >> I would mention the open source statistical language R in the "data >> analysis" section. > > I've heard of R but never tried to use it myself. Is an SQLite > interface built into R, sure enough? Or is that something that has to > be added in separately? >
RSQLite is an add-on package to R; however, for data analysis (as opposed to specific database manipulation) I would think most R users would use my sqldf R add-on package (which uses RSQLite by default and also can use driver packages of certain other databases) rather than RSQLite directly if they were going to use SQL for that. In R a data.frame is like an SQL table but in memory and sqldf lets you apply SQL statements to them as if they were all one big SQLite database. A common misconception is it must be slow but in fact its sufficiently fast that some people use it to get a speed advantage over plain R. Others use it to learn SQL or to ease the transition to R and others use it allow them to manipulate R data frames without knowing much about R provided they know SQL. If you have not tried R this takes you through installing R and running sqldf in about 5 minutes: https://sqldf.googlecode.com/#For_Those_New_to_R The rest of that page gives many other examples.