The hardware and bandwidth for this mirror is donated by dogado GmbH, the Webhosting and Full Service-Cloud Provider. Check out our Wordpress Tutorial.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]dogado.de.
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 |
| DOI: | 10.32614/CRAN.package.sqldf |
| 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 (arm64): sqldf_0.4-11.tgz, r-oldrel (arm64): sqldf_0.4-11.tgz, r-release (x86_64): sqldf_0.4-11.tgz, r-oldrel (x86_64): sqldf_0.4-11.tgz |
| Old sources: | sqldf archive |
| Reverse depends: | Fgmutils, metevalue, smbinning |
| Reverse imports: | BETS, casper, Clustering, drugprepr, fdq, FIESTA, FIESTAutils, healthyR, icesDatsuQC, idem, kangar00, KinSwingR, miRNAtap, msig, multimorbidity, mygene, nlive, OnomasticDiversity, ProfoundData, puzzle, r3Cseq, RareComb, RcextTools, RiboProfiling, RImmPort, RITAN, Rprofet, RSDA, scorecardModelUtils, STRINGdb, tcpl, visit, WeibullFit |
| Reverse suggests: | DOPE, prqlr, R6causal, rcellminer, remotePARTS |
Please use the canonical form https://CRAN.R-project.org/package=sqldf to link to this page.
These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.
Health stats visible at Monitor.