Package: readwritesqlite Title: Enhanced Reading and Writing for 'SQLite' Databases Version: 0.2.0.9039 Authors@R: 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"))) Description: 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. License: MIT + file LICENSE URL: https://github.com/poissonconsulting/readwritesqlite, https://poissonconsulting.github.io/readwritesqlite/ BugReports: https://github.com/poissonconsulting/readwritesqlite/issues 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 VignetteBuilder: knitr RdMacros: lifecycle Encoding: UTF-8 Language: en-US LazyData: true Roxygen: list(markdown = TRUE) Config/testthat/edition: 3 Config/Needs/website: poissonconsulting/poissontemplate Config/roxygen2/version: 8.0.0.9000 Config/pak/sysreqs: libabsl-dev cmake libgdal-dev gdal-bin libgeos-dev libssl-dev libproj-dev libsqlite3-dev libudunits2-dev Repository: https://poissonconsulting.r-universe.dev Date/Publication: 2026-07-16 07:45:15 UTC RemoteUrl: https://github.com/poissonconsulting/readwritesqlite RemoteRef: HEAD RemoteSha: c0ebd3b5d90e39578efdfd03bda38e6a99d50f41 NeedsCompilation: no Packaged: 2026-07-18 08:39:20 UTC; root Author: Joe Thorley [aut, cre] (ORCID: ), Sebastian Dalgarno [ctb] (ORCID: ), Poisson Consulting [cph, fnd] Maintainer: Joe Thorley