sqldf
sqldf copied to clipboard
ggrothendieck
Perform SQL Selects on R Data Frames
Until the RH2 maintainer updates RH2 with the new version of H2 this code will patch an existing RH2 installation provided that you have write permission in the java directory...
Check for extension parameter on RSQLite::initExtension, and if present, load all default extensions. The handling of extensions in RSQLite changed in version 2.2.11. This PR should allow the usage of...
I had written code that worked fine a few days ago and now sqldf won't do anything with dates. In my dataframe dx_dt is an IDate type and I tried...
Hi, When I was trying to use sqldf to join 2 data frames, it some times returned with error message "Error in value[[3L]](cond) : unable to open database file", then...
RSQLite has completely changed the code that `read.csv.sql` leverages basing it on `readr::read_csv` instead of on SQLite so `read,csv,sql` no longer works.
Recent versions of RSQLite cause spurious warnings when statements other than select are used in the SQL statement. (e.g. update, delete, insert, etc.)
See https://stackoverflow.com/questions/57446335/preserving-time-class-with-sqldf/57446844#57446844
Non-ascii table names do not seem to work. See https://stackoverflow.com/questions/57343258/retriving-non-ascii-table-name-using-sqldf
something must have changed with GFM's interpretation . The FAQ H2 headers were being treated as an ordinary numbered list. The FAQ hyperlinks from the TOC weren't working either. I...
avoids the errors like the one below. I hand-tested all of them except for the BOD and H2 examples. ```r Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import:...