{
  "_id": "6ad740954b18b900899997f3",
  "Package": "dbflobr",
  "Title": "Read and Write Files to SQLite Databases",
  "Version": "0.2.2.9007",
  "Authors@R": "c(\nperson(\"Sebastian\", \"Dalgarno\", , \"seb@northbeachconsulting.ca\", role = \"aut\",\ncomment = c(ORCID = \"0000-0002-3658-4517\")),\nperson(\"Joe\", \"Thorley\", , \"joe@poissonconsulting.ca\", role = \"aut\",\ncomment = c(ORCID = \"0000-0002-7683-4592\")),\nperson(\"Evan\", \"Amies-Galonski\", , \"evanamiesgalonski@gmail.com\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0003-1096-2089\")),\nperson(\"Poisson Consulting\", role = c(\"cph\", \"fnd\"))\n)",
  "Description": "Reads and writes files to SQLite databases\n<https://www.sqlite.org/index.html> 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",
  "Remotes": [
    "poissonconsulting/flobr"
  ],
  "Config/Needs/website": "poissonconsulting/poissontemplate",
  "Config/testthat/edition": "3",
  "Encoding": "UTF-8",
  "Language": "en-US",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "7.3.2",
  "Repository": "https://poissonconsulting.r-universe.dev",
  "Date/Publication": "2026-10-20 07:25:35 UTC",
  "RemoteUrl": "https://github.com/poissonconsulting/dbflobr",
  "RemoteRef": "HEAD",
  "RemoteSha": "ee2a9b8b42b4403b8b1fd2df38f3583245db676e",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-20 10:17:45 UTC",
    "User": "root"
  },
  "Author": "Sebastian Dalgarno [aut] (ORCID:\n<https://orcid.org/0000-0002-3658-4517>),\nJoe Thorley [aut] (ORCID: <https://orcid.org/0000-0002-7683-4592>),\nEvan Amies-Galonski [aut, cre] (ORCID:\n<https://orcid.org/0000-0003-1096-2089>),\nPoisson Consulting [cph, fnd]",
  "Maintainer": "Evan Amies-Galonski <evanamiesgalonski@gmail.com>",
  "_user": "poissonconsulting",
  "_type": "src",
  "_file": "dbflobr_0.2.2.9007.tar.gz",
  "_fileid": "https://r2.ropensci.org/a4541839c1f0cb1da03c9d0afe5500e3839bd5bc450b95334aa554a46e009913",
  "_filesize": 954596,
  "_sha256": "a4541839c1f0cb1da03c9d0afe5500e3839bd5bc450b95334aa554a46e009913",
  "_expires": "2027-01-28T10:21:07.000Z",
  "_created": "2026-10-20T10:17:45.000Z",
  "_published": "2026-10-20T10:21:09.386Z",
  "_upstream": "https://github.com/poissonconsulting/dbflobr",
  "_status": "success",
  "_maintainer": {
    "name": "Evan Amies-Galonski",
    "email": "evanamiesgalonski@gmail.com",
    "login": "evanamiesgalonski",
    "description": "Computational Biologist",
    "uuid": 14318875,
    "orcid": "0000-0003-1096-2089"
  },
  "_jobs": [
    {
      "job": 118575113795,
      "time": 157,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "12256943387"
    },
    {
      "job": 118575113757,
      "time": 140,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "12257083268"
    },
    {
      "job": 118575113661,
      "time": 141,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "12256798573"
    },
    {
      "job": 118575113738,
      "time": 126,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "12256938215"
    },
    {
      "job": 118573767709,
      "time": 202,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12257891526"
    },
    {
      "job": 118575113619,
      "time": 86,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "12257047989"
    },
    {
      "job": 118575113711,
      "time": 127,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "12258166457"
    },
    {
      "job": 118575113767,
      "time": 95,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "12257856838"
    },
    {
      "job": 118575113743,
      "time": 86,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "12257691841"
    }
  ],
  "_buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/39406515499",
  "_commit": {
    "id": "ee2a9b8b42b4403b8b1fd2df38f3583245db676e",
    "author": "poisson-fledge-bot[bot] <294483614+poisson-fledge-bot[bot]@users.noreply.github.com>",
    "committer": "poisson-fledge-bot[bot] <294483614+poisson-fledge-bot[bot]@users.noreply.github.com>",
    "message": "fledge: Bump version to 0.2.2.9007\n",
    "time": 1792481135
  },
  "_distro": "resolute",
  "_host": "GitHub-Actions",
  "_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
    },
    {
      "week": "2026-24",
      "n": 1
    },
    {
      "week": "2026-25",
      "n": 2
    },
    {
      "week": "2026-26",
      "n": 2
    },
    {
      "week": "2026-27",
      "n": 2
    },
    {
      "week": "2026-29",
      "n": 2
    },
    {
      "week": "2026-41",
      "n": 4
    },
    {
      "week": "2026-42",
      "n": 2
    },
    {
      "week": "2026-43",
      "n": 2
    }
  ],
  "_tags": [
    {
      "name": "v0.2.2.9000",
      "date": "2026-06-18"
    },
    {
      "name": "v0.2.2.9001",
      "date": "2026-06-26"
    },
    {
      "name": "v0.2.2.9002",
      "date": "2026-07-04"
    },
    {
      "name": "v0.2.2.9003",
      "date": "2026-07-15"
    },
    {
      "name": "v0.2.2.9005",
      "date": "2026-10-10"
    },
    {
      "name": "v0.2.2.9006",
      "date": "2026-10-16"
    },
    {
      "name": "v0.2.2.9007",
      "date": "2026-10-20"
    }
  ],
  "_topics": [
    "blob",
    "databases",
    "flob",
    "sqlite"
  ],
  "_stars": 5,
  "_contributors": [
    {
      "user": "joethorley",
      "count": 92,
      "uuid": 613671
    },
    {
      "user": "sebdalgarno",
      "count": 82,
      "uuid": 15878432
    },
    {
      "user": "evanamiesgalonski",
      "count": 33,
      "uuid": 14318875
    },
    {
      "user": "nadinehussein",
      "count": 7,
      "uuid": 74937983
    },
    {
      "user": "olivroy",
      "count": 5,
      "uuid": 52606734
    },
    {
      "user": "aylapear",
      "count": 1,
      "uuid": 42985574
    }
  ],
  "_userbio": {
    "uuid": 1679318,
    "type": "organization",
    "name": "Poisson Consulting Ltd.",
    "followers": 27,
    "description": "Computational Biology and Statistical Ecology"
  },
  "_downloads": {
    "count": 92,
    "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.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/dbflobr.html",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "LICENSE"
  ],
  "_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": 5.051152522447381,
  "_indexed": true,
  "_nocasepkg": "dbflobr",
  "_universes": [
    "poissonconsulting",
    "evanamiesgalonski"
  ],
  "_previous": "0.2.2.9006",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.2.2.9007",
      "date": "2026-10-20T10:19:46.000Z",
      "distro": "resolute",
      "commit": "ee2a9b8b42b4403b8b1fd2df38f3583245db676e",
      "fileid": "https://r2.ropensci.org/0d6c93d9138ba832ed1c52022ce2bf2a51ae4781e51b4ad70cb45a0da02f6276",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/39406515499"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.2.2.9007",
      "date": "2026-10-20T10:19:35.000Z",
      "distro": "resolute",
      "commit": "ee2a9b8b42b4403b8b1fd2df38f3583245db676e",
      "fileid": "https://r2.ropensci.org/ae2fc9ba09c8c172026a6ed5d55293a1cd2203797c624bf7a6e8126f9c6d91c1",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/39406515499"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.2.2.9007",
      "date": "2026-10-20T10:19:41.000Z",
      "commit": "ee2a9b8b42b4403b8b1fd2df38f3583245db676e",
      "fileid": "https://r2.ropensci.org/749df032fa14e763f08408f2cc4afb0b3d2c18dfbe3da1541adb1644fb4a2709",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/39406515499"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.2.2.9007",
      "date": "2026-10-20T10:19:28.000Z",
      "commit": "ee2a9b8b42b4403b8b1fd2df38f3583245db676e",
      "fileid": "https://r2.ropensci.org/45c04c9a5b1c01ce47d8418d143b45016bd5db724df45345910f15669ac0858e",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/39406515499"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.2.2.9007",
      "date": "2026-10-20T10:19:32.000Z",
      "commit": "ee2a9b8b42b4403b8b1fd2df38f3583245db676e",
      "fileid": "https://r2.ropensci.org/07d072d2980d0d785e4a3afbaa3a6afd1a77878974897877c04c3269ed0f8ee5",
      "status": "success",
      "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/39406515499"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.2.2.9007",
      "date": "2026-10-20T10:19:00.000Z",
      "commit": "ee2a9b8b42b4403b8b1fd2df38f3583245db676e",
      "fileid": "https://r2.ropensci.org/d915cb9459114fbd21a97ff0bc6c560dd41e1ceafc5f3b0b47b473c48610ea41",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/39406515499"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.2.2.9007",
      "date": "2026-10-20T10:18:54.000Z",
      "commit": "ee2a9b8b42b4403b8b1fd2df38f3583245db676e",
      "fileid": "https://r2.ropensci.org/f9d474e93a50fdea46d2515a7a3f31defeb3514775af02f1c638d5b82ce11aed",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/39406515499"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.2.2.9007",
      "date": "2026-10-20T10:18:47.000Z",
      "commit": "ee2a9b8b42b4403b8b1fd2df38f3583245db676e",
      "fileid": "https://r2.ropensci.org/471965c64799c971766331b155fab30259a8c731dbf5d8ee74db4fe2a166f5f7",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/39406515499"
    }
  ]
}