{ "_id": "6a25fadd794753ddbc3e28c4", "Package": "dbflobr", "Title": "Read and Write Files to SQLite Databases", "Version": "0.2.2", "Authors@R": "c(person(given = \"Sebastian\",\nfamily = \"Dalgarno\",\nrole = \"aut\",\nemail = \"seb@northbeachconsulting.ca\",\ncomment = c(ORCID = \"0000-0002-3658-4517\")),\nperson(given = \"Joe\",\nfamily = \"Thorley\",\nrole = \"aut\",\nemail = \"joe@poissonconsulting.ca\",\ncomment = c(ORCID = \"0000-0002-7683-4592\")),\nperson(given = \"Evan\",\nfamily = \"Amies-Galonski\",\nrole = c(\"aut\", \"cre\"),\nemail = \"evan@poissonconsulting.ca\",\ncomment = c(ORCID = \"0000-0003-1096-2089\")),\nperson(given = \"Poisson Consulting\",\nrole = c(\"cph\", \"fnd\")))", "Description": "Reads and writes files to SQLite databases\n as flobs (a flob is a blob\nthat preserves the file extension).", "License": "MIT + file LICENSE", "URL": "https://github.com/poissonconsulting/dbflobr,\nhttps://poissonconsulting.github.io/dbflobr/", "BugReports": "https://github.com/poissonconsulting/dbflobr/issues", "VignetteBuilder": "knitr", "Encoding": "UTF-8", "Language": "en-US", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.2", "Config/testthat/edition": "3", "Config/Needs/website": "poissonconsulting/poissontemplate", "Repository": "https://poissonconsulting.r-universe.dev", "Date/Publication": "2026-06-05 22:41:24 UTC", "RemoteUrl": "https://github.com/poissonconsulting/dbflobr", "RemoteRef": "HEAD", "RemoteSha": "1443021606e9ef271fcb0705b35cce4ead7db2d8", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-07 23:09:18 UTC", "User": "root" }, "Author": "Sebastian Dalgarno [aut] (ORCID:\n),\nJoe Thorley [aut] (ORCID: ),\nEvan Amies-Galonski [aut, cre] (ORCID:\n),\nPoisson Consulting [cph, fnd]", "Maintainer": "Evan Amies-Galonski ", "MD5sum": "91361a3bbfbbfac02a4bc1b05c5100a8", "_user": "poissonconsulting", "_type": "src", "_file": "dbflobr_0.2.2.tar.gz", "_fileid": "63a06f19960174433553313987a2cd0b1ab618ba14947ab65aa927ca218b2c3c", "_filesize": 953504, "_sha256": "63a06f19960174433553313987a2cd0b1ab618ba14947ab65aa927ca218b2c3c", "_created": "2026-06-07T23:09:18.000Z", "_published": "2026-06-07T23:12:29.602Z", "_distro": "noble", "_jobs": [ { "job": 79999572350, "time": 159, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "7468912868" }, { "job": 79999572347, "time": 148, "config": "linux-release-x86_64", "r": "4.6.0", "check": "NOTE", "artifact": "7468911745" }, { "job": 79999572360, "time": 119, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "NOTE", "artifact": "7468908203" }, { "job": 79999572352, "time": 112, "config": "macos-release-arm64", "r": "4.6.0", "check": "NOTE", "artifact": "7468907365" }, { "job": 79999387984, "time": 186, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7468893661" }, { "job": 79999572337, "time": 109, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7468906968" }, { "job": 79999572356, "time": 112, "config": "windows-devel", "r": "4.7.0", "check": "NOTE", "artifact": "7468907405" }, { "job": 79999572355, "time": 120, "config": "windows-oldrel", "r": "4.5.3", "check": "NOTE", "artifact": "7468908451" }, { "job": 79999572359, "time": 117, "config": "windows-release", "r": "4.6.0", "check": "NOTE", "artifact": "7468908032" } ], "_buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/27107573780", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/poissonconsulting/dbflobr", "_commit": { "id": "1443021606e9ef271fcb0705b35cce4ead7db2d8", "author": "Joe Thorley ", "committer": "GitHub ", "message": "Merge pull request #31 from poissonconsulting/add-codeowners\n\nAdd CODEOWNERS assigning @joethorley", "time": 1780699284 }, "_maintainer": { "name": "Evan Amies-Galonski", "email": "evan@poissonconsulting.ca", "login": "evanamiesgalonski", "description": "Computational Biologist", "uuid": 14318875, "orcid": "0000-0003-1096-2089" }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.5", "role": "Depends" }, { "package": "blob", "role": "Imports" }, { "package": "chk", "role": "Imports" }, { "package": "cli", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "flobr", "role": "Imports" }, { "package": "glue", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "RSQLite", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "withr", "role": "Suggests" } ], "_owner": "poissonconsulting", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2026-23", "n": 1 } ], "_tags": [], "_topics": [ "blob", "databases", "flob", "sqlite" ], "_stars": 5, "_contributors": [ { "user": "sebdalgarno", "count": 82, "uuid": 15878432 }, { "user": "joethorley", "count": 81, "uuid": 613671 }, { "user": "evanamiesgalonski", "count": 33, "uuid": 14318875 }, { "user": "olivroy", "count": 5, "uuid": 52606734 }, { "user": "nadinehussein", "count": 4, "uuid": 74937983 }, { "user": "aylapear", "count": 1, "uuid": 42985574 } ], "_userbio": { "uuid": 1679318, "type": "organization", "name": "Poisson Consulting Ltd.", "description": "Computational Biology and Statistical Ecology" }, "_downloads": { "count": 22, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/dbflobr" }, "_devurl": "https://github.com/poissonconsulting/dbflobr", "_pkgdown": "https://poissonconsulting.github.io/dbflobr/", "_searchresults": 5, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/dbflobr.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_cranurl": false, "_releases": [ { "version": "0.0.1", "date": "2019-08-24" }, { "version": "0.1.0", "date": "2020-05-13" }, { "version": "0.2.1", "date": "2021-10-30" }, { "version": "0.2.2", "date": "2022-08-19" } ], "_exports": [ "add_blob_column", "delete_flob", "import_all_flobs", "import_flobs", "read_flob", "save_all_flobs", "save_flobs", "write_flob" ], "_help": [ { "page": "add_blob_column", "title": "Add blob column", "topics": [ "add_blob_column" ] }, { "page": "delete_flob", "title": "Delete flob", "topics": [ "delete_flob" ] }, { "page": "import_all_flobs", "title": "Import all flobs.", "topics": [ "import_all_flobs" ] }, { "page": "import_flobs", "title": "Import flobs.", "topics": [ "import_flobs" ] }, { "page": "read_flob", "title": "Read flob", "topics": [ "read_flob" ] }, { "page": "save_all_flobs", "title": "Save all flobs.", "topics": [ "save_all_flobs" ] }, { "page": "save_flobs", "title": "Save flobs.", "topics": [ "save_flobs" ] }, { "page": "write_flob", "title": "Write flob", "topics": [ "write_flob" ] } ], "_pkglogo": "https://github.com/poissonconsulting/dbflobr/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/poissonconsulting/dbflobr/raw/HEAD/README.md", "_rundeps": [ "bit", "bit64", "blob", "cachem", "chk", "cli", "cpp11", "DBI", "fastmap", "flobr", "glue", "lifecycle", "memoise", "pkgconfig", "rlang", "RSQLite", "vctrs" ], "_vignettes": [ { "source": "vignette.Rmd", "filename": "vignette.html", "title": "Batching flobs", "engine": "knitr::rmarkdown", "headings": [ "Batch exporting and importing flobs for an sqlite database", "Saving flobs from a database", "Importing flobs back into a database", "Working with individual tables and columns" ], "created": "2020-05-07 22:00:40", "modified": "2020-12-15 01:07:06", "commits": 2 } ], "_score": 4.096910013008056, "_indexed": true, "_nocasepkg": "dbflobr", "_universes": [ "poissonconsulting", "evanamiesgalonski" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.2.2", "date": "2026-06-07T23:11:22.000Z", "distro": "noble", "commit": "1443021606e9ef271fcb0705b35cce4ead7db2d8", "fileid": "420057db35a8760dd7209bc97cfe07f5999b683c6c011905458d0fd6f1658ff5", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/27107573780" }, { "r": "4.6.0", "os": "linux", "version": "0.2.2", "date": "2026-06-07T23:11:14.000Z", "distro": "noble", "commit": "1443021606e9ef271fcb0705b35cce4ead7db2d8", "fileid": "865c3d70f9d62d109458f4c4e4cda7e8806354c64543a125dc172f503f95409f", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/27107573780" }, { "r": "4.5.3", "os": "mac", "version": "0.2.2", "date": "2026-06-07T23:10:49.000Z", "commit": "1443021606e9ef271fcb0705b35cce4ead7db2d8", "fileid": "de446e74c3eec4ffc944779cf430ec9700fd14c2ab36d829477ff4c88db3f1a6", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/27107573780" }, { "r": "4.6.0", "os": "mac", "version": "0.2.2", "date": "2026-06-07T23:10:50.000Z", "commit": "1443021606e9ef271fcb0705b35cce4ead7db2d8", "fileid": "63ed8ad4d834ea0677a1e5a3d39bc21aaacc74657cab51b0a7f19fcab395f76e", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/27107573780" }, { "r": "4.6.0", "os": "wasm", "version": "0.2.2", "date": "2026-06-07T23:11:23.000Z", "commit": "1443021606e9ef271fcb0705b35cce4ead7db2d8", "fileid": "6187a934bb0c8b3538700da955422fd598068a84267666a387d9bfd99ff265ec", "status": "success", "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/27107573780" }, { "r": "4.7.0", "os": "win", "version": "0.2.2", "date": "2026-06-07T23:10:24.000Z", "commit": "1443021606e9ef271fcb0705b35cce4ead7db2d8", "fileid": "c0f6eb33128b05efb7ae7d84fc4def1087bca412613a1b2c3d52106aa26a05ee", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/27107573780" }, { "r": "4.5.3", "os": "win", "version": "0.2.2", "date": "2026-06-07T23:10:23.000Z", "commit": "1443021606e9ef271fcb0705b35cce4ead7db2d8", "fileid": "45d4ab2ab78d0fe07e8ec2e374912b1c757a503cc170497d9c2510ca54e403a2", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/27107573780" }, { "r": "4.6.0", "os": "win", "version": "0.2.2", "date": "2026-06-07T23:10:26.000Z", "commit": "1443021606e9ef271fcb0705b35cce4ead7db2d8", "fileid": "e62c757fc782d13e552db7063e4c562f1422198741afc21770a17637d2128cef", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/27107573780" } ] }