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 poissonconsulting.ca>
BugReports: https://github.com/poissonconsulting/readwritesqlite/issues
License: MIT + file LICENSE
URL: https://github.com/poissonconsulting/readwritesqlite
NeedsCompilation: no
Language: en-US
Materials: README NEWS
CRAN checks: readwritesqlite results

Documentation:

Reference manual: readwritesqlite.pdf
Vignettes: Using readwritesqlite

Downloads:

Package source: readwritesqlite_0.2.0.tar.gz
Windows binaries: r-devel: readwritesqlite_0.2.0.zip, r-release: readwritesqlite_0.2.0.zip, r-oldrel: readwritesqlite_0.2.0.zip
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

Linking:

Please use the canonical form https://CRAN.R-project.org/package=readwritesqlite to link to this page.