UPDATE: newest versions of RSQLite and sqldf do not have the incompatibility issues addressed by this question
work together well – Nathan
All: Thanks to G. Grothendieck for pointers to incompatibility issues introduced by RSQLite 1.1-1. As stated in the comment to the answer, downgrade RSQLite to 1.0.0:
This is indeed a compatibility problem between the current version of
RSQLite and the
RSQLite is now stricter about the arguments it accepts for
dbRemoveTable(), warnings will be issued (but only once per session) until
sqldf is adapted.
I’ll release a compatibility update soon, there is an issue on GitHub that will contain progress updates.
Read more here: Source link