The hardware and bandwidth for this mirror is donated by dogado GmbH, the Webhosting and Full Service-Cloud Provider. Check out our Wordpress Tutorial.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]dogado.de.
A tool for working with SQLite databases.
SQLite has some idiosyncrasies and limitations that impose
some hurdles to the R developer. For instance, SQLite
doesn’t have a date type and sqliteutils has some functions
to deal with that
You can install the released version of sqliteutils from CRAN with:
install.packages("sqliteutils")SQLIte does not have a date type. When you insert dates
in a SQLIte table using DBI::dbWriteTable(), for instance,
they are converted to a numeric value.
Using slu_date_to_r() you can convert the value back to
the original date.
library(sqliteutils)
data <- data.frame(date = c(as.Date("2021-09-18"), as.Date("2021-09-19"))
con <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")
DBI::dbWriteTable(conn = con, name = "dates", value = data )
data_from_bd <- DBI::dbReadTable(conn = con, name = "dates")
original_date <- slu_date_to_r(data_from_bd$date)
DBI::dbDisconnect(con)
print(original_date)Using slu_date_to_sqlite() you can make the inverse:
convert a date to the number SQLite would store it if we called
DBI::dbWriteTable()
con <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")
data <- data.frame(
date = c(as.Date("2021-09-19"), as.Date("2021-09-20"))
)
DBI::dbWriteTable(conn = con, name = "dates", value = data )
data_from_bd <- dplyr::tbl(src = con, "dates") %>% dplyr::collect()
data_with_sqlite_dates <- data %>%
dplyr::mutate(
date = slu_date_to_sqlite(date)
)
DBI::dbDisconnect(con)
print(data_from_bd)
print(data_with_sqlite_dates)
These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.
Health stats visible at Monitor.