{ "_id": "69e09c78c5259ad4cd90e0b4", "Package": "virtuoso", "Type": "Package", "Title": "Interface to 'Virtuoso' using 'ODBC'", "Version": "0.1.8", "Authors@R": "c(person(\"Carl\", \"Boettiger\", \nemail = \"cboettig@gmail.com\",\nrole = c(\"aut\", \"cre\", \"cph\"),\ncomment = c(ORCID = \"0000-0002-1642-628X\")),\nperson(\"Bryce\", \"Mecum\",\nrole = \"ctb\",\nemail = \"brycemecum@gmail.com\",\ncomment = c(ORCID = \"0000-0002-0381-3766\")))", "Description": "Provides users with a simple and convenient mechanism to\nmanage and query a 'Virtuoso' database using the 'DBI'\n(Data-Base Interface) compatible 'ODBC' (Open Database\nConnectivity) interface. 'Virtuoso' is a high-performance\n\"universal server,\" which can act as both a relational\ndatabase, supporting standard Structured Query Language ('SQL')\nqueries, while also supporting data following the Resource\nDescription Framework ('RDF') model for Linked Data. 'RDF' data\ncan be queried using 'SPARQL' ('SPARQL' Protocol and 'RDF'\nQuery Language) queries, a graph-based query that supports\nsemantic reasoning. This allows users to leverage the\nperformance of local or remote 'Virtuoso' servers using popular\n'R' packages such as 'DBI' and 'dplyr', while also providing a\nhigh-performance solution for working with large 'RDF'\n'triplestores' from 'R.' The package also provides helper\nroutines to install, launch, and manage a 'Virtuoso' server\nlocally on 'Mac', 'Windows' and 'Linux' platforms using the\nstandard interactive installers from the 'R' command-line. By\nautomatically handling these setup steps, the package can make\nusing 'Virtuoso' considerably faster and easier for a most\nusers to deploy in a local environment. Managing the bulk\nimport of triples from common serializations with a single\nintuitive command is another key feature of this package. Bulk\nimport performance can be tens to hundreds of times faster than\nthe comparable imports using existing 'R' tools, including\n'rdflib' and 'redland' packages.", "License": "MIT + file LICENSE", "URL": "https://github.com/ropensci/virtuoso", "BugReports": "https://github.com/ropensci/virtuoso/issues", "Encoding": "UTF-8", "RoxygenNote": "7.1.1", "Roxygen": "list(markdown = TRUE)", "Config/Needs/website": "cboettig/rdftools", "VignetteBuilder": "knitr", "Language": "en-US", "SystemRequirements": "virtuoso-opensource (Linux). For Mac & Windows,\nthis package can automate Virtuoso installation.", "Config/pak/sysreqs": "cmake make libuv1-dev unixodbc-dev libssl-dev", "Repository": "https://ropensci.r-universe.dev", "Date/Publication": "2025-04-29 13:21:46 UTC", "RemoteUrl": "https://github.com/ropensci/virtuoso", "RemoteRef": "master", "RemoteSha": "9e331a07d480658b8962e59bfd9d92f49dc86deb", "NeedsCompilation": "no", "Packaged": { "Date": "2026-04-16 08:18:21 UTC", "User": "root" }, "Author": "Carl Boettiger [aut, cre, cph] (ORCID:\n),\nBryce Mecum [ctb] (ORCID: )", "Maintainer": "Carl Boettiger ", "MD5sum": "3311ad887e56cf6feab3ab686a650482", "_user": "ropensci", "_type": "src", "_file": "virtuoso_0.1.8.tar.gz", "_fileid": "7cf1403fda97ca47fff242b7ba5401782a79e94e5f3305cc71fbb83fcaa62873", "_filesize": 228613, "_sha256": "7cf1403fda97ca47fff242b7ba5401782a79e94e5f3305cc71fbb83fcaa62873", "_created": "2026-04-16T08:18:21.000Z", "_published": "2026-04-16T08:23:20.407Z", "_distro": "noble", "_jobs": [ { "job": 71603282712, "time": 172, "config": "linux-devel-x86_64", "r": "4.6.0", "check": "OK", "artifact": "6468920511" }, { "job": 71603282706, "time": 164, "config": "linux-release-x86_64", "r": "4.5.3", "check": "OK", "artifact": "6468919018" }, { "job": 71603282718, "time": 102, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "6468901964" }, { "job": 71603282710, "time": 114, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "6468905462" }, { "job": 71602691505, "time": 281, "config": "pkgdown", "r": "4.5.2", "check": "OK", "artifact": "6468879739" }, { "job": 71602691474, "time": 258, "config": "source", "r": "4.5.3", "check": "OK", "artifact": "6468873803" }, { "job": 71603282705, "time": 255, "config": "wasm-release", "r": "4.5.1", "check": "OK", "artifact": "6468942955" }, { "job": 71603282726, "time": 97, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "6468900814" }, { "job": 71603282731, "time": 105, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "6468903347" }, { "job": 71603282739, "time": 102, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "6468902124" } ], "_buildurl": "https://github.com/r-universe/ropensci/actions/runs/24499584165", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/ropensci/virtuoso", "_commit": { "id": "9e331a07d480658b8962e59bfd9d92f49dc86deb", "author": "Maëlle Salmon ", "committer": "GitHub ", "message": "chore: register pkgdown deps in DESCRIPTION (#43)\n\n* Update _pkgdown.yml\n\n* Update DESCRIPTION", "time": 1745932906 }, "_maintainer": { "name": "Carl Boettiger", "email": "cboettig@gmail.com", "login": "cboettig", "mastodon": "@cboettig@ecoevo.social", "bluesky": "@cboettig.bsky.social", "orcid": "0000-0002-1642-628X", "uuid": 222586 }, "_registered": true, "_dependencies": [ { "package": "odbc", "role": "Imports" }, { "package": "processx", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "ini", "role": "Imports" }, { "package": "rappdirs", "role": "Imports" }, { "package": "curl", "role": "Imports" }, { "package": "fs", "role": "Imports" }, { "package": "digest", "role": "Imports" }, { "package": "ps", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "nycflights13", "role": "Suggests" }, { "package": "testthat", "role": "Suggests" }, { "package": "covr", "role": "Suggests" }, { "package": "jsonld", "role": "Suggests" }, { "package": "dplyr", "role": "Suggests" }, { "package": "spelling", "role": "Suggests" } ], "_owner": "ropensci", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-18", "n": 1 } ], "_tags": [], "_stars": 9, "_contributors": [ { "user": "cboettig", "count": 189, "uuid": 222586 }, { "user": "jeroen", "count": 2, "uuid": 216319 }, { "user": "maelle", "count": 1, "uuid": 8360597 } ], "_userbio": { "uuid": 1200269, "type": "organization", "name": "rOpenSci", "description": "Tools and R Packages for Open Science" }, "_downloads": { "count": 276, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/virtuoso" }, "_mentions": 6, "_devurl": "https://github.com/ropensci/virtuoso", "_pkgdown": "https://docs.ropensci.org/virtuoso", "_searchresults": 19, "_metadata": { "review": { "id": 271, "status": "reviewed", "version": "0.1.1", "organization": "rOpenSci Software Review", "url": "https://github.com/ropensci/software-review/issues/271" }, "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/readme.html", "extra/readme.md", "extra/virtuoso.html", "manual.pdf" ], "_homeurl": "https://github.com/ropensci/virtuoso", "_realowner": "ropensci", "_cranurl": true, "_releases": [ { "version": "0.1.3", "date": "2019-04-06" }, { "version": "0.1.4", "date": "2020-01-10" }, { "version": "0.1.5", "date": "2020-09-01" }, { "version": "0.1.6", "date": "2021-03-23" }, { "version": "0.1.7", "date": "2021-11-01" }, { "version": "0.1.8", "date": "2021-11-02" } ], "_exports": [ "has_virtuoso", "vos_configure", "vos_connect", "vos_delete_db", "vos_destroy_all", "vos_import", "vos_install", "vos_kill", "vos_list_graphs", "vos_log", "vos_odbcinst", "vos_process", "vos_query", "vos_set_paths", "vos_start", "vos_status", "vos_uninstall" ], "_help": [ { "page": "has_virtuoso", "title": "check for Virtuoso", "topics": [ "has_virtuoso" ] }, { "page": "vos_configure", "title": "Configure Virtuoso Server ini file", "topics": [ "vos_configure" ] }, { "page": "vos_connect", "title": "Connect to a Virtuoso Server over ODBC", "topics": [ "vos_connect" ] }, { "page": "vos_delete_db", "title": "Delete Virtuoso Database", "topics": [ "vos_delete_db" ] }, { "page": "vos_destroy_all", "title": "Destroy all Virtuoso's directories", "topics": [ "vos_destroy_all" ] }, { "page": "vos_import", "title": "Bulk Import of RDF triples", "topics": [ "vos_import" ] }, { "page": "vos_install", "title": "Helper method for installing Virtuoso Server", "topics": [ "vos_install" ] }, { "page": "vos_kill", "title": "Stop (kill) the Virtuoso server", "topics": [ "vos_kill" ] }, { "page": "vos_list_graphs", "title": "List graphs", "topics": [ "vos_list_graphs" ] }, { "page": "vos_log", "title": "Query the server logs", "topics": [ "vos_log" ] }, { "page": "vos_odbcinst", "title": "Configure the ODBC Driver for Virtuoso", "topics": [ "vos_odbcinst" ] }, { "page": "vos_process", "title": "Return a handle to an existing Virtuoso Process", "topics": [ "vos_process" ] }, { "page": "vos_query", "title": "Run a SPARQL query", "topics": [ "vos_query" ] }, { "page": "vos_set_paths", "title": "set Virtuoso paths", "topics": [ "vos_set_paths" ] }, { "page": "vos_start", "title": "Start a Virtuoso Server", "topics": [ "vos_start" ] }, { "page": "vos_status", "title": "Query the server status", "topics": [ "vos_status" ] }, { "page": "vos_uninstall", "title": "Uninstall Virtuoso", "topics": [ "vos_uninstall" ] } ], "_pkglogo": "https://github.com/ropensci/virtuoso/raw/master/man/figures/logo.svg", "_readme": "https://github.com/ropensci/virtuoso/raw/master/README.md", "_rundeps": [ "bit", "bit64", "blob", "cli", "curl", "DBI", "digest", "fs", "glue", "hms", "ini", "lifecycle", "odbc", "pkgconfig", "processx", "ps", "R6", "rappdirs", "Rcpp", "rlang", "vctrs" ], "_vignettes": [ { "source": "installation.Rmd", "filename": "installation.html", "title": "Introduction: Virtuoso Installation and Configuration", "author": "Carl Boettiger", "engine": "knitr::rmarkdown", "headings": [ "Installation", "Configuration", "Server management" ], "created": "2018-11-11 20:52:14", "modified": "2019-02-19 18:31:19", "commits": 3 } ], "_score": 6.011147360775798, "_indexed": true, "_nocasepkg": "virtuoso", "_universes": [ "ropensci", "cboettig" ], "_binaries": [ { "r": "4.6.0", "os": "linux", "version": "0.1.8", "date": "2026-04-16T08:21:10.000Z", "distro": "noble", "commit": "9e331a07d480658b8962e59bfd9d92f49dc86deb", "fileid": "228cdab025e109537e6709fd01c970c6170dd5e2d7792d033dfbc8243620a8a0", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ropensci/actions/runs/24499584165" }, { "r": "4.5.3", "os": "linux", "version": "0.1.8", "date": "2026-04-16T08:21:04.000Z", "distro": "noble", "commit": "9e331a07d480658b8962e59bfd9d92f49dc86deb", "fileid": "044be72b6511be12d891d11035b56f1d9e63d74d6b2939bebf89cc23b9a87d13", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ropensci/actions/runs/24499584165" }, { "r": "4.5.3", "os": "mac", "version": "0.1.8", "date": "2026-04-16T08:20:00.000Z", "commit": "9e331a07d480658b8962e59bfd9d92f49dc86deb", "fileid": "8c1f7d89c273fb6a510e753233167efc866964a14931f2565c3bf10e3b420ee5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ropensci/actions/runs/24499584165" }, { "r": "4.6.0", "os": "mac", "version": "0.1.8", "date": "2026-04-16T08:20:16.000Z", "commit": "9e331a07d480658b8962e59bfd9d92f49dc86deb", "fileid": "4a5948ba040e58a44f3b4d43ddbdcd1bc21b5e55abf135317b05ad3f3397324e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ropensci/actions/runs/24499584165" }, { "r": "4.5.1", "os": "wasm", "version": "0.1.8", "date": "2026-04-16T08:22:54.000Z", "commit": "9e331a07d480658b8962e59bfd9d92f49dc86deb", "fileid": "ee373531936764f91d15978ee7a80fe804551c39e59cb6e5d986d82e33109f82", "status": "success", "buildurl": "https://github.com/r-universe/ropensci/actions/runs/24499584165" }, { "r": "4.7.0", "os": "win", "version": "0.1.8", "date": "2026-04-16T08:19:42.000Z", "commit": "9e331a07d480658b8962e59bfd9d92f49dc86deb", "fileid": "b35ff1813dfc73fbf0c007864813b621fca0408c14f28431294a53937f865820", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ropensci/actions/runs/24499584165" }, { "r": "4.5.3", "os": "win", "version": "0.1.8", "date": "2026-04-16T08:19:48.000Z", "commit": "9e331a07d480658b8962e59bfd9d92f49dc86deb", "fileid": "7f1233063b54c10d58c5005bc063139e8372fbe1a21c76b29143005705cbd282", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ropensci/actions/runs/24499584165" }, { "r": "4.6.0", "os": "win", "version": "0.1.8", "date": "2026-04-16T08:19:48.000Z", "commit": "9e331a07d480658b8962e59bfd9d92f49dc86deb", "fileid": "33a05936ccdf32de547127d79520627b3085f12837f2c063b872123fae4f3132", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ropensci/actions/runs/24499584165" } ] }