Description
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.
Downloads
16.9K
Last 30 days
898th
63.2K
Last 90 days
284.8K
Last year
Trend: -29.9% (30d vs prior 30d)
94
Last 30 days
288
Last 90 days
833
Last year
Trend: -2.1% (30d vs prior 30d)
8
Last 7 days
56
Last 30 days
1
All-time
⚠ Shared name: this package is also shipped elsewhere on openSUSE, so this count is not exclusive to autoCRAN (it is an upper bound).
367
Last 30 days
1.2K
Last 90 days
5.9K
Last year
Trend: -11.6% (30d vs prior 30d)
9
Last 30 days
25
Last 90 days
185
Last year
Trend: +12.5% (30d vs prior 30d)
CRAN Check Status
Show all 13 flavors
| Flavor | Status |
|---|---|
| r-devel-linux-x86_64-debian-clang | OK |
| r-devel-linux-x86_64-debian-gcc | OK |
| r-devel-linux-x86_64-fedora-clang | OK |
| r-devel-linux-x86_64-fedora-gcc | OK |
| r-devel-windows-x86_64 | OK |
| r-oldrel-macos-arm64 | OK |
| r-oldrel-macos-x86_64 | OK |
| r-oldrel-windows-x86_64 | OK |
| r-patched-linux-x86_64 | OK |
| r-release-linux-x86_64 | OK |
| r-release-macos-arm64 | OK |
| r-release-macos-x86_64 | OK |
| r-release-windows-x86_64 | OK |
Check History
OK 14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 10, 2026
Code
Structure
Lines of code
1,272
Files
19
Compiled share
0%
Has compiled src
No
Language breakdown
API
Exported functions
4
Internal functions
0
Testing & CI
Has tests
Yes
Test-to-code ratio
0.01
testthat edition
–
CI present
No
CI type
[]
PR gated
No
Docs
Return-value doc rate
–
\dontrun example ratio
50%
Roxygen coverage
–
Has pkgdown
No
NEWS present
No
Health & Security signals
Informational signals; not verdicts.
on.exit coverage
66.7%
Unsafe pattern score
4
Dep constraint coverage
20%
Secret pattern count
0
Bundled 3rd-party code
2 items
Portability & License
Min R version
3.1.0
System requirements
–
C++ standard
–
License
GPL-2
License flags
SPDX valid, OSI approved
History
Versions
28
First release
2007-07-21
Latest release
2026-01-30
Avg cadence
36 days
Cold removal rate
–
Dep drift
7
LOC over versions
Per-file churn detail lives in the source pipeline: https://github.com/r-observatory/cran-code-metrics.