Package: sqldf 0.4-11

sqldf: Manipulate R Data Frames Using SQL

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.

Authors:G. Grothendieck <[email protected]>

sqldf_0.4-11.tar.gz
sqldf_0.4-11.zip(r-4.5)sqldf_0.4-11.zip(r-4.4)sqldf_0.4-11.zip(r-4.3)
sqldf_0.4-11.tgz(r-4.4-any)sqldf_0.4-11.tgz(r-4.3-any)
sqldf_0.4-11.tar.gz(r-4.5-noble)sqldf_0.4-11.tar.gz(r-4.4-noble)
sqldf_0.4-11.tgz(r-4.4-emscripten)sqldf_0.4-11.tgz(r-4.3-emscripten)
sqldf.pdf |sqldf.html✨
sqldf/json (API)
NEWS

Peer review:

Bug tracker:https://github.com/ggrothendieck/sqldf/issues

On CRAN:

3 exports 249 stars 7.35 score 19 dependencies 53 dependents 25 mentions 7.3k scripts 22.1k downloads

Last updated 3 years agofrom:ba33807f23. Checks:OK: 3 NOTE: 4. Indexed: yes.

Exports:read.csv.sqlread.csv2.sqlsqldf

Dependencies:bitbit64blobcachemchronclicpp11DBIfastmapgluegsubfnlifecyclememoisepkgconfigplogrprotorlangRSQLitevctrs