RSQLite 2.0 breaks sqldf

[Gabor Grothendieck]

Several people have posted that RSQLite 2.0 breaks sqldf causing an error to be produced for nearly every sqldf statement run.

I have posted an issue on the RSQLite issues list.

Until that is resolved (1) use an older version of RSQLite or (2) use the RH2 (or other) backend or (3) use MySQL or PostgreSQL backends.

The RH2 backend is the easiest to install since it only requires that you install java and the RH2 package - H2 itself is already included in RH2.   If RH2 is loaded sqldf will notice it and use it instead of SQLite.

    # install java

    library(RH2)

    library(sqldf)

    # can now issue sqldf statements using selects acceptable to H2

H2 does have more builtin functions that SQLite and also has true date and datetime types which SQLite lacks.

[Gabor Grothendieck]

Until the new version of sqldf is loaded onto CRAN try using the github versoin of sqldf.

    library(devtools)

    install_github("ggrothendieck/sqldf")

    # now it should work with RSQLite 2.0

    library(sqldf)

    sqldf("select * from BOD")

Please report any problems.

[tjcr...@gmail.com]

Thank you so much!