{
  "_id": "6a20116bb401979e73449211",
  "Package": "RD1",
  "Title": "DBI Client and API Wrapper for Cloudflare D1",
  "Version": "0.0.0.9000",
  "Authors@R": "person(\"Noam\", \"Ross\", , \"noam.ross+rd1@gmail.com\", role = c(\"aut\", \"cre\"))",
  "Description": "A DBI-compliant database interface and API client for\nCloudflare D1's serverless SQLite database. Provides wrappers\nfor D1 REST API endpoints, including time travel and\nbookmark-based restoration, plus convenience functions for\ncommon multi-step workflows such as exporting and downloading\ndatabases.",
  "License": "MIT + file LICENSE",
  "Config/testthat/edition": "3",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "8.0.0",
  "Config/pak/sysreqs": "libssl-dev",
  "Repository": "https://noamross.r-universe.dev",
  "Date/Publication": "2026-06-02 14:26:12 UTC",
  "RemoteUrl": "https://github.com/noamross/RD1",
  "RemoteRef": "HEAD",
  "RemoteSha": "477cb2664e79a050eec222e2c35f58bee9577cd9",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-06-03 11:31:32 UTC",
    "User": "root"
  },
  "Author": "Noam Ross [aut, cre]",
  "Maintainer": "Noam Ross <noam.ross+rd1@gmail.com>",
  "MD5sum": "15c9f3e2c8c646cdf02ad56975c47e23",
  "_user": "noamross",
  "_type": "src",
  "_file": "RD1_0.0.0.9000.tar.gz",
  "_fileid": "d4ee96483a4fd7646cab4961109f00726f0321968a90ab7230a7b54bb7048eb2",
  "_filesize": 147698,
  "_sha256": "d4ee96483a4fd7646cab4961109f00726f0321968a90ab7230a7b54bb7048eb2",
  "_created": "2026-06-03T11:31:32.000Z",
  "_published": "2026-06-03T11:35:07.466Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 79283923457,
      "time": 178,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7383408074"
    },
    {
      "job": 79283923420,
      "time": 115,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7383386198"
    },
    {
      "job": 79283923409,
      "time": 107,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7383383198"
    },
    {
      "job": 79283923491,
      "time": 85,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7383375866"
    },
    {
      "job": 79283422341,
      "time": 178,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7383345334"
    },
    {
      "job": 79283923413,
      "time": 105,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7383382575"
    },
    {
      "job": 79283923444,
      "time": 82,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7383375238"
    },
    {
      "job": 79283923446,
      "time": 74,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7383372480"
    },
    {
      "job": 79283923428,
      "time": 72,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7383371281"
    }
  ],
  "_buildurl": "https://github.com/r-universe/noamross/actions/runs/26881769185",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/noamross/RD1",
  "_commit": {
    "id": "477cb2664e79a050eec222e2c35f58bee9577cd9",
    "author": "Noam Ross <noam.ross@gmail.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "Fix typo in README install instructions",
    "time": 1780410372
  },
  "_maintainer": {
    "name": "Noam Ross",
    "email": "noam.ross+rd1@gmail.com",
    "login": "noamross",
    "mastodon": "@noamross@ecoevo.social",
    "bluesky": "@noamross.net",
    "description": "Computational Disease Ecologist, Executive Director of @ropensci, consulting in forecasting, One Health, #RStats + open-source science",
    "uuid": 571752
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.1.0",
      "role": "Depends"
    },
    {
      "package": "cli",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "httr2",
      "role": "Imports"
    },
    {
      "package": "methods",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "role": "Imports"
    },
    {
      "package": "DBItest",
      "role": "Suggests"
    },
    {
      "package": "dbplyr",
      "role": "Suggests"
    },
    {
      "package": "dplyr",
      "role": "Suggests"
    },
    {
      "package": "RSQLite",
      "role": "Suggests"
    },
    {
      "package": "rstudioapi",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "role": "Suggests"
    },
    {
      "package": "withr",
      "role": "Suggests"
    }
  ],
  "_owner": "noamross",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2026-22",
      "n": 8
    },
    {
      "week": "2026-23",
      "n": 1
    }
  ],
  "_tags": [],
  "_stars": 0,
  "_contributors": [
    {
      "user": "noamross",
      "count": 9,
      "uuid": 571752
    }
  ],
  "_userbio": {
    "uuid": 571752,
    "type": "user",
    "name": "Noam Ross",
    "description": "Computational Disease Ecologist, Executive Director of @ropensci, consulting in forecasting, One Health, #RStats + open-source science"
  },
  "_downloads": {
    "count": 0,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/RD1"
  },
  "_devurl": "https://github.com/noamross/rd1",
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/RD1.html",
    "extra/readme.html",
    "extra/readme.md",
    "manual.pdf"
  ],
  "_cranurl": false,
  "_exports": [
    "d1",
    "D1",
    "d1_account",
    "d1_bookmark",
    "d1_create_database",
    "d1_database_id",
    "d1_delete_database",
    "d1_download",
    "d1_download_sqlite",
    "d1_export",
    "d1_get_database",
    "d1_import",
    "d1_list_databases",
    "d1_pane",
    "d1_query",
    "d1_raw",
    "d1_restore",
    "d1_set_replication",
    "d1_token",
    "d1_upload_sqlite",
    "dbConnect",
    "Rd1",
    "RD1"
  ],
  "_help": [
    {
      "page": "credentials",
      "title": "Cloudflare credentials",
      "topics": [
        "credentials",
        "d1_account",
        "d1_token"
      ]
    },
    {
      "page": "d1",
      "title": "RD1 DBI driver",
      "topics": [
        "D1",
        "d1",
        "D1Driver-class",
        "dbConnect,D1Driver-method",
        "RD1",
        "Rd1"
      ]
    },
    {
      "page": "d1_bookmark",
      "title": "Time travel: bookmarks and restoration",
      "topics": [
        "d1_bookmark",
        "d1_restore"
      ]
    },
    {
      "page": "d1_database_id",
      "title": "Resolve a database name to its UUID",
      "topics": [
        "d1_database_id"
      ]
    },
    {
      "page": "d1_export",
      "title": "Export a D1 database",
      "topics": [
        "d1_download",
        "d1_download_sqlite",
        "d1_export"
      ]
    },
    {
      "page": "d1_import",
      "title": "Import SQL into a D1 database",
      "topics": [
        "d1_import",
        "d1_upload_sqlite"
      ]
    },
    {
      "page": "d1_list_databases",
      "title": "Manage D1 databases",
      "topics": [
        "d1_create_database",
        "d1_delete_database",
        "d1_get_database",
        "d1_list_databases",
        "d1_set_replication"
      ]
    },
    {
      "page": "d1_pane",
      "title": "Show a D1 connection in the Connections pane",
      "topics": [
        "d1_pane"
      ]
    },
    {
      "page": "d1_query",
      "title": "Run SQL against a D1 database",
      "topics": [
        "d1_query",
        "d1_raw"
      ]
    },
    {
      "page": "D1Connection-class",
      "title": "D1 DBI connection",
      "topics": [
        "D1Connection-class"
      ]
    },
    {
      "page": "D1Result-class",
      "title": "D1 DBI result",
      "topics": [
        "D1Result-class"
      ]
    }
  ],
  "_readme": "https://github.com/noamross/RD1/raw/HEAD/README.md",
  "_rundeps": [
    "askpass",
    "cli",
    "curl",
    "DBI",
    "glue",
    "httr2",
    "lifecycle",
    "magrittr",
    "openssl",
    "R6",
    "rappdirs",
    "rlang",
    "sys",
    "vctrs",
    "withr"
  ],
  "_score": 2,
  "_indexed": true,
  "_nocasepkg": "rd1",
  "_universes": [
    "noamross"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.0.0.9000",
      "date": "2026-06-03T11:34:31.000Z",
      "distro": "noble",
      "commit": "477cb2664e79a050eec222e2c35f58bee9577cd9",
      "fileid": "1054202eeb173294e354d7e78adc5fe0f9d9636974ee18d95227136ea4c0e015",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/noamross/actions/runs/26881769185"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.0.0.9000",
      "date": "2026-06-03T11:33:28.000Z",
      "distro": "noble",
      "commit": "477cb2664e79a050eec222e2c35f58bee9577cd9",
      "fileid": "ceb06a244bed327ddcc8ea204c1bf2ac94760ed6e6218030111c1129af8b2cad",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/noamross/actions/runs/26881769185"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.0.0.9000",
      "date": "2026-06-03T11:33:22.000Z",
      "commit": "477cb2664e79a050eec222e2c35f58bee9577cd9",
      "fileid": "57747c1e22fe1f1104fbd466ad8aeb58fe22737745972c8ff622eec0d7e1e5ce",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/noamross/actions/runs/26881769185"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.0.0.9000",
      "date": "2026-06-03T11:33:01.000Z",
      "commit": "477cb2664e79a050eec222e2c35f58bee9577cd9",
      "fileid": "1512a3b2872f018fd0aa199abfce9dcdca4220897475c4ebf2a91e47a996251f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/noamross/actions/runs/26881769185"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.0.0.9000",
      "date": "2026-06-03T11:33:33.000Z",
      "commit": "477cb2664e79a050eec222e2c35f58bee9577cd9",
      "fileid": "caa89cd95ebd186274c05a407f8077c2a8c8572c2760f872c0eb03c6f4deb08e",
      "status": "success",
      "buildurl": "https://github.com/r-universe/noamross/actions/runs/26881769185"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.0.0.9000",
      "date": "2026-06-03T11:32:53.000Z",
      "commit": "477cb2664e79a050eec222e2c35f58bee9577cd9",
      "fileid": "e890ed870c3e47f7d9b2c3cf0e73e0f0a3856f98b0210e25088b416b887134f0",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/noamross/actions/runs/26881769185"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.0.0.9000",
      "date": "2026-06-03T11:32:44.000Z",
      "commit": "477cb2664e79a050eec222e2c35f58bee9577cd9",
      "fileid": "a36fa5aade2035403e418b0438526b83c0395f35e516486b8fb409aba57e1e0c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/noamross/actions/runs/26881769185"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.0.0.9000",
      "date": "2026-06-03T11:32:41.000Z",
      "commit": "477cb2664e79a050eec222e2c35f58bee9577cd9",
      "fileid": "ed339d582c50f00c1eb1273ccfaa07e442ac67a20bde1929efd75442c1f6d4b5",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/noamross/actions/runs/26881769185"
    }
  ]
}