{
  "_id": "6a5b3c829baadeef8ab4d001",
  "Package": "dbflobr",
  "Title": "Read and Write Files to SQLite Databases",
  "Version": "0.2.2.9003",
  "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 = \"evanamiesgalonski@gmail.com\",\ncomment = c(ORCID = \"0000-0003-1096-2089\")),\nperson(given = \"Poisson Consulting\",\nrole = c(\"cph\", \"fnd\")))",
  "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",
  "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-07-15 07:36:59 UTC",
  "RemoteUrl": "https://github.com/poissonconsulting/dbflobr",
  "RemoteRef": "HEAD",
  "RemoteSha": "763d6798e911b2d3bbb00aa7b3077b36ca94a161",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-07-18 08:38:24 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.9003.tar.gz",
  "_fileid": "https://r2.ropensci.org/79ed59d88f7c839907b7a74b79a529a305bd15bce59b0f9fc1ca73c2012efc0c",
  "_filesize": 953983,
  "_sha256": "79ed59d88f7c839907b7a74b79a529a305bd15bce59b0f9fc1ca73c2012efc0c",
  "_expires": "2026-10-26T08:42:40.000Z",
  "_created": "2026-07-18T08:38:24.000Z",
  "_published": "2026-07-18T08:42:42.786Z",
  "_jobs": [
    {
      "job": 88063085267,
      "time": 171,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "8427673603"
    },
    {
      "job": 88063085271,
      "time": 156,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "8427671224"
    },
    {
      "job": 88063085244,
      "time": 120,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "8427676952"
    },
    {
      "job": 88063085248,
      "time": 119,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "8427681530"
    },
    {
      "job": 88062884626,
      "time": 158,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "8427646451"
    },
    {
      "job": 88063085239,
      "time": 103,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "8427662966"
    },
    {
      "job": 88063085284,
      "time": 117,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "8427665020"
    },
    {
      "job": 88063085288,
      "time": 116,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "8427664940"
    },
    {
      "job": 88063085322,
      "time": 114,
      "config": "windows-release",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "8427664640"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/29637719521",
  "_status": "success",
  "_upstream": "https://github.com/poissonconsulting/dbflobr",
  "_commit": {
    "id": "763d6798e911b2d3bbb00aa7b3077b36ca94a161",
    "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": "Bump version to 0.2.2.9003\n",
    "time": 1784101019
  },
  "_maintainer": {
    "name": "Evan Amies-Galonski",
    "email": "evanamiesgalonski@gmail.com",
    "login": "evanamiesgalonski",
    "description": "Computational Biologist",
    "uuid": 14318875,
    "orcid": "0000-0003-1096-2089"
  },
  "_distro": "resolute",
  "_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
    }
  ],
  "_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"
    }
  ],
  "_topics": [
    "blob",
    "databases",
    "flob",
    "sqlite"
  ],
  "_stars": 5,
  "_contributors": [
    {
      "user": "joethorley",
      "count": 87,
      "uuid": 613671
    },
    {
      "user": "sebdalgarno",
      "count": 82,
      "uuid": 15878432
    },
    {
      "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.",
    "followers": 27,
    "description": "Computational Biology and Statistical Ecology"
  },
  "_downloads": {
    "count": 34,
    "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/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "LICENSE",
    "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.8750612633917,
  "_indexed": true,
  "_nocasepkg": "dbflobr",
  "_universes": [
    "poissonconsulting",
    "evanamiesgalonski"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.2.2.9003",
      "date": "2026-07-18T08:40:43.000Z",
      "distro": "resolute",
      "commit": "763d6798e911b2d3bbb00aa7b3077b36ca94a161",
      "fileid": "https://r2.ropensci.org/8ee74bd66f0f8cdcbf42f325ca344ef4fc4e3ba51b5851d2e91870af3673084a",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/29637719521"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.2.2.9003",
      "date": "2026-07-18T08:40:26.000Z",
      "distro": "resolute",
      "commit": "763d6798e911b2d3bbb00aa7b3077b36ca94a161",
      "fileid": "https://r2.ropensci.org/b1ec0fddba39643e635b4d586d094ee1a02163877512c6e774169d5cc8d307ff",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/29637719521"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.2.2.9003",
      "date": "2026-07-18T08:41:09.000Z",
      "commit": "763d6798e911b2d3bbb00aa7b3077b36ca94a161",
      "fileid": "https://r2.ropensci.org/dc40e937ca510e627652c351bbd375504cd0bc3e7af2ff743e52909f06d84451",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/29637719521"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.2.2.9003",
      "date": "2026-07-18T08:41:39.000Z",
      "commit": "763d6798e911b2d3bbb00aa7b3077b36ca94a161",
      "fileid": "https://r2.ropensci.org/54617093265b8e9ac1cffcf868cf59f6a2a31b65c1c56b7de687781a717f4dd1",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/29637719521"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.2.2.9003",
      "date": "2026-07-18T08:40:22.000Z",
      "commit": "763d6798e911b2d3bbb00aa7b3077b36ca94a161",
      "fileid": "https://r2.ropensci.org/68789d1864c8d8bcba8de520471a97fba9421c53020cb88ef74ecdf53024fcfa",
      "status": "success",
      "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/29637719521"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.2.2.9003",
      "date": "2026-07-18T08:39:34.000Z",
      "commit": "763d6798e911b2d3bbb00aa7b3077b36ca94a161",
      "fileid": "https://r2.ropensci.org/b6008adcd050233009a2177d090b36606801cd04e09d8df5b8fdb2280bfdbb62",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/29637719521"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.2.2.9003",
      "date": "2026-07-18T08:39:27.000Z",
      "commit": "763d6798e911b2d3bbb00aa7b3077b36ca94a161",
      "fileid": "https://r2.ropensci.org/fab7a2ceedbd294dd91f6c87f8cd033a590a22375fa0b3a2403827be4131aa0d",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/29637719521"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.2.2.9003",
      "date": "2026-07-18T08:39:28.000Z",
      "commit": "763d6798e911b2d3bbb00aa7b3077b36ca94a161",
      "fileid": "https://r2.ropensci.org/2758348cab23b489fbb04464f3d16d4f211cf298e69dca855f94b01b4b33d897",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/poissonconsulting/actions/runs/29637719521"
    }
  ]
}