Package: readwritesqlite Title: Enhanced Reading and Writing for 'SQLite' Databases Version: 0.2.0.9040 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-10-13 07:38:48 UTC RemoteUrl: https://github.com/poissonconsulting/readwritesqlite RemoteRef: HEAD RemoteSha: c3e15457346de1bd82045e79904dfb0831634eda NeedsCompilation: no Packaged: 2026-10-15 00:51:19 UTC; root Author: Joe Thorley [aut, cre] (ORCID: ), Sebastian Dalgarno [ctb] (ORCID: ), Poisson Consulting [cph, fnd] Maintainer: Joe Thorley