{
  "_id": "6ae30ca08d250e7ad09efa65",
  "Package": "arkdb",
  "Version": "0.0.19",
  "Title": "Archive and Unarchive Databases Using Flat Files",
  "Description": "Flat text files provide a robust, compressible, and\nportable way to store tables from databases.  This package\nprovides convenient functions for exporting tables from\nrelational database connections into compressed text files and\nstreaming those text files back into a database without\nrequiring the whole table to fit in working memory.",
  "Authors@R": "c(person(\"Carl\", \"Boettiger\", \nemail = \"cboettig@gmail.com\",\nrole = c(\"aut\", \"cre\", \"cph\"),\ncomment=c(ORCID = \"0000-0002-1642-628X\")),\nperson(\"Richard\", \"FitzJohn\", role = \"ctb\"),\nperson(\"Brandon\", \"Bertelsen\", email=\"brandon@bertelsen.ca\", role = \"ctb\"))",
  "URL": "https://github.com/ropensci/arkdb,\nhttps://docs.ropensci.org/arkdb/",
  "BugReports": "https://github.com/ropensci/arkdb/issues",
  "License": "MIT + file LICENSE",
  "Encoding": "UTF-8",
  "ByteCompile": "true",
  "VignetteBuilder": "knitr",
  "RoxygenNote": "7.3.3",
  "Roxygen": "list(markdown = TRUE)",
  "Language": "en-US",
  "Repository": "https://ropensci.r-universe.dev",
  "Date/Publication": "2026-02-09 15:07:47 UTC",
  "RemoteUrl": "https://github.com/ropensci/arkdb",
  "RemoteRef": "HEAD",
  "RemoteSha": "1dda73d138f51536d8958462d01650c19dec88d1",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-29 08:30:33 UTC",
    "User": "root"
  },
  "Author": "Carl Boettiger [aut, cre, cph] (ORCID:\n<https://orcid.org/0000-0002-1642-628X>),\nRichard FitzJohn [ctb],\nBrandon Bertelsen [ctb]",
  "Maintainer": "Carl Boettiger <cboettig@gmail.com>",
  "_user": "ropensci",
  "_type": "src",
  "_file": "arkdb_0.0.19.tar.gz",
  "_fileid": "https://r2.ropensci.org/f12a1d69bbdb0caa356245118bc62e64de9087314ff5678310e31f6f77d954f8",
  "_filesize": 226575,
  "_sha256": "f12a1d69bbdb0caa356245118bc62e64de9087314ff5678310e31f6f77d954f8",
  "_expires": "2027-02-06T09:06:39.000Z",
  "_created": "2026-10-29T08:30:33.000Z",
  "_published": "2026-10-29T09:06:40.639Z",
  "_upstream": "https://github.com/ropensci/arkdb",
  "_status": "success",
  "_maintainer": {
    "name": "Carl Boettiger",
    "email": "cboettig@gmail.com",
    "login": "cboettig",
    "mastodon": "@cboettig@ecoevo.social",
    "bluesky": "@cboettig.bsky.social",
    "orcid": "0000-0002-1642-628X",
    "description": "",
    "uuid": 222586
  },
  "_jobs": [
    {
      "job": 123342608650,
      "time": 183,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12883537061"
    },
    {
      "job": 123342608576,
      "time": 171,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12883881149"
    },
    {
      "job": 123342608790,
      "time": 2077,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "12885447013"
    },
    {
      "job": 123342608714,
      "time": 159,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12883652260"
    },
    {
      "job": 123340959854,
      "time": 217,
      "config": "pkgdown",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "12883815938"
    },
    {
      "job": 123340959964,
      "time": 244,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12883706217"
    },
    {
      "job": 123342608527,
      "time": 106,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "12883362644"
    },
    {
      "job": 123342608804,
      "time": 139,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12883183365"
    },
    {
      "job": 123342608644,
      "time": 135,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "12883232755"
    },
    {
      "job": 123342608633,
      "time": 128,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12883711521"
    }
  ],
  "_buildurl": "https://github.com/r-universe/ropensci/actions/runs/40842148595",
  "_commit": {
    "id": "1dda73d138f51536d8958462d01650c19dec88d1",
    "author": "Carl Boettiger <cboettig@berkeley.edu>",
    "committer": "Carl Boettiger <cboettig@berkeley.edu>",
    "message": "fix docs\n",
    "time": 1770649667
  },
  "_distro": "resolute",
  "_host": "GitHub-Actions",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.0",
      "role": "Depends"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "tools",
      "role": "Imports"
    },
    {
      "package": "utils",
      "role": "Imports"
    },
    {
      "package": "arrow",
      "role": "Suggests"
    },
    {
      "package": "R.utils",
      "role": "Suggests"
    },
    {
      "package": "progress",
      "role": "Suggests"
    },
    {
      "package": "readr",
      "role": "Suggests"
    },
    {
      "package": "spelling",
      "role": "Suggests"
    },
    {
      "package": "dplyr",
      "role": "Suggests"
    },
    {
      "package": "dbplyr",
      "role": "Suggests"
    },
    {
      "package": "nycflights13",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "covr",
      "role": "Suggests"
    },
    {
      "package": "fs",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "RSQLite",
      "role": "Suggests"
    },
    {
      "package": "duckdb",
      "role": "Suggests"
    },
    {
      "package": "vroom",
      "role": "Suggests"
    },
    {
      "package": "utf8",
      "role": "Suggests"
    },
    {
      "package": "future.apply",
      "role": "Suggests"
    }
  ],
  "_owner": "ropensci",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2025-47",
      "n": 1
    },
    {
      "week": "2026-07",
      "n": 1
    }
  ],
  "_tags": [],
  "_topics": [
    "archiving",
    "database",
    "dbi",
    "peer-reviewed"
  ],
  "_stars": 80,
  "_contributors": [
    {
      "user": "cboettig",
      "count": 189,
      "uuid": 222586
    },
    {
      "user": "1beb",
      "count": 54,
      "uuid": 421859
    },
    {
      "user": "jennybc",
      "count": 3,
      "uuid": 599454
    },
    {
      "user": "hadley",
      "count": 1,
      "uuid": 4196
    },
    {
      "user": "jeroen",
      "count": 1,
      "uuid": 216319
    },
    {
      "user": "noamross",
      "count": 1,
      "uuid": 571752
    },
    {
      "user": "olivroy",
      "count": 1,
      "uuid": 52606734
    }
  ],
  "_userbio": {
    "uuid": 1200269,
    "type": "organization",
    "name": "rOpenSci",
    "followers": 1166,
    "description": "Tools and R Packages for Open Science"
  },
  "_downloads": {
    "count": 617,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/arkdb"
  },
  "_devurl": "https://github.com/ropensci/arkdb",
  "_pkgdown": "https://docs.ropensci.org/arkdb",
  "_searchresults": 0,
  "_metadata": {
    "review": {
      "id": 224,
      "status": "reviewed",
      "version": "0.0.0.9000",
      "organization": "rOpenSci Software Review",
      "url": "https://github.com/ropensci/software-review/issues/224"
    },
    "ropensci_category": "databases"
  },
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/arkdb.html",
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "LICENSE"
  ],
  "_homeurl": "https://github.com/ropensci/arkdb",
  "_realowner": "ropensci",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.0.1",
      "date": "2018-08-20"
    },
    {
      "version": "0.0.2",
      "date": "2018-08-20"
    },
    {
      "version": "0.0.3",
      "date": "2018-09-11"
    },
    {
      "version": "0.0.4",
      "date": "2018-09-27"
    },
    {
      "version": "0.0.5",
      "date": "2018-10-31"
    },
    {
      "version": "0.0.6",
      "date": "2020-09-18"
    },
    {
      "version": "0.0.7",
      "date": "2020-10-15"
    },
    {
      "version": "0.0.8",
      "date": "2020-11-04"
    },
    {
      "version": "0.0.10",
      "date": "2021-03-05"
    },
    {
      "version": "0.0.11",
      "date": "2021-03-14"
    },
    {
      "version": "0.0.12",
      "date": "2021-04-05"
    },
    {
      "version": "0.0.13",
      "date": "2021-10-15"
    },
    {
      "version": "0.0.14",
      "date": "2021-10-18"
    },
    {
      "version": "0.0.15",
      "date": "2022-02-15"
    },
    {
      "version": "0.0.16",
      "date": "2022-09-09"
    },
    {
      "version": "0.0.17",
      "date": "2024-01-09"
    },
    {
      "version": "0.0.18",
      "date": "2024-01-16"
    },
    {
      "version": "0.0.19",
      "date": "2026-02-16"
    }
  ],
  "_exports": [
    "ark",
    "arkdb_delete_db",
    "local_db",
    "local_db_disconnect",
    "process_chunks",
    "streamable_base_csv",
    "streamable_base_tsv",
    "streamable_parquet",
    "streamable_readr_csv",
    "streamable_readr_tsv",
    "streamable_table",
    "streamable_vroom",
    "unark"
  ],
  "_help": [
    {
      "page": "arkdb-package",
      "title": "arkdb: Archive and Unarchive Databases Using Flat Files",
      "topics": [
        "arkdb-package",
        "arkdb"
      ]
    },
    {
      "page": "ark",
      "title": "Archive tables from a database as flat files",
      "topics": [
        "ark"
      ]
    },
    {
      "page": "arkdb_delete_db",
      "title": "delete the local arkdb database",
      "topics": [
        "arkdb_delete_db"
      ]
    },
    {
      "page": "local_db",
      "title": "Connect to a local stand-alone database",
      "topics": [
        "local_db"
      ]
    },
    {
      "page": "local_db_disconnect",
      "title": "Disconnect from the arkdb database.",
      "topics": [
        "local_db_disconnect"
      ]
    },
    {
      "page": "process_chunks",
      "title": "process a table in chunks",
      "topics": [
        "process_chunks"
      ]
    },
    {
      "page": "streamable_base_csv",
      "title": "streamable csv using base R functions",
      "topics": [
        "streamable_base_csv"
      ]
    },
    {
      "page": "streamable_base_tsv",
      "title": "streamable tsv using base R functions",
      "topics": [
        "streamable_base_tsv"
      ]
    },
    {
      "page": "streamable_parquet",
      "title": "streamable chunked parquet using 'arrow'",
      "topics": [
        "streamable_parquet"
      ]
    },
    {
      "page": "streamable_readr_csv",
      "title": "streamable csv using 'readr'",
      "topics": [
        "streamable_readr_csv"
      ]
    },
    {
      "page": "streamable_readr_tsv",
      "title": "streamable tsv using 'readr'",
      "topics": [
        "streamable_readr_tsv"
      ]
    },
    {
      "page": "streamable_table",
      "title": "streamable table",
      "topics": [
        "streamable_table"
      ]
    },
    {
      "page": "streamable_vroom",
      "title": "streamable tables using 'vroom'",
      "topics": [
        "streamable_vroom"
      ]
    },
    {
      "page": "unark",
      "title": "Unarchive a list of compressed tsv files into a database",
      "topics": [
        "unark"
      ]
    }
  ],
  "_pkglogo": "https://github.com/ropensci/arkdb/raw/HEAD/man/figures/logo.svg",
  "_readme": "https://github.com/ropensci/arkdb/raw/HEAD/README.md",
  "_rundeps": [
    "DBI"
  ],
  "_vignettes": [
    {
      "source": "arkdb.Rmd",
      "filename": "arkdb.html",
      "title": "Introduction to arkdb",
      "author": "Carl Boettiger",
      "engine": "knitr::rmarkdown",
      "headings": [
        "arkdb",
        "Package rationale",
        "Installation",
        "Tutorial",
        "Creating an archive of an existing database",
        "Unarchive",
        "Pluggable text formats",
        "A note on compression",
        "Distributing data"
      ],
      "created": "2018-07-07 03:58:19",
      "modified": "2025-11-20 16:44:06",
      "commits": 9
    }
  ],
  "_score": 6.681241237375588,
  "_indexed": true,
  "_nocasepkg": "arkdb",
  "_universes": [
    "ropensci",
    "cboettig"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.0.19",
      "date": "2026-10-29T08:33:01.000Z",
      "distro": "resolute",
      "commit": "1dda73d138f51536d8958462d01650c19dec88d1",
      "fileid": "https://r2.ropensci.org/829c757dd7cb3a3e210859f4154aa74451bbb9be2056789b075714c38d3561de",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/40842148595"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.0.19",
      "date": "2026-10-29T08:32:48.000Z",
      "distro": "resolute",
      "commit": "1dda73d138f51536d8958462d01650c19dec88d1",
      "fileid": "https://r2.ropensci.org/159c30f6ce86dea7e24119ef476dfa94ecee39eaebb4f1bc04523ba529de0a4c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/40842148595"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.0.19",
      "date": "2026-10-29T09:05:17.000Z",
      "commit": "1dda73d138f51536d8958462d01650c19dec88d1",
      "fileid": "https://r2.ropensci.org/434487bb143f7b2af3e0b31c001b9720134bef9ff75ea5611759ce90f0940ca4",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/40842148595"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.0.19",
      "date": "2026-10-29T08:33:10.000Z",
      "commit": "1dda73d138f51536d8958462d01650c19dec88d1",
      "fileid": "https://r2.ropensci.org/c75c3f30776a68375e0c88116ec45f74f899190038c4d28184fdaf2acb64897f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/40842148595"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.0.19",
      "date": "2026-10-29T08:32:42.000Z",
      "commit": "1dda73d138f51536d8958462d01650c19dec88d1",
      "fileid": "https://r2.ropensci.org/7854a1ecc858f44ca59361b459d8b603373576b220f9c179dc952b00a7d3d9ed",
      "status": "success",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/40842148595"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.0.19",
      "date": "2026-10-29T08:31:50.000Z",
      "commit": "1dda73d138f51536d8958462d01650c19dec88d1",
      "fileid": "https://r2.ropensci.org/e33862247e845ad8a9b86487c44830c9b245249ac6c20b34a9f4a83362110b90",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/40842148595"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.0.19",
      "date": "2026-10-29T08:31:49.000Z",
      "commit": "1dda73d138f51536d8958462d01650c19dec88d1",
      "fileid": "https://r2.ropensci.org/33f2aeb1bfd7cf01d7f7d472e3c9ec174ec4f3233d40769d0136a23bf0746409",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/40842148595"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.0.19",
      "date": "2026-10-29T08:31:57.000Z",
      "commit": "1dda73d138f51536d8958462d01650c19dec88d1",
      "fileid": "https://r2.ropensci.org/efb0e0e9e573e80981a46af713e8d2684ebb669f76687645fd73386c5c2dd510",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/40842148595"
    }
  ]
}