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.

Version: 0.4-11
Depends: R (≥ 3.1.0), gsubfn (≥ 0.6), proto, RSQLite
Imports: DBI, chron
Suggests: RH2, RMySQL, RPostgreSQL, svUnit, tcltk, MASS
Published: 2017-06-28
Author: G. Grothendieck
Maintainer: G. Grothendieck <ggrothendieck at gmail.com>
BugReports: https://github.com/ggrothendieck/sqldf/issues
License: GPL-2
URL: https://github.com/ggrothendieck/sqldf, https://groups.google.com/group/sqldf
NeedsCompilation: no
Materials: README NEWS INSTALL
In views: HighPerformanceComputing
CRAN checks: sqldf results

Downloads:

Reference manual: sqldf.pdf
Package source: sqldf_0.4-11.tar.gz
Windows binaries: r-devel: sqldf_0.4-11.zip, r-release: sqldf_0.4-11.zip, r-oldrel: sqldf_0.4-11.zip
OS X El Capitan binaries: r-release: sqldf_0.4-11.tgz
OS X Mavericks binaries: r-oldrel: sqldf_0.4-11.tgz
Old sources: sqldf archive

Reverse dependencies:

Reverse depends: Fgmutils, GPCSIV, smbinning, vmsbase
Reverse imports: bdvis, fdq, idem, ITGM, kangar00, phalen, polyPK, RcextTools, RSDA, stacomiR
Reverse suggests: sqlutils

Linking:

Please use the canonical form https://CRAN.R-project.org/package=sqldf to link to this page.