readwritesqlite: 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.

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 Dalgarno ORCID iD [ctb], Poisson Consulting [cph, fnd]
Maintainer: Joe Thorley <joe at>
License: MIT + file LICENSE
NeedsCompilation: no
Language: en-US
Materials: README NEWS
CRAN checks: readwritesqlite results


Reference manual: readwritesqlite.pdf
Vignettes: Using readwritesqlite


Package source: readwritesqlite_0.2.0.tar.gz
Windows binaries: r-devel:, r-release:, r-oldrel:
macOS binaries: r-release (arm64): readwritesqlite_0.2.0.tgz, r-oldrel (arm64): readwritesqlite_0.2.0.tgz, r-release (x86_64): readwritesqlite_0.2.0.tgz, r-oldrel (x86_64): readwritesqlite_0.2.0.tgz
Old sources: readwritesqlite archive


Please use the canonical form to link to this page.