{
  "_id": "6a32516b3efcd9bda437e2c6",
  "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-06-17 07:45:45 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": "9a4cf5419c4726ce376985cb53b321ea",
  "_user": "ropensci",
  "_type": "src",
  "_file": "nodbi_0.14.0.9000.tar.gz",
  "_fileid": "47c60180f6afe331f6f83a0a4d92a5b1cc7513b03766858d49fb5f4a558ab17d",
  "_filesize": 583527,
  "_sha256": "47c60180f6afe331f6f83a0a4d92a5b1cc7513b03766858d49fb5f4a558ab17d",
  "_created": "2026-06-17T07:45:45.000Z",
  "_published": "2026-06-17T07:48:59.657Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 81844234943,
      "time": 141,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7689085036"
    },
    {
      "job": 81844234944,
      "time": 127,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7689082472"
    },
    {
      "job": 81844234979,
      "time": 104,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7689072565"
    },
    {
      "job": 81844234945,
      "time": 88,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7689067336"
    },
    {
      "job": 81843741731,
      "time": 212,
      "config": "pkgdown",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7689047373"
    },
    {
      "job": 81843741756,
      "time": 179,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7689036481"
    },
    {
      "job": 81844235038,
      "time": 116,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7689078979"
    },
    {
      "job": 81844235006,
      "time": 87,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7689067416"
    },
    {
      "job": 81844235018,
      "time": 93,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7689069376"
    },
    {
      "job": 81844234962,
      "time": 103,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7689082204"
    }
  ],
  "_buildurl": "https://github.com/r-universe/ropensci/actions/runs/27673660241",
  "_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",
    "description": "",
    "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-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.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",
    "followers": 1100,
    "description": "Tools and R Packages for Open Science"
  },
  "_downloads": {
    "count": 474,
    "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": 46,
  "_metadata": {
    "ropensci_category": "databases"
  },
  "_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/nodbi.html",
    "extra/readme.html",
    "extra/readme.md",
    "LICENSE",
    "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.219060332448862,
  "_indexed": true,
  "_nocasepkg": "nodbi",
  "_universes": [
    "ropensci",
    "rfhb"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.14.0.9000",
      "date": "2026-06-17T07:48:01.000Z",
      "distro": "noble",
      "commit": "c1ba7e2549a4b7145b5cac5bd5bb29f2d465051a",
      "fileid": "854c7b1e91c88a337a179e001caeb6999f5d64c9cee0ff6d060b904dd3fd3168",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/27673660241"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.14.0.9000",
      "date": "2026-06-17T07:47:54.000Z",
      "distro": "noble",
      "commit": "c1ba7e2549a4b7145b5cac5bd5bb29f2d465051a",
      "fileid": "b49e7ff4d84d47a8670337eb84d05fa433d3b37e91ebb12e246ca279d2d733d5",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/27673660241"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.14.0.9000",
      "date": "2026-06-17T07:47:27.000Z",
      "commit": "c1ba7e2549a4b7145b5cac5bd5bb29f2d465051a",
      "fileid": "c80f2c5da330a32bbb97a7462d7fb07ccdd59ae1c71122da9cf7b2bd3099f898",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/27673660241"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.14.0.9000",
      "date": "2026-06-17T07:47:15.000Z",
      "commit": "c1ba7e2549a4b7145b5cac5bd5bb29f2d465051a",
      "fileid": "a289e6c8fcc693ed72f81b1b8637dbe1f935c245892aa6f517c03daa7682aa4e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/27673660241"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.14.0.9000",
      "date": "2026-06-17T07:48:05.000Z",
      "commit": "c1ba7e2549a4b7145b5cac5bd5bb29f2d465051a",
      "fileid": "f580be8b046685543e56a4f4402e52e8b27cd8091bbf01eb21b08dad2ac47c7f",
      "status": "success",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/27673660241"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.14.0.9000",
      "date": "2026-06-17T07:47:00.000Z",
      "commit": "c1ba7e2549a4b7145b5cac5bd5bb29f2d465051a",
      "fileid": "0765004dad1b14e9b2495c237ea96d197b8b405abac9a23dbcbdd0cad1a56a3e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/27673660241"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.14.0.9000",
      "date": "2026-06-17T07:47:06.000Z",
      "commit": "c1ba7e2549a4b7145b5cac5bd5bb29f2d465051a",
      "fileid": "2641d264c64067c2f32ad990ac16a55f6397a7f332fe62e59f350a4b77e0597f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/27673660241"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.14.0.9000",
      "date": "2026-06-17T07:47:46.000Z",
      "commit": "c1ba7e2549a4b7145b5cac5bd5bb29f2d465051a",
      "fileid": "49b6c7fdf326377041a8458b4b657ad84f87aac792f6278f989320a67607a62d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ropensci/actions/runs/27673660241"
    }
  ]
}