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.5-any)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

# Install 'sqldf' in R:
install.packages('sqldf', repos = c('https://ggrothendieck.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

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

On CRAN:

13.00 score 250 stars 52 packages 8.1k scripts 21k downloads 25 mentions 3 exports 19 dependencies

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

TargetResultLatest binary
Doc / VignettesOKFeb 08 2025
R-4.5-winNOTEFeb 08 2025
R-4.5-macNOTEFeb 08 2025
R-4.5-linuxNOTEFeb 08 2025
R-4.4-winNOTEFeb 08 2025
R-4.4-macNOTEFeb 08 2025
R-4.3-winOKJan 09 2025
R-4.3-macOKFeb 08 2025

Exports:read.csv.sqlread.csv2.sqlsqldf

Dependencies:bitbit64blobcachemchronclicpp11DBIfastmapgluegsubfnlifecyclememoisepkgconfigplogrprotorlangRSQLitevctrs