readwritesqlite: Enhanced Reading and Writing for 'SQLite' Databases (original) (raw)

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.

Version: 0.2.0
Depends: R (≥ 4.0)
Imports: chk, DBI, hms, lifecycle, RSQLite, tibble, sf, rlang, glue, crayon
Suggests: covr, knitr, pool, rmarkdown, testthat (≥ 3.0.0), withr, units
Published: 2022-10-16
DOI: 10.32614/CRAN.package.readwritesqlite
Author: Joe Thorley ORCID iD [aut, cre], Sebastian DalgarnoORCID iD [ctb], Poisson Consulting [cph, fnd]
Maintainer: Joe Thorley
BugReports: https://github.com/poissonconsulting/readwritesqlite/issues
License: MIT + file
URL: https://github.com/poissonconsulting/readwritesqlite
NeedsCompilation: no
Language: en-US
Materials: README NEWS
CRAN checks: readwritesqlite results

Documentation:

Downloads:

Linking:

Please use the canonical formhttps://CRAN.R-project.org/package=readwritesqliteto link to this page.