MonetDBLite for R is a SQL database that runs inside the R environment for statistical computing and does not require the installation of any external software. MonetDBLite is based on free and open-source MonetDB, a product of the Centrum Wiskunde & Informatica.
MonetDBLite is similar in functionality to RSQLite, but typically completes queries blazingly fast due to its columnar storage architecture and bulk query processing model. Since both of these embedded SQL options rely on the R DBI interface, the conversion of legacy RSQLite project syntax over to MonetDBLite code should be a cinch.
You can install the latest released version of MonetDBLite from CRAN with:
The latest development version from GitHub on the command line:
git clone https://github.com/hannesmuehleisen/MonetDBLite-R.git --depth 1 --recursive R CMD INSTALL MonetDBLite-R
For information on how to use, and to report bugs, please refer to the package's official GitHub repo: https://github.com/hannesmuehleisen/MonetDBLite-R