{
  "_id": "69e345f9c5259ad4cd969c7e",
  "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' and 'NoSQL'\ndatabases 'MongoDB', 'CouchDB' and 'Elasticsearch').",
  "Version": "0.14.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": "7.3.3.9000",
  "Config/pak/sysreqs": "libicu-dev libjq-dev libssl-dev libnode-dev",
  "Repository": "https://ropensci.r-universe.dev",
  "Date/Publication": "2026-04-18 08:25:02 UTC",
  "RemoteUrl": "https://github.com/ropensci/nodbi",
  "RemoteRef": "master",
  "RemoteSha": "c1ba7e2549a4b7145b5cac5bd5bb29f2d465051a",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-04-18 08:47:57 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>",
  "MD5sum": "7482ef1256ed20312c79acf2690e5ec3",
  "_user": "ropensci",
  "_type": "src",
  "_file": "nodbi_0.14.0.9000.tar.gz",
  "_fileid": "d595487a4c4be2fb97dc80e5967da3719ad10c5a03fc1f9c4e85c8712ee25b64",
  "_filesize": 583651,
  "_sha256": "d595487a4c4be2fb97dc80e5967da3719ad10c5a03fc1f9c4e85c8712ee25b64",
  "_created": "2026-04-18T08:47:57.000Z",
  "_published": "2026-04-18T08:51:05.710Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 71939855311,
      "time": 146,
      "config": "linux-devel-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6509953998"
    },
    {
      "job": 71939855315,
      "time": 136,
      "config": "linux-release-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "6509953083"
    },
    {
      "job": 71939855307,
      "time": 105,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "6509950487"
    },
    {
      "job": 71939855317,
      "time": 81,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6509948509"
    },
    {
      "job": 71939715602,
      "time": 205,
      "config": "pkgdown",
      "r": "4.5.2",
      "check": "OK",
      "artifact": "6509942554"
    },
    {
      "job": 71939715598,
      "time": 191,
      "config": "source",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "6509941460"
    },
    {
      "job": 71939855312,
      "time": 113,
      "config": "wasm-release",
      "r": "4.5.1",
      "check": "OK",
      "artifact": "6509951221"
    },
    {
      "job": 71939855329,
      "time": 146,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "6509953920"
    },
    {
      "job": 71939855314,
      "time": 89,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "6509949156"
    },
    {
      "job": 71939855331,
      "time": 99,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6509949969"
    }
  ],
  "_buildurl": "https://github.com/r-universe/ropensci/actions/runs/24601056036",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/ropensci/nodbi",
  "_commit": {
    "id": "c1ba7e2549a4b7145b5cac5bd5bb29f2d465051a",
    "author": "Ralf Herold <ralf.herold@gmx.net>",
    "committer": "Ralf Herold <ralf.herold@gmx.net>",
    "message": "update pkgdown\n",
    "time": 1776500702
  },
  "_maintainer": {
    "name": "Ralf Herold",
    "email": "ralf.herold@mailbox.org",
    "login": "rfhb",
    "mastodon": "@rfhb@mastodon.online",
    "bluesky": "@rfhb.bsky.social",
    "linkedin": "in/ralfherold",
    "uuid": 626690,
    "orcid": "0000-0002-8148-6748"
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 3.5.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": "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-18",
      "n": 1
    },
    {
      "week": "2025-22",
      "n": 10
    },
    {
      "week": "2025-23",
      "n": 3
    },
    {
      "week": "2025-26",
      "n": 2
    },
    {
      "week": "2025-28",
      "n": 1
    },
    {
      "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
    }
  ],
  "_tags": [
    {
      "name": "v0.13.0",
      "date": "2025-06-03"
    },
    {
      "name": "v0.13.1",
      "date": "2025-06-26"
    },
    {
      "name": "v0.14.0",
      "date": "2025-12-07"
    }
  ],
  "_topics": [
    "database",
    "mongodb",
    "elasticsearch",
    "couchdb",
    "sqlite",
    "postgresql",
    "duckdb",
    "nosql",
    "json",
    "documents"
  ],
  "_stars": 75,
  "_contributors": [
    {
      "user": "rfhb",
      "count": 449,
      "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",
    "description": "Tools and R Packages for Open Science"
  },
  "_downloads": {
    "count": 546,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/nodbi"
  },
  "_mentions": 1,
  "_devurl": "https://github.com/ropensci/nodbi",
  "_pkgdown": "https://docs.ropensci.org/nodbi/",
  "_searchresults": 42,
  "_metadata": {
    "ropensci_category": "databases"
  },
  "_rbuild": "4.5.3",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/nodbi.html",
    "extra/readme.html",
    "extra/readme.md",
    "manual.pdf"
  ],
  "_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"
    }
  ],
  "_exports": [
    "contacts",
    "docdb_create",
    "docdb_delete",
    "docdb_exists",
    "docdb_get",
    "docdb_list",
    "docdb_query",
    "docdb_update",
    "mapdata",
    "src_couchdb",
    "src_duckdb",
    "src_elastic",
    "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_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-01-17 14:32:40",
      "commits": 8
    }
  ],
  "_score": 8.31785448933147,
  "_indexed": true,
  "_nocasepkg": "nodbi",
  "_universes": [
    "ropensci",
    "rfhb"
  ],
  "_binaries": [
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.14.0.9000",
      "date": "2026-04-18T08:50:17.000Z",
      "distro": "noble",
      "commit": "c1ba7e2549a4b7145b5cac5bd5bb29f2d465051a",
      "fileid": "d8bad2b69c980b2743bfaad53f04d6666dcb4012cfe7e482a591a757c3171e46",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/24601056036"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.14.0.9000",
      "date": "2026-04-18T08:49:43.000Z",
      "commit": "c1ba7e2549a4b7145b5cac5bd5bb29f2d465051a",
      "fileid": "d75ca148b4cc251fcfce7cb327d7a3711afb690c8e0fd5bb1eb6cd8f855f2fb4",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/24601056036"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.14.0.9000",
      "date": "2026-04-18T08:49:22.000Z",
      "commit": "c1ba7e2549a4b7145b5cac5bd5bb29f2d465051a",
      "fileid": "24f01acb1c50780692300cafee5ae17ca7923f4b7472c5d984b1d21af1628137",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/24601056036"
    },
    {
      "r": "4.5.1",
      "os": "wasm",
      "version": "0.14.0.9000",
      "date": "2026-04-18T08:50:06.000Z",
      "commit": "c1ba7e2549a4b7145b5cac5bd5bb29f2d465051a",
      "fileid": "2612596f5511387f5b54f5541210870f73c3e5c6bcacbf753a93acfc7c5681b8",
      "status": "success",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/24601056036"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.14.0.9000",
      "date": "2026-04-18T08:50:08.000Z",
      "commit": "c1ba7e2549a4b7145b5cac5bd5bb29f2d465051a",
      "fileid": "7a4453a14f633c182a925bda13d3abadf00dd4bc8fb42296ce1fd664b055302b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/24601056036"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.14.0.9000",
      "date": "2026-04-18T08:49:14.000Z",
      "commit": "c1ba7e2549a4b7145b5cac5bd5bb29f2d465051a",
      "fileid": "8a552eaa3c868077a67a7db6ef77376ec63f3970aa0f24ab5bc4a33b2e01783a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/24601056036"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.14.0.9000",
      "date": "2026-04-18T08:49:19.000Z",
      "commit": "c1ba7e2549a4b7145b5cac5bd5bb29f2d465051a",
      "fileid": "9df195952d7725dcd88db5f90e5e5ce38e634bb5f2d59278a91f82361e76eb1f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/24601056036"
    }
  ]
}