diff options
Diffstat (limited to 'databases/R-cran-sqldf/pkg-descr')
-rw-r--r-- | databases/R-cran-sqldf/pkg-descr | 18 |
1 files changed, 8 insertions, 10 deletions
diff --git a/databases/R-cran-sqldf/pkg-descr b/databases/R-cran-sqldf/pkg-descr index 2378ae63cdc5..51c3fa23550e 100644 --- a/databases/R-cran-sqldf/pkg-descr +++ b/databases/R-cran-sqldf/pkg-descr @@ -1,10 +1,8 @@ -sqldf is an R package for runing SQL statements on R data frames, optimized for -convenience. The user simply specifies an SQL statement in R using data frame -names in place of table names and a database with appropriate table -layouts/schema is automatically created, the data frames are automatically -loaded into the database, the specified SQL statement is performed, the result -is read back into R and the database is deleted all automatically behind the -scenes making the database's existence transparent to the user who only -specifies the SQL statement. - -WWW: https://code.google.com/p/sqldf +The sqldf() function is typically passed a single argument which is an SQL +select statement where the table names are ordinary R data frame names. sqldf() +transparently sets up a database, imports the data frames into that database, +performs the SQL select or other statement and returns the result using a +heuristic to determine which class to assign to each column of the returned +data frame. The sqldf() or read.csv.sql() functions can also be used to read +filtered files into R even if the original files are larger than R itself can +handle. 'RSQLite', 'RH2', 'RMySQL' and 'RPostgreSQL' backends are supported. |