Cannot write tbl_df to SQLite database

[leeper]

I'm trying to create an SQLite database (using RSQLite), but it's giving an error when trying to write a data.frame read in using readr::read_fwf due to the "tbl_df" class:

library("readr")
library("RSQLite")
fwf_sample <- system.file("extdata/fwf-sample.txt", package = "readr")
d1 <- read_fwf(fwf_sample, fwf_widths(c(2, 5, 3)))
db <- dbConnect(RSQLite::SQLite(), ":memory:")
dbWriteTable(conn = db, name = "table", value = d1)
Error in (function (classes, fdef, mtable)  : 
  unable to find an inherited method for function ‘dbWriteTable’ for signature ‘"SQLiteConnection", "character", "tbl_df"’

Appears to be same issue as: r-dbi/RSQLite#82

> sessionInfo()
R version 3.2.3 (2015-12-10)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 7 x64 (build 7601) Service Pack 1

locale:
[1] LC_COLLATE=English_United Kingdom.1252  LC_CTYPE=English_United Kingdom.1252   
[3] LC_MONETARY=English_United Kingdom.1252 LC_NUMERIC=C                           
[5] LC_TIME=English_United Kingdom.1252    

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
[1] RSQLite_1.0.0 DBI_0.3.1     readr_0.2.2  

loaded via a namespace (and not attached):
[1] tools_3.2.3 Rcpp_0.12.4

[krlmlr]

Should be fixed with the tibble package.

[leeper]

@krlmlr In what sense?

[krlmlr]

tibble calls setOldClass(), R takes care of the rest.

(Of course, it must be loaded, which doesn't happen automatically yet.)

[leeper]

@krlmlr So, in the example (I just updated to make it fully reproducible), what steps do I have to add to make this work?

[krlmlr]

requireNamespace("tibble")

but this actually should be done by the package itself.

[krlmlr]

...or use devtools::install_github("hadley/readr#385").