{
  "_id": "6ab8512499f7aa8c6aa35103",
  "Package": "mdbr",
  "Title": "Work with Microsoft Access Files",
  "Version": "0.4.0.9000",
  "Authors@R": "c(\nperson(\"Kiernan\", \"Nicholls\", email = \"k5cents@gmail.com\", role = c(\"aut\", \"cre\", \"cph\"),\ncomment = c(ORCID = \"0000-0002-9229-7897\")),\nperson(\"Bruno\", \"Tremblay\", email = \"cran@neoxone.com\", role = c(\"ctb\"),\ncomment = \"DBI interface and bundled mdbtools source\"))",
  "Description": "Work with Microsoft Access '.mdb' and '.accdb' files using\nthe open source 'MDB Tools' library\n<https://github.com/mdbtools/mdbtools/>. The library is\ncompiled and bundled with the package, so no external\ninstallation is required. Provides high-level helpers for\nreading tables, exporting to CSV or JSON, inspecting table\ndefinitions, and running SQL queries. Also exposes a full\nread-only 'DBI' interface for use with standard database\nworkflows.",
  "License": "GPL-3 | LGPL-2",
  "URL": "https://k5cents.github.io/mdbr/, https://github.com/k5cents/mdbr,\nhttps://github.com/mdbtools/mdbtools/",
  "BugReports": "https://github.com/k5cents/mdbr/issues",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "NeedsCompilation": "yes",
  "SystemRequirements": "GNU make",
  "Config/testthat/edition": "3",
  "Config/roxygen2/version": "8.0.0",
  "Config/pak/sysreqs": "make",
  "Repository": "https://k5cents.r-universe.dev",
  "Date/Publication": "2026-09-26 21:16:09 UTC",
  "RemoteUrl": "https://github.com/k5cents/mdbr",
  "RemoteRef": "HEAD",
  "RemoteSha": "7dd826c6b70d563a396ee4b9d817be22ca9789c4",
  "Packaged": {
    "Date": "2026-09-26 23:04:11 UTC",
    "User": "root"
  },
  "Author": "Kiernan Nicholls [aut, cre, cph] (ORCID:\n<https://orcid.org/0000-0002-9229-7897>),\nBruno Tremblay [ctb] (DBI interface and bundled mdbtools source)",
  "Maintainer": "Kiernan Nicholls <k5cents@gmail.com>",
  "_user": "k5cents",
  "_type": "src",
  "_file": "mdbr_0.4.0.9000.tar.gz",
  "_fileid": "https://r2.ropensci.org/d33f911439a09d340459089543f75b72011259d45d1668a812ad3214c78f592c",
  "_filesize": 1391907,
  "_sha256": "d33f911439a09d340459089543f75b72011259d45d1668a812ad3214c78f592c",
  "_expires": "2027-01-04T23:11:30.000Z",
  "_created": "2026-09-26T23:04:11.000Z",
  "_published": "2026-09-26T23:11:32.154Z",
  "_jobs": [
    {
      "job": 108505179181,
      "time": 135,
      "config": "linux-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "10916999955"
    },
    {
      "job": 108505179175,
      "time": 139,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "10918212001"
    },
    {
      "job": 108505179213,
      "time": 175,
      "config": "linux-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10917827132"
    },
    {
      "job": 108505179225,
      "time": 202,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10918660368"
    },
    {
      "job": 108505179244,
      "time": 125,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "10918410195"
    },
    {
      "job": 108505179197,
      "time": 371,
      "config": "macos-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "10918326211"
    },
    {
      "job": 108505179205,
      "time": 97,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10918365735"
    },
    {
      "job": 108505179173,
      "time": 228,
      "config": "macos-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10917886758"
    },
    {
      "job": 108504559749,
      "time": 248,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10918305723"
    },
    {
      "job": 108505179098,
      "time": 118,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "10918235923"
    },
    {
      "job": 108505179191,
      "time": 233,
      "config": "windows-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "10918011600"
    },
    {
      "job": 108505179222,
      "time": 138,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "10917827089"
    },
    {
      "job": 108505179212,
      "time": 79,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "10918111223"
    },
    {
      "job": 108505179233,
      "time": 228,
      "config": "windows-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10916974983"
    },
    {
      "job": 108505179221,
      "time": 120,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10918520026"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/k5cents/actions/runs/36278059954",
  "_status": "success",
  "_upstream": "https://github.com/k5cents/mdbr",
  "_commit": {
    "id": "7dd826c6b70d563a396ee4b9d817be22ca9789c4",
    "author": "Kiernan Nicholls <k5cents@gmail.com>",
    "committer": "Kiernan Nicholls <k5cents@gmail.com>",
    "message": "Increment version number to 0.4.0.9000\n\nCo-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>\n",
    "time": 1790457369
  },
  "_maintainer": {
    "name": "Kiernan Nicholls",
    "email": "k5cents@gmail.com",
    "login": "k5cents",
    "bluesky": "@k5cents.com",
    "linkedin": "in/k5cents",
    "twitter": "@k5cents",
    "description": "Political data analyst",
    "uuid": 18021678,
    "orcid": "0000-0002-9229-7897"
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "lifecycle",
      "role": "Imports"
    },
    {
      "package": "methods",
      "role": "Imports"
    },
    {
      "package": "tibble",
      "role": "Imports"
    },
    {
      "package": "utils",
      "role": "Imports"
    },
    {
      "package": "jsonlite",
      "role": "Imports"
    },
    {
      "package": "readr",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    }
  ],
  "_owner": "k5cents",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2026-21",
      "n": 15
    },
    {
      "week": "2026-29",
      "n": 4
    },
    {
      "week": "2026-39",
      "n": 7
    }
  ],
  "_tags": [
    {
      "name": "v0.4.0",
      "date": "2026-09-26"
    }
  ],
  "_topics": [
    "mdb",
    "microsoft-access"
  ],
  "_stars": 14,
  "_contributors": [
    {
      "user": "k5cents",
      "count": 115,
      "uuid": 18021678
    },
    {
      "user": "meztez",
      "count": 38,
      "uuid": 31039074
    },
    {
      "user": "xlai",
      "count": 1,
      "uuid": 6449900
    }
  ],
  "_userbio": {
    "uuid": 18021678,
    "type": "user",
    "name": "Kiernan Nicholls",
    "followers": 31,
    "description": "Political data analyst"
  },
  "_downloads": {
    "count": 505,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/mdbr"
  },
  "_devurl": "https://github.com/k5cents/mdbr",
  "_pkgdown": "https://k5cents.github.io/mdbr/",
  "_searchresults": 20,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/mdbr.html",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md"
  ],
  "_homeurl": "https://github.com/k5cents/mdbr",
  "_realowner": "k5cents",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.1.2",
      "date": "2020-11-09"
    },
    {
      "version": "0.2.1",
      "date": "2024-03-12"
    },
    {
      "version": "0.3.0",
      "date": "2026-05-23"
    },
    {
      "version": "0.3.1",
      "date": "2026-05-28"
    },
    {
      "version": "0.3.2",
      "date": "2026-07-18"
    },
    {
      "version": "0.4.0",
      "date": "2026-09-26"
    }
  ],
  "_exports": [
    "export_mdb",
    "mdb",
    "mdb_array",
    "mdb_count",
    "mdb_example",
    "mdb_export",
    "mdb_header",
    "mdb_hexdump",
    "mdb_json",
    "mdb_prop",
    "mdb_queries",
    "mdb_schema",
    "mdb_sql",
    "mdb_stream_table",
    "mdb_tables",
    "mdb_ver",
    "read_mdb"
  ],
  "_help": [
    {
      "page": "export_mdb",
      "title": "Export an Access database table as a text file",
      "topics": [
        "export_mdb"
      ]
    },
    {
      "page": "mdb",
      "title": "Create an mdbr DBI Driver",
      "topics": [
        "mdb"
      ]
    },
    {
      "page": "mdb_array",
      "title": "Export Table As List Columns (mdb-array mimic)",
      "topics": [
        "mdb_array"
      ]
    },
    {
      "page": "mdb_count",
      "title": "Count Rows In Table",
      "topics": [
        "mdb_count"
      ]
    },
    {
      "page": "mdb_example",
      "title": "Get path to mdbr example",
      "topics": [
        "mdb_example"
      ]
    },
    {
      "page": "mdb_export",
      "title": "Export Data In An MDB Table To CSV Or INSERT SQL",
      "topics": [
        "mdb_export"
      ]
    },
    {
      "page": "mdb_header",
      "title": "MDB Header Summary (mdb-header mimic)",
      "topics": [
        "mdb_header"
      ]
    },
    {
      "page": "mdb_hexdump",
      "title": "Hexdump MDB File (mdb-hexdump mimic)",
      "topics": [
        "mdb_hexdump"
      ]
    },
    {
      "page": "mdb_json",
      "title": "Export Data In An MDB Table To JSON",
      "topics": [
        "mdb_json"
      ]
    },
    {
      "page": "mdb_prop",
      "title": "Get Properties List From MDB Database",
      "topics": [
        "mdb_prop"
      ]
    },
    {
      "page": "mdb_queries",
      "title": "List Or Retrieve Queries In An MDB Database",
      "topics": [
        "mdb_queries"
      ]
    },
    {
      "page": "mdb_schema",
      "title": "Generate Schema DDL or Column Types",
      "topics": [
        "mdb_schema"
      ]
    },
    {
      "page": "mdb_sql",
      "title": "SQL Interface To MDB Tools",
      "topics": [
        "mdb_sql"
      ]
    },
    {
      "page": "mdb_stream_table",
      "title": "Open a streaming cursor for an Access table",
      "topics": [
        "mdb_stream_table"
      ]
    },
    {
      "page": "mdb_tables",
      "title": "List tables in a Microsoft Access database",
      "topics": [
        "mdb_tables"
      ]
    },
    {
      "page": "mdb_ver",
      "title": "Return MDB File Format Or MDB Tools Version",
      "topics": [
        "mdb_ver"
      ]
    },
    {
      "page": "print.mdblist",
      "title": "Print Method For 'mdblist'",
      "topics": [
        "print.mdblist"
      ]
    },
    {
      "page": "read_mdb",
      "title": "Read a table as data frame",
      "topics": [
        "read_mdb"
      ]
    }
  ],
  "_pkglogo": "https://github.com/k5cents/mdbr/raw/HEAD/man/figures/logo.png",
  "_readme": "https://github.com/k5cents/mdbr/raw/HEAD/README.md",
  "_rundeps": [
    "cli",
    "DBI",
    "glue",
    "jsonlite",
    "lifecycle",
    "magrittr",
    "pillar",
    "pkgconfig",
    "rlang",
    "tibble",
    "utf8",
    "vctrs"
  ],
  "_score": 4.924279286061882,
  "_indexed": true,
  "_nocasepkg": "mdbr",
  "_universes": [
    "k5cents"
  ],
  "_previous": "0.4.0",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.4.0.9000",
      "date": "2026-09-26T23:06:35.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "7dd826c6b70d563a396ee4b9d817be22ca9789c4",
      "fileid": "https://r2.ropensci.org/4a23d4af010da905e771fcd8d3f81cbdfbd16820de804824b1c35fce3b013b65",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/k5cents/actions/runs/36278059954"
    },
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.4.0.9000",
      "date": "2026-09-26T23:07:07.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "7dd826c6b70d563a396ee4b9d817be22ca9789c4",
      "fileid": "https://r2.ropensci.org/d1042434df52b60f0450219938da4ba4c5ee0d5f8cab070a785c347d42874d8c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/k5cents/actions/runs/36278059954"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.4.0.9000",
      "date": "2026-09-26T23:07:13.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "7dd826c6b70d563a396ee4b9d817be22ca9789c4",
      "fileid": "https://r2.ropensci.org/f5e9c7e47052e798a8324f5b4cc44045dc35831938679a2d96846969a88b32cb",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/k5cents/actions/runs/36278059954"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.4.0.9000",
      "date": "2026-09-26T23:07:30.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "7dd826c6b70d563a396ee4b9d817be22ca9789c4",
      "fileid": "https://r2.ropensci.org/b963121b56724bfd266c7ceaf292846b34226be931a17a0e174ba20fb2ab886a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/k5cents/actions/runs/36278059954"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.4.0.9000",
      "date": "2026-09-26T23:06:21.000Z",
      "arch": "aarch64",
      "commit": "7dd826c6b70d563a396ee4b9d817be22ca9789c4",
      "fileid": "https://r2.ropensci.org/ce866ca6996b85b03f8e353484a91e0df41810907ce2c434d18d85179db57cbc",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/k5cents/actions/runs/36278059954"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.4.0.9000",
      "date": "2026-09-26T23:09:01.000Z",
      "arch": "x86_64",
      "commit": "7dd826c6b70d563a396ee4b9d817be22ca9789c4",
      "fileid": "https://r2.ropensci.org/60d9b83e3ffee1995723efb3eb2fd1bb43b3833c18f49c5c9b3ffbd961d948b0",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/k5cents/actions/runs/36278059954"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.4.0.9000",
      "date": "2026-09-26T23:05:59.000Z",
      "arch": "aarch64",
      "commit": "7dd826c6b70d563a396ee4b9d817be22ca9789c4",
      "fileid": "https://r2.ropensci.org/1b6fb9651324b60e2a12dad1a493642657d6dc670420258dad9ad01f21d9a168",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/k5cents/actions/runs/36278059954"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.4.0.9000",
      "date": "2026-09-26T23:07:33.000Z",
      "arch": "x86_64",
      "commit": "7dd826c6b70d563a396ee4b9d817be22ca9789c4",
      "fileid": "https://r2.ropensci.org/c5d0b905e9298bdae4d3c40ae71716b6ef1cf4799e91908d6a021c3792763b45",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/k5cents/actions/runs/36278059954"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.4.0.9000",
      "date": "2026-09-26T23:06:32.000Z",
      "arch": "emscripten",
      "commit": "7dd826c6b70d563a396ee4b9d817be22ca9789c4",
      "fileid": "https://r2.ropensci.org/c54e007a1b6999fea0f15b4c2e9a86d796adfc8aa4bc9395aaa486c4eac1c509",
      "status": "success",
      "buildurl": "https://github.com/r-universe/k5cents/actions/runs/36278059954"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.4.0.9000",
      "date": "2026-09-26T23:07:48.000Z",
      "arch": "aarch64",
      "commit": "7dd826c6b70d563a396ee4b9d817be22ca9789c4",
      "fileid": "https://r2.ropensci.org/d949d85ceaa7bbeb1b5f9423b96c0f47c224039afbb41f576c4ad48c3364ada8",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/k5cents/actions/runs/36278059954"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.4.0.9000",
      "date": "2026-09-26T23:05:38.000Z",
      "arch": "x86_64",
      "commit": "7dd826c6b70d563a396ee4b9d817be22ca9789c4",
      "fileid": "https://r2.ropensci.org/18f079f870c47d2cdfb6d9fa38a570bae23134faa80a67c5522083422f31e236",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/k5cents/actions/runs/36278059954"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.4.0.9000",
      "date": "2026-09-26T23:05:18.000Z",
      "arch": "x86_64",
      "commit": "7dd826c6b70d563a396ee4b9d817be22ca9789c4",
      "fileid": "https://r2.ropensci.org/8bd9cfb8de30eb4f9309313acc2db8e9cb0cfecd01c9ce8d80f75c3533e780bf",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/k5cents/actions/runs/36278059954"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.4.0.9000",
      "date": "2026-09-26T23:07:46.000Z",
      "arch": "aarch64",
      "commit": "7dd826c6b70d563a396ee4b9d817be22ca9789c4",
      "fileid": "https://r2.ropensci.org/162e866b9cea2c8e92e38443725697de040477d7dbf0452f8c68569a3cd344b8",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/k5cents/actions/runs/36278059954"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.4.0.9000",
      "date": "2026-09-26T23:05:48.000Z",
      "arch": "x86_64",
      "commit": "7dd826c6b70d563a396ee4b9d817be22ca9789c4",
      "fileid": "https://r2.ropensci.org/61009b347915520bede6c736bfb9714e1f859a33de353c48dde846d7471129d0",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/k5cents/actions/runs/36278059954"
    }
  ]
}