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: | Databases, HighPerformanceComputing |
| CRAN checks: | sqldf results |
| 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 |
| macOS binaries: | r-release: sqldf_0.4-11.tgz, r-oldrel: sqldf_0.4-11.tgz |
| Old sources: | sqldf archive |
| Reverse depends: | Fgmutils, GPCSIV, methVisual, smbinning, vmsbase |
| Reverse imports: | bdvis, BETS, casper, Clustering, fdq, helda, idem, InterMineR, ITGM, kangar00, KinSwingR, miRNAtap, mygene, plethem, polyPK, ProfoundData, puzzle, r3Cseq, RcextTools, RiboProfiling, RImmPort, RITAN, Rprofet, RSDA, scorecardModelUtils, scsR, smartR, STRINGdb, taxotools, tcpl, visit, waveformlidar, WeibullFit |
| Reverse suggests: | rcellminer, sqlutils |
Please use the canonical form https://CRAN.R-project.org/package=sqldf to link to this page.