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.
Versions across snapshots
| Version | Repository | File | Size |
|---|---|---|---|
0.4-12 |
rolling linux/jammy R-4.5 | sqldf_0.4-12.tar.gz |
75.5 KiB |
0.4-12 |
rolling linux/noble R-4.5 | sqldf_0.4-12.tar.gz |
75.5 KiB |
0.4-12 |
rolling source/ R- | sqldf_0.4-12.tar.gz |
60.0 KiB |
0.4-12 |
latest linux/jammy R-4.5 | sqldf_0.4-12.tar.gz |
75.5 KiB |
0.4-12 |
latest linux/noble R-4.5 | sqldf_0.4-12.tar.gz |
75.5 KiB |
0.4-12 |
latest source/ R- | sqldf_0.4-12.tar.gz |
60.0 KiB |
0.4-12 |
2026-04-26 source/ R- | sqldf_0.4-12.tar.gz |
60.0 KiB |
0.4-12 |
2026-04-23 source/ R- | sqldf_0.4-12.tar.gz |
60.0 KiB |
0.4-12 |
2026-04-09 windows/windows R-4.5 | sqldf_0.4-12.zip |
77.7 KiB |
0.4-11 |
2025-04-20 source/ R- | sqldf_0.4-11.tar.gz |
62.0 KiB |