{
  "_id": "6ab5003cc18b73ce90b4e0f4",
  "Package": "nodbi",
  "Title": "Document 'NoSQL' Database DBI Connector",
  "Description": "R database connector for creating, reading (querying and\nlisting fields), updating and deleting of individual or many\nJSON documents, providing a common API across supported\ndatabases ('SQLite', 'PostgreSQL', 'DuckDB', 'MariaDB' or\n'MySQL' as well as 'NoSQL' databases 'MongoDB', 'CouchDB' and\n'Elasticsearch').",
  "Version": "0.15.0.9000",
  "Authors@R": "c(\nperson(\"Ralf\", \"Herold\", role = c(\"aut\", \"cre\"),\nemail = \"ralf.herold@mailbox.org\",\ncomment = c(ORCID = \"0000-0002-8148-6748\")),\nperson(\"Scott\", \"Chamberlain\", role = \"aut\",\ncomment = c(ORCID = \"0000-0003-1444-9135\")),\nperson(\"Rich\", \"FitzJohn\", role = \"aut\"),\nperson(\"Jeroen\", \"Ooms\", role = \"aut\"),\nperson(\"Ivan\", \"Tarbakou\", role = \"cph\",\ncomment = \"mongo-to-sql-converter library\")\n)",
  "License": "MIT + file LICENSE",
  "LazyData": "true",
  "URL": "https://docs.ropensci.org/nodbi/,\nhttps://github.com/ropensci/nodbi",
  "BugReports": "https://github.com/ropensci/nodbi/issues",
  "Roxygen": "list(markdown = TRUE)",
  "Encoding": "UTF-8",
  "Language": "en-US",
  "VignetteBuilder": "knitr",
  "Config/roxygen2/version": "8.1.0",
  "Config/pak/sysreqs": "libicu-dev libjq-dev libssl-dev libnode-dev",
  "Repository": "https://ropensci.r-universe.dev",
  "Date/Publication": "2026-08-25 15:35:26 UTC",
  "RemoteUrl": "https://github.com/ropensci/nodbi",
  "RemoteRef": "master",
  "RemoteSha": "b69c7ad1f40e1063152aba0dd1dfbbf04c28e13d",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-09-24 10:33:01 UTC",
    "User": "root"
  },
  "Author": "Ralf Herold [aut, cre] (ORCID: <https://orcid.org/0000-0002-8148-6748>),\nScott Chamberlain [aut] (ORCID:\n<https://orcid.org/0000-0003-1444-9135>),\nRich FitzJohn [aut],\nJeroen Ooms [aut],\nIvan Tarbakou [cph] (mongo-to-sql-converter library)",
  "Maintainer": "Ralf Herold <ralf.herold@mailbox.org>",
  "_user": "ropensci",
  "_type": "src",
  "_file": "nodbi_0.15.0.9000.tar.gz",
  "_fileid": "https://r2.ropensci.org/fde22511ea24fb77d7a03242d7a085e1b716fdb28272392aac3dae2ec065647b",
  "_filesize": 588761,
  "_sha256": "fde22511ea24fb77d7a03242d7a085e1b716fdb28272392aac3dae2ec065647b",
  "_expires": "2027-01-02T10:49:30.000Z",
  "_created": "2026-09-24T10:33:01.000Z",
  "_published": "2026-09-24T10:49:32.201Z",
  "_jobs": [
    {
      "job": 107594793223,
      "time": 157,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "10802916547"
    },
    {
      "job": 107594793079,
      "time": 150,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10802748361"
    },
    {
      "job": 107594793098,
      "time": 76,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "10803451375"
    },
    {
      "job": 107594793106,
      "time": 101,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10803696321"
    },
    {
      "job": 107593043652,
      "time": 190,
      "config": "pkgdown",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "10802319987"
    },
    {
      "job": 107593043694,
      "time": 314,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10802534268"
    },
    {
      "job": 107594793041,
      "time": 125,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "10802703680"
    },
    {
      "job": 107594793096,
      "time": 89,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "10803305824"
    },
    {
      "job": 107594793147,
      "time": 100,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "10803560120"
    },
    {
      "job": 107594793105,
      "time": 164,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10802808174"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/ropensci/actions/runs/35987181944",
  "_status": "success",
  "_upstream": "https://github.com/ropensci/nodbi",
  "_commit": {
    "id": "b69c7ad1f40e1063152aba0dd1dfbbf04c28e13d",
    "author": "Ralf Herold <ralf.herold@gmx.net>",
    "committer": "Ralf Herold <ralf.herold@gmx.net>",
    "message": "pkgdown update\n",
    "time": 1787672126
  },
  "_maintainer": {
    "name": "Ralf Herold",
    "email": "ralf.herold@mailbox.org",
    "login": "rfhb",
    "mastodon": "@rfhb@mastodon.online",
    "bluesky": "@rfhb.bsky.social",
    "linkedin": "in/ralfherold",
    "orcid": "0000-0002-8148-6748",
    "description": "",
    "uuid": 626690
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.0.0",
      "role": "Depends"
    },
    {
      "package": "stringi",
      "role": "Imports"
    },
    {
      "package": "jsonlite",
      "role": "Imports"
    },
    {
      "package": "uuid",
      "role": "Imports"
    },
    {
      "package": "jqr",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "V8",
      "role": "Imports"
    },
    {
      "package": "R.utils",
      "role": "Imports"
    },
    {
      "package": "sofa",
      "version": ">= 0.4.0",
      "role": "Suggests"
    },
    {
      "package": "elastic",
      "version": ">= 1.2.0",
      "role": "Suggests"
    },
    {
      "package": "mongolite",
      "version": ">= 4.0.0",
      "role": "Suggests"
    },
    {
      "package": "RSQLite",
      "version": ">= 2.4.0",
      "role": "Suggests"
    },
    {
      "package": "RMariaDB",
      "version": ">= 1.3.0",
      "role": "Suggests"
    },
    {
      "package": "duckdb",
      "version": ">= 1.4.0",
      "role": "Suggests"
    },
    {
      "package": "RPostgres",
      "version": ">= 1.4.8",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "role": "Suggests"
    },
    {
      "package": "withr",
      "role": "Suggests"
    },
    {
      "package": "callr",
      "role": "Suggests"
    },
    {
      "package": "webfakes",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "tibble",
      "role": "Suggests"
    }
  ],
  "_owner": "ropensci",
  "_selfowned": true,
  "_usedby": 1,
  "_updates": [
    {
      "week": "2025-42",
      "n": 1
    },
    {
      "week": "2025-48",
      "n": 8
    },
    {
      "week": "2025-49",
      "n": 7
    },
    {
      "week": "2026-03",
      "n": 3
    },
    {
      "week": "2026-08",
      "n": 1
    },
    {
      "week": "2026-16",
      "n": 4
    },
    {
      "week": "2026-23",
      "n": 1
    },
    {
      "week": "2026-25",
      "n": 1
    },
    {
      "week": "2026-28",
      "n": 6
    },
    {
      "week": "2026-30",
      "n": 7
    },
    {
      "week": "2026-33",
      "n": 8
    },
    {
      "week": "2026-34",
      "n": 2
    },
    {
      "week": "2026-35",
      "n": 4
    }
  ],
  "_tags": [
    {
      "name": "v0.14.0",
      "date": "2025-12-07"
    },
    {
      "name": "v0.15.0",
      "date": "2026-08-25"
    }
  ],
  "_topics": [
    "database",
    "mongodb",
    "elasticsearch",
    "couchdb",
    "sqlite",
    "postgresql",
    "mariadb",
    "mysql",
    "duckdb",
    "nosql",
    "json",
    "documents"
  ],
  "_stars": 75,
  "_contributors": [
    {
      "user": "rfhb",
      "count": 501,
      "uuid": 626690
    },
    {
      "user": "sckott",
      "count": 164,
      "uuid": 577668
    },
    {
      "user": "richfitz",
      "count": 7,
      "uuid": 1558093
    },
    {
      "user": "drtagkim",
      "count": 2,
      "uuid": 6837240
    },
    {
      "user": "jeroen",
      "count": 1,
      "uuid": 216319
    }
  ],
  "_userbio": {
    "uuid": 1200269,
    "type": "organization",
    "name": "rOpenSci",
    "followers": 1155,
    "description": "Tools and R Packages for Open Science"
  },
  "_downloads": {
    "count": 755,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/nodbi"
  },
  "_devurl": "https://github.com/ropensci/nodbi",
  "_pkgdown": "https://docs.ropensci.org/nodbi/",
  "_searchresults": 37,
  "_metadata": {
    "ropensci_category": "databases"
  },
  "_rbuild": "4.6.1",
  "_assets": [
    "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/nodbi.html",
    "extra/readme.html",
    "extra/readme.md",
    "LICENSE"
  ],
  "_homeurl": "https://github.com/ropensci/nodbi",
  "_realowner": "ropensci",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.1.0",
      "date": "2018-08-01"
    },
    {
      "version": "0.2.0",
      "date": "2019-04-13"
    },
    {
      "version": "0.3.0",
      "date": "2019-09-18"
    },
    {
      "version": "0.4.0",
      "date": "2019-11-12"
    },
    {
      "version": "0.4.2",
      "date": "2021-01-15"
    },
    {
      "version": "0.4.3",
      "date": "2021-07-23"
    },
    {
      "version": "0.5.0",
      "date": "2021-11-21"
    },
    {
      "version": "0.5.1",
      "date": "2021-11-26"
    },
    {
      "version": "0.6.0",
      "date": "2021-12-01"
    },
    {
      "version": "0.7.0",
      "date": "2022-01-04"
    },
    {
      "version": "0.7.1",
      "date": "2022-05-04"
    },
    {
      "version": "0.8.0",
      "date": "2022-06-12"
    },
    {
      "version": "0.8.1",
      "date": "2022-07-01"
    },
    {
      "version": "0.9.0",
      "date": "2022-10-31"
    },
    {
      "version": "0.9.1",
      "date": "2022-11-21"
    },
    {
      "version": "0.9.2",
      "date": "2023-03-26"
    },
    {
      "version": "0.9.3",
      "date": "2023-04-23"
    },
    {
      "version": "0.9.4",
      "date": "2023-05-14"
    },
    {
      "version": "0.9.5",
      "date": "2023-05-26"
    },
    {
      "version": "0.9.6",
      "date": "2023-08-07"
    },
    {
      "version": "0.9.7",
      "date": "2023-09-17"
    },
    {
      "version": "0.9.8",
      "date": "2023-09-24"
    },
    {
      "version": "0.10.0",
      "date": "2024-01-21"
    },
    {
      "version": "0.10.1",
      "date": "2024-02-04"
    },
    {
      "version": "0.10.2",
      "date": "2024-02-24"
    },
    {
      "version": "0.10.3",
      "date": "2024-03-03"
    },
    {
      "version": "0.10.4",
      "date": "2024-03-06"
    },
    {
      "version": "0.10.5",
      "date": "2024-06-30"
    },
    {
      "version": "0.10.6",
      "date": "2024-07-25"
    },
    {
      "version": "0.10.7",
      "date": "2024-09-29"
    },
    {
      "version": "0.11.0",
      "date": "2024-11-14"
    },
    {
      "version": "0.12.0",
      "date": "2025-03-30"
    },
    {
      "version": "0.13.0",
      "date": "2025-06-03"
    },
    {
      "version": "0.13.1",
      "date": "2025-06-26"
    },
    {
      "version": "0.14.0",
      "date": "2025-12-11"
    },
    {
      "version": "0.15.0",
      "date": "2026-08-25"
    }
  ],
  "_exports": [
    "contacts",
    "docdb_create",
    "docdb_delete",
    "docdb_exists",
    "docdb_get",
    "docdb_list",
    "docdb_query",
    "docdb_update",
    "mapdata",
    "src_couchdb",
    "src_duckdb",
    "src_elastic",
    "src_mariadb",
    "src_mongo",
    "src_postgres",
    "src_sqlite"
  ],
  "_datasets": [
    {
      "name": "diamonds",
      "title": "Data set 'diamonds'",
      "object": "diamonds",
      "class": [
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "carat",
        "cut",
        "color",
        "clarity",
        "depth",
        "table",
        "price",
        "x",
        "y",
        "z"
      ],
      "rows": 53940,
      "table": true,
      "tojson": true
    }
  ],
  "_help": [
    {
      "page": "contacts",
      "title": "Data set 'contacts'",
      "topics": [
        "contacts"
      ]
    },
    {
      "page": "diamonds",
      "title": "Data set 'diamonds'",
      "topics": [
        "diamonds"
      ]
    },
    {
      "page": "docdb_create",
      "title": "Create documents in a database",
      "topics": [
        "docdb_create"
      ]
    },
    {
      "page": "docdb_delete",
      "title": "Delete documents or container",
      "topics": [
        "docdb_delete"
      ]
    },
    {
      "page": "docdb_exists",
      "title": "Check if container exists in database",
      "topics": [
        "docdb_exists"
      ]
    },
    {
      "page": "docdb_get",
      "title": "Get all documents from container in database",
      "topics": [
        "docdb_get"
      ]
    },
    {
      "page": "docdb_list",
      "title": "List containers in database",
      "topics": [
        "docdb_list"
      ]
    },
    {
      "page": "docdb_query",
      "title": "Get documents or parts with filtering query",
      "topics": [
        "docdb_query"
      ]
    },
    {
      "page": "docdb_update",
      "title": "Update documents",
      "topics": [
        "docdb_update"
      ]
    },
    {
      "page": "mapdata",
      "title": "Data set 'mapdata'",
      "topics": [
        "mapdata"
      ]
    },
    {
      "page": "src",
      "title": "Setup database connections",
      "topics": [
        "src"
      ]
    },
    {
      "page": "src_couchdb",
      "title": "Setup a CouchDB database connection",
      "topics": [
        "src_couchdb"
      ]
    },
    {
      "page": "src_duckdb",
      "title": "Setup a DuckDB database connection",
      "topics": [
        "src_duckdb"
      ]
    },
    {
      "page": "src_elastic",
      "title": "Setup an Elasticsearch database connection",
      "topics": [
        "src_elastic"
      ]
    },
    {
      "page": "src_mariadb",
      "title": "Setup a RMariaDB database connection",
      "topics": [
        "src_mariadb"
      ]
    },
    {
      "page": "src_mongo",
      "title": "Setup a MongoDB database connection",
      "topics": [
        "src_mongo"
      ]
    },
    {
      "page": "src_postgres",
      "title": "Setup a PostgreSQL database connection",
      "topics": [
        "src_postgres"
      ]
    },
    {
      "page": "src_sqlite",
      "title": "Setup a RSQLite database connection",
      "topics": [
        "src_sqlite"
      ]
    }
  ],
  "_readme": "https://github.com/ropensci/nodbi/raw/master/README.md",
  "_rundeps": [
    "curl",
    "DBI",
    "jqr",
    "jsonlite",
    "lazyeval",
    "magrittr",
    "R.methodsS3",
    "R.oo",
    "R.utils",
    "Rcpp",
    "rlang",
    "stringi",
    "uuid",
    "V8"
  ],
  "_vignettes": [
    {
      "source": "nodbi-overview.Rmd",
      "filename": "nodbi-overview.html",
      "title": "nodbi - package overview",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Summary",
        "Connect",
        "docdb_create",
        "Identifiers",
        "docdb_get",
        "docdb_query",
        "Field names",
        "docdb_update",
        "docdb_delete",
        "Disconnect and shutdown"
      ],
      "created": "2024-02-11 09:43:29",
      "modified": "2026-08-25 09:19:54",
      "commits": 9
    }
  ],
  "_score": 8.335357590149176,
  "_indexed": true,
  "_nocasepkg": "nodbi",
  "_universes": [
    "ropensci",
    "rfhb"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.15.0.9000",
      "date": "2026-09-24T10:35:33.000Z",
      "distro": "resolute",
      "commit": "b69c7ad1f40e1063152aba0dd1dfbbf04c28e13d",
      "fileid": "https://r2.ropensci.org/3cc6279bcf285f588f3712b3598c739a5fc01c91f7c2d1181aa221820f7830a7",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/35987181944"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.15.0.9000",
      "date": "2026-09-24T10:35:29.000Z",
      "distro": "resolute",
      "commit": "b69c7ad1f40e1063152aba0dd1dfbbf04c28e13d",
      "fileid": "https://r2.ropensci.org/a0d59ba46a716d0ef51ef19cdf91b60d6c3420bf744ffe9728fca87fce4c684d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/35987181944"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.15.0.9000",
      "date": "2026-09-24T10:45:35.000Z",
      "commit": "b69c7ad1f40e1063152aba0dd1dfbbf04c28e13d",
      "fileid": "https://r2.ropensci.org/a4ddd75ab29cf39134f3a2481fbf96c745b054964779bf6dc7054154bc2bc883",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/35987181944"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.15.0.9000",
      "date": "2026-09-24T10:48:34.000Z",
      "commit": "b69c7ad1f40e1063152aba0dd1dfbbf04c28e13d",
      "fileid": "https://r2.ropensci.org/06512340d42f56f9aaa4f707d494043c7a0a320bf4bb420b965477ff4e0c7ae9",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/35987181944"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.15.0.9000",
      "date": "2026-09-24T10:35:25.000Z",
      "commit": "b69c7ad1f40e1063152aba0dd1dfbbf04c28e13d",
      "fileid": "https://r2.ropensci.org/8044902d672a13d5c340c610246de9e0079c5e7b89dff6fa137eb2711fa66b55",
      "status": "success",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/35987181944"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.15.0.9000",
      "date": "2026-09-24T10:34:14.000Z",
      "commit": "b69c7ad1f40e1063152aba0dd1dfbbf04c28e13d",
      "fileid": "https://r2.ropensci.org/c77678dec0921b1b4799e52c5e2d624a4d61da8820bf4a15d2aecd9c455fa7d7",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/35987181944"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.15.0.9000",
      "date": "2026-09-24T10:34:23.000Z",
      "commit": "b69c7ad1f40e1063152aba0dd1dfbbf04c28e13d",
      "fileid": "https://r2.ropensci.org/b7048029a138a07f01bd965e99deda210a03f9118e6457cbbf7799654b72146d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/35987181944"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.15.0.9000",
      "date": "2026-09-24T10:35:09.000Z",
      "commit": "b69c7ad1f40e1063152aba0dd1dfbbf04c28e13d",
      "fileid": "https://r2.ropensci.org/2d5c5bd00818b1e6aac8ddd2f766fd16f28016b4e53fabf87967d99a001481da",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/35987181944"
    }
  ]
}