{ "_id": "6a1d13831d7bb097a0a35db7", "Package": "readwritesqlite", "Title": "Enhanced Reading and Writing for 'SQLite' Databases", "Version": "0.2.0.9032", "Authors@R": "c(person(given = \"Joe\",\nfamily = \"Thorley\",\nrole = c(\"aut\", \"cre\"),\nemail = \"joe@poissonconsulting.ca\",\ncomment = c(ORCID = \"0000-0002-7683-4592\")),\nperson(given = \"Sebastian\",\nfamily = \"Dalgarno\",\nrole = \"ctb\",\nemail = \"seb@poissonconsulting.ca\",\ncomment = c(ORCID = \"0000-0002-3658-4517\")),\nperson(given = \"Poisson Consulting\",\nrole = c(\"cph\", \"fnd\")))", "Description": "Reads and writes data frames to 'SQLite' databases while\npreserving time zones (for POSIXct columns), projections (for\n'sfc' columns), units (for 'units' columns), levels (for\nfactors and ordered factors) and classes for logical, Date and\n'hms' columns. It also logs changes to tables and provides\nmore informative error messages.", "License": "MIT + file LICENSE", "URL": "https://github.com/poissonconsulting/readwritesqlite,\nhttps://poissonconsulting.github.io/readwritesqlite/", "BugReports": "https://github.com/poissonconsulting/readwritesqlite/issues", "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\nlibssl-dev libproj-dev libsqlite3-dev libudunits2-dev", "Repository": "https://poissonconsulting.r-universe.dev", "Date/Publication": "2026-05-24 01:24:23 UTC", "RemoteUrl": "https://github.com/poissonconsulting/readwritesqlite", "RemoteRef": "HEAD", "RemoteSha": "e3e445ef4952ee9698f486adad73dba4ce2ad0fd", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-01 05:04:02 UTC", "User": "root" }, "Author": "Joe Thorley [aut, cre] (ORCID: ),\nSebastian Dalgarno [ctb] (ORCID:\n),\nPoisson Consulting [cph, fnd]", "Maintainer": "Joe Thorley ", "MD5sum": "1bf0e705244f6b760688e2e606c0d217", "_user": "poissonconsulting", "_type": "src", "_file": "readwritesqlite_0.2.0.9032.tar.gz", "_fileid": "117d4e9cda22b3097327075f2fd9c464ed3f35e8488d93e8df2cbfc0d74a30b8", "_filesize": 192186, "_sha256": "117d4e9cda22b3097327075f2fd9c464ed3f35e8488d93e8df2cbfc0d74a30b8", "_created": "2026-06-01T05:04:02.000Z", "_published": "2026-06-01T05:07:15.439Z", "_distro": "noble", "_jobs": [ { "job": 78789916180, "time": 163, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7323794000" }, { "job": 78789916208, "time": 164, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7323794012" }, { "job": 78789916179, "time": 86, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7323789992" }, { "job": 78789916212, "time": 100, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7323792494" }, { "job": 78789627657, "time": 194, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7323766993" }, { "job": 78789916194, "time": 126, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7323787562" }, { "job": 78789916188, "time": 92, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7323781874" }, { "job": 78789916215, "time": 108, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7323784600" }, { "job": 78789916217, "time": 109, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7323784996" } ], "_buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/26736112391", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/poissonconsulting/readwritesqlite", "_commit": { "id": "e3e445ef4952ee9698f486adad73dba4ce2ad0fd", "author": "krlmlr ", "committer": "krlmlr ", "message": "fledge: Bump version to 0.2.0.9032\n", "time": 1779585863 }, "_maintainer": { "name": "Joe Thorley", "email": "joe@poissonconsulting.ca", "login": "joethorley", "orcid": "0000-0002-7683-4592", "description": "A computational biologist who performs Bayesian analyses using R, STAN and JAGS.\n", "uuid": 613671 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.0", "role": "Depends" }, { "package": "chk", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "hms", "role": "Imports" }, { "package": "lifecycle", "role": "Imports" }, { "package": "RSQLite", "role": "Imports" }, { "package": "tibble", "role": "Imports" }, { "package": "sf", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "glue", "role": "Imports" }, { "package": "crayon", "role": "Imports" }, { "package": "covr", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "pool", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "withr", "role": "Suggests" }, { "package": "units", "role": "Suggests" } ], "_owner": "poissonconsulting", "_selfowned": true, "_usedby": 2, "_updates": [ { "week": "2025-23", "n": 4 }, { "week": "2025-31", "n": 2 }, { "week": "2025-32", "n": 2 }, { "week": "2025-36", "n": 4 }, { "week": "2025-45", "n": 3 }, { "week": "2025-46", "n": 4 }, { "week": "2025-47", "n": 1 }, { "week": "2026-03", "n": 4 }, { "week": "2026-10", "n": 4 }, { "week": "2026-11", "n": 2 }, { "week": "2026-17", "n": 4 }, { "week": "2026-18", "n": 1 }, { "week": "2026-19", "n": 11 }, { "week": "2026-20", "n": 7 }, { "week": "2026-21", "n": 3 } ], "_tags": [ { "name": "v0.2.0.9012", "date": "2025-06-03" }, { "name": "v0.2.0.9013", "date": "2025-08-01" }, { "name": "v0.2.0.9014", "date": "2025-08-05" }, { "name": "v0.2.0.9015", "date": "2025-09-05" }, { "name": "v0.2.0.9016", "date": "2025-09-06" }, { "name": "v0.2.0.9017", "date": "2025-11-08" }, { "name": "v0.2.0.9018", "date": "2025-11-10" }, { "name": "v0.2.0.9019", "date": "2025-11-12" }, { "name": "v0.2.0.9020", "date": "2025-11-17" }, { "name": "v0.2.0.9021", "date": "2026-01-14" }, { "name": "v0.2.0.9022", "date": "2026-03-07" }, { "name": "v0.2.0.9023", "date": "2026-03-08" }, { "name": "v0.2.0.9024", "date": "2026-03-14" }, { "name": "v0.2.0.9025", "date": "2026-04-25" }, { "name": "v0.2.0.9026", "date": "2026-05-04" }, { "name": "v0.2.0.9027", "date": "2026-05-06" }, { "name": "v0.2.0.9028", "date": "2026-05-10" }, { "name": "v0.2.0.9029", "date": "2026-05-10" }, { "name": "v0.2.0.9030", "date": "2026-05-14" }, { "name": "v0.2.0.9031", "date": "2026-05-16" }, { "name": "v0.2.0.9032", "date": "2026-05-24" } ], "_topics": [ "dbi", "log", "metadata", "posixct", "read", "sfc", "sqlite", "units", "write" ], "_stars": 39, "_contributors": [ { "user": "joethorley", "count": 286, "uuid": 613671 }, { "user": "krlmlr", "count": 76, "uuid": 1741643 }, { "user": "evanamiesgalonski", "count": 23, "uuid": 14318875 }, { "user": "stefanomezzini", "count": 6, "uuid": 42444204 }, { "user": "nadinehussein", "count": 3, "uuid": 74937983 }, { "user": "sebdalgarno", "count": 3, "uuid": 15878432 }, { "user": "aylapear", "count": 3, "uuid": 42985574 } ], "_userbio": { "uuid": 1679318, "type": "organization", "name": "Poisson Consulting Ltd.", "description": "Computational Biology and Statistical Ecology" }, "_downloads": { "count": 55, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/readwritesqlite" }, "_devurl": "https://github.com/poissonconsulting/readwritesqlite", "_pkgdown": "https://poissonconsulting.github.io/readwritesqlite/", "_searchresults": 11, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/readwritesqlite.html", "manual.pdf" ], "_cranurl": false, "_releases": [ { "version": "0.0.1", "date": "2019-07-11" }, { "version": "0.0.2", "date": "2019-07-23" }, { "version": "0.1.0", "date": "2020-01-29" }, { "version": "0.1.1", "date": "2020-04-07" }, { "version": "0.1.2", "date": "2020-07-13" }, { "version": "0.2.0", "date": "2022-10-16" } ], "_exports": [ "check_sqlite_connection", "chk_sqlite_conn", "rws_close_connection", "rws_connect", "rws_describe_meta", "rws_disconnect", "rws_drop_table", "rws_export_gpkg", "rws_list_tables", "rws_open_connection", "rws_query", "rws_query_sqlite", "rws_read", "rws_read_init", "rws_read_log", "rws_read_meta", "rws_read_sqlite", "rws_read_sqlite_init", "rws_read_sqlite_log", "rws_read_sqlite_meta", "rws_read_sqlite_table", "rws_read_table", "rws_rename_column", "rws_rename_table", "rws_write", "rws_write_sqlite", "vld_sqlite_conn" ], "_datasets": [ { "name": "rws_data", "title": "Example Data", "object": "rws_data", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "logical", "date", "factor", "ordered", "posixct", "units" ], "rows": 3, "table": true, "tojson": false } ], "_help": [ { "page": "chk_sqlite_conn", "title": "Check SQLite Connection", "topics": [ "check_sqlite_connection", "chk_sqlite_conn" ] }, { "page": "rws_connect", "title": "Opens SQLite Database Connection", "topics": [ "rws_connect", "rws_open_connection" ] }, { "page": "rws_data", "title": "Example Data", "topics": [ "rws_data" ] }, { "page": "rws_describe_meta", "title": "Add Descriptions to SQL Meta Data Table", "concept": [ "rws_describe_meta" ], "topics": [ "rws_describe_meta" ] }, { "page": "rws_describe_meta.character", "title": "Add Descriptions to SQL Meta Data Table", "concept": [ "rws_describe_meta" ], "topics": [ "rws_describe_meta.character" ] }, { "page": "rws_describe_meta.data.frame", "title": "Add Data Frame of Descriptions to SQL Meta Data Table", "concept": [ "rws_read" ], "topics": [ "rws_describe_meta.data.frame" ] }, { "page": "rws_disconnect", "title": "Close SQLite Database Connection", "topics": [ "rws_close_connection", "rws_disconnect" ] }, { "page": "rws_drop_table", "title": "Drop SQLite Table", "concept": [ "rws_rename" ], "topics": [ "rws_drop_table" ] }, { "page": "rws_export_gpkg", "title": "Export all spatial datasets in a database as geopackages.", "topics": [ "rws_export_gpkg" ] }, { "page": "rws_list_tables", "title": "Table Names", "topics": [ "rws_list_tables" ] }, { "page": "rws_query", "title": "Query SQLite Database", "topics": [ "rws_query", "rws_query_sqlite" ] }, { "page": "rws_read", "title": "Read from a SQLite Database", "concept": [ "rws_read" ], "topics": [ "rws_read", "rws_read_sqlite" ] }, { "page": "rws_read_init", "title": "Read Initialization Data table from a SQLite Database", "topics": [ "rws_read_init", "rws_read_sqlite_init" ] }, { "page": "rws_read_log", "title": "Read Log Data Table from a SQLite Database", "topics": [ "rws_read_log", "rws_read_sqlite_log" ] }, { "page": "rws_read_meta", "title": "Read Meta Data table from a SQLite Database", "topics": [ "rws_read_meta", "rws_read_sqlite_meta" ] }, { "page": "rws_read_table", "title": "Read a Table from a SQLite Database", "topics": [ "rws_read_sqlite_table", "rws_read_table" ] }, { "page": "rws_read.character", "title": "Read Tables from a SQLite Database", "concept": [ "rws_read" ], "topics": [ "rws_read.character" ] }, { "page": "rws_read.SQLiteConnection", "title": "Read All Tables from a SQLite Database", "concept": [ "rws_read" ], "topics": [ "rws_read.SQLiteConnection" ] }, { "page": "rws_rename_column", "title": "Rename SQLite Column", "concept": [ "rws_rename" ], "topics": [ "rws_rename_column" ] }, { "page": "rws_rename_table", "title": "Rename SQLite Table", "concept": [ "rws_rename" ], "topics": [ "rws_rename_table" ] }, { "page": "rws_write", "title": "Write to a SQLite Database", "concept": [ "rws_write" ], "topics": [ "rws_write", "rws_write_sqlite" ] }, { "page": "rws_write.data.frame", "title": "Write a Data Frame to a SQLite Database", "concept": [ "rws_write" ], "topics": [ "rws_write.data.frame" ] }, { "page": "rws_write.environment", "title": "Write the Data Frames in an Environment to a SQLite Database", "concept": [ "rws_write" ], "topics": [ "rws_write.environment" ] }, { "page": "rws_write.list", "title": "Write a Named List of Data Frames to a SQLite Database", "concept": [ "rws_write" ], "topics": [ "rws_write.list" ] }, { "page": "vld_sqlite_conn", "title": "Validate SQLite Connection", "topics": [ "vld_sqlite_conn" ] } ], "_pkglogo": "https://github.com/poissonconsulting/readwritesqlite/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/poissonconsulting/readwritesqlite/raw/HEAD/README.md", "_rundeps": [ "bit", "bit64", "blob", "cachem", "chk", "class", "classInt", "cli", "cpp11", "crayon", "DBI", "e1071", "fastmap", "glue", "hms", "KernSmooth", "lifecycle", "magrittr", "MASS", "memoise", "pillar", "pkgconfig", "proxy", "Rcpp", "rlang", "RSQLite", "s2", "sf", "tibble", "units", "utf8", "vctrs", "wk" ], "_vignettes": [ { "source": "using-readwritesqlite.Rmd", "filename": "using-readwritesqlite.html", "title": "Using readwritesqlite", "author": "Joe Thorley", "engine": "knitr::rmarkdown", "headings": [ "Starting", "Writing Data", "Exists", "Foreign Keys", "Committing Data", "Deleting Data (and Meta Data)", "Replacing Data", "Duplicate Data", "All Data", "Strict", "Silent", "Reading Data", "Cleaning Up" ], "created": "2018-12-10 23:29:53", "modified": "2019-07-07 16:11:23", "commits": 12 } ], "_score": 7.063821056343711, "_indexed": true, "_nocasepkg": "readwritesqlite", "_universes": [ "poissonconsulting", "joethorley" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.2.0.9032", "date": "2026-06-01T05:06:20.000Z", "distro": "noble", "commit": "e3e445ef4952ee9698f486adad73dba4ce2ad0fd", "fileid": "aaa9ae1f9a4fbc0f12887ad8994877e61835c3474224860c089627edc98bb7fb", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/26736112391" }, { "r": "4.6.0", "os": "linux", "version": "0.2.0.9032", "date": "2026-06-01T05:06:21.000Z", "distro": "noble", "commit": "e3e445ef4952ee9698f486adad73dba4ce2ad0fd", "fileid": "36bc968ba6bae4039ff23cb51c8ef293056bd34c140288c23d7b2db160ded657", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/26736112391" }, { "r": "4.5.3", "os": "mac", "version": "0.2.0.9032", "date": "2026-06-01T05:06:15.000Z", "commit": "e3e445ef4952ee9698f486adad73dba4ce2ad0fd", "fileid": "5ff0384eec12220f80630a4d1321e210c6ead04af86c0ab7486bb9119be929eb", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/26736112391" }, { "r": "4.6.0", "os": "mac", "version": "0.2.0.9032", "date": "2026-06-01T05:06:20.000Z", "commit": "e3e445ef4952ee9698f486adad73dba4ce2ad0fd", "fileid": "b50ed63f8e14b745b4ca3bc2ba8ff3285681b45336a45be8c7918e7937219b70", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/26736112391" }, { "r": "4.6.0", "os": "wasm", "version": "0.2.0.9032", "date": "2026-06-01T05:06:23.000Z", "commit": "e3e445ef4952ee9698f486adad73dba4ce2ad0fd", "fileid": "56f3d094c199bc3e8fb92450f9b8cf41712dec1984aa1c5771707a3a478efcb2", "status": "success", "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/26736112391" }, { "r": "4.7.0", "os": "win", "version": "0.2.0.9032", "date": "2026-06-01T05:05:14.000Z", "commit": "e3e445ef4952ee9698f486adad73dba4ce2ad0fd", "fileid": "0e7fc1d3a1c84f588c22af4679ec9c3e8ce9413b5eb22e9510aaf2ca9dacf471", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/26736112391" }, { "r": "4.5.3", "os": "win", "version": "0.2.0.9032", "date": "2026-06-01T05:05:15.000Z", "commit": "e3e445ef4952ee9698f486adad73dba4ce2ad0fd", "fileid": "d3d434623bf506b339d2b100fc8dfe8ebdbe5487137062fb35fe6bf8094f7ad7", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/26736112391" }, { "r": "4.6.0", "os": "win", "version": "0.2.0.9032", "date": "2026-06-01T05:05:17.000Z", "commit": "e3e445ef4952ee9698f486adad73dba4ce2ad0fd", "fileid": "a4345aadb4d30bb2cd8ed0e23146c976c677a355dc1d3ab078cdfdd818a60646", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/26736112391" } ] }