Enhanced Reading and Writing for 'SQLite' Databases
Reads and writes data frames to 'SQLite' databases while
preserving time zones (for POSIXct columns),
projections (for 'sfc' columns), units (for 'units' columns),
levels (for factors and ordered factors) and classes for
logical, Date and 'hms' columns.
It also logs changes to tables and provides more informative error messages.
err, checkr, dttr2, hms, DBI, RSQLite, sf, tibble, units

err, checkr, dttr2, hms (>= 0.5.0), DBI, RSQLite, sf, tibble,
units

c(
person("Joe", "Thorley", , "joe@poissonconsulting.ca", c("aut", "cre"), comment = c(ORCID = "0000-0002-7683-4592")),
person("Sebastian", "Dalgarno", , "seb@poissonconsulting.ca", "ctb", comment = c(ORCID = "0000-0002-3658-4517")),
person("Poisson Consulting", role = c("cph", "fnd"))
)
Reads and writes data frames to 'SQLite'
databases while preserving time zones (for POSIXct columns),
projections (for 'sfc' columns), units (for 'units' columns), levels
(for factors and ordered factors) and classes for logical, Date and
'hms' columns.  It also logs changes to tables and provides more
informative error messages.
chk, hms, DBI, RSQLite, lifecycle, tibble
covr, testthat, knitr, rmarkdown, units, sf
Joe Thorley [aut, cre] (<https://orcid.org/0000-0002-7683-4592>),
Sebastian Dalgarno [ctb] (<https://orcid.org/0000-0002-3658-4517>),
Poisson Consulting [cph, fnd]

covr, pool, testthat, knitr, rmarkdown, units, sf

c(person(given = "Joe",
family = "Thorley",
role = c("aut", "cre"),
email = "joe@poissonconsulting.ca",
comment = c(ORCID = "0000-0002-7683-4592")),
person(given = "Sebastian",
family = "Dalgarno",
role = "ctb",
email = "seb@poissonconsulting.ca",
comment = c(ORCID = "0000-0002-3658-4517")),
person(given = "Poisson Consulting",
role = c("cph", "fnd")))
Reads and writes data frames to 'SQLite' databases
while preserving time zones (for POSIXct columns), projections (for
'sfc' columns), units (for 'units' columns), levels (for factors and
ordered factors) and classes for logical, Date and 'hms' columns.  It
also logs changes to tables and provides more informative error
messages.
chk, DBI, hms, lifecycle, RSQLite, tibble, sf, rlang, glue,
crayon
covr, knitr, pool, rmarkdown, testthat (>= 3.0.0), withr,
units