virtuoso: Interface to 'Virtuoso' using 'ODBC'

Provides users with a simple and convenient mechanism to manage and query a 'Virtuoso' database using the 'DBI' (Data-Base Interface) compatible 'ODBC' (Open Database Connectivity) interface. 'Virtuoso' is a high-performance "universal server," which can act as both a relational database, supporting standard Structured Query Language ('SQL') queries, while also supporting data following the Resource Description Framework ('RDF') model for Linked Data. 'RDF' data can be queried using 'SPARQL' ('SPARQL' Protocol and 'RDF' Query Language) queries, a graph-based query that supports semantic reasoning. This allows users to leverage the performance of local or remote 'Virtuoso' servers using popular 'R' packages such as 'DBI' and 'dplyr', while also providing a high-performance solution for working with large 'RDF' 'triplestores' from 'R.' The package also provides helper routines to install, launch, and manage a 'Virtuoso' server locally on 'Mac', 'Windows' and 'Linux' platforms using the standard interactive installers from the 'R' command-line. By automatically handling these setup steps, the package can make using 'Virtuoso' considerably faster and easier for a most users to deploy in a local environment. Managing the bulk import of triples from common serializations with a single intuitive command is another key feature of this package. Bulk import performance can be tens to hundreds of times faster than the comparable imports using existing 'R' tools, including 'rdflib' and 'redland' packages.

Version: 0.1.8
Imports: odbc, processx, DBI, utils, ini, rappdirs, curl, fs, digest, ps
Suggests: knitr, rmarkdown, nycflights13, testthat, covr, jsonld, dplyr, spelling
Published: 2021-11-02
DOI: 10.32614/CRAN.package.virtuoso
Author: Carl Boettiger ORCID iD [aut, cre, cph], Bryce Mecum ORCID iD [ctb]
Maintainer: Carl Boettiger <cboettig at>
License: MIT + file LICENSE
NeedsCompilation: no
SystemRequirements: virtuoso-opensource (Linux). For Mac & Windows, this package can automate Virtuoso installation.
Language: en-US
Materials: README NEWS
CRAN checks: virtuoso results


Reference manual: virtuoso.pdf
Vignettes: Installation


Package source: virtuoso_0.1.8.tar.gz
Windows binaries: r-devel:, r-release:, r-oldrel:
macOS binaries: r-release (arm64): virtuoso_0.1.8.tgz, r-oldrel (arm64): virtuoso_0.1.8.tgz, r-release (x86_64): virtuoso_0.1.8.tgz, r-oldrel (x86_64): virtuoso_0.1.8.tgz
Old sources: virtuoso archive


Please use the canonical form to link to this page.