CRAN Task View: Databases with R

Maintainer:Yuan Tang
Contact:terrytangyuan at

This CRAN task view contains a list of packages related to accessibility of different databases. This does not include data import/export or data management.

As datasets become larger and larger, it is impossible for people to save them in traditional file formats such as spreadsheet, raw text file, etc., which could not fit on devices with limited storage and could not be easily shared across collaborators. Instead, people nowadays tend to store data in databases for more scalable and reliable data management.

Database systems are often classified based on the database models that they support. Relational databases became dominant in the 1980s. The data in relational databases is modeled as rows and columns in a series of tables with the use of SQL to express the logic for writing and querying data. The tables are relational, e.g. you have a user who users your softwares and those softwares have creators and contributors. Non-relational databases became popular in recent years due to huge demand in storing unstructured data with the use of NoSQL as the query language. Users generally don't need to define the data schema up front. If there are changing requirements in the applications, non-relational databases can be much easier to use and manage.

The content presented in this Task View are undergoing rapid changes in industries and academia. Please send any suggestions to the task view maintainer or submit a pull request or issue to the Github repository of this task view .

The ctv package supports these Task Views. Its functions install.views and update.views allow, respectively, installation or update of packages from a given Task View; the option coreOnly can restrict operations to packages labeled as core below.

Suggestions and corrections by Achim Zeileis, Kirill Müller, Hannes Mühleisen, Rich FitzJohn, Dirk Eddelbuettel, and Hadley Wickham (as well as others I may have forgotten to add here) are gratefully acknowledged. Thanks to Dirk Eddelbuettel who made the initial .ctv file and the Markdown conversion script available at the Github repository of CRAN Task View for High Performance Computing here . Last but not least, thanks to Achim Zeileis who helped me get started on organizing this task view.

Relational Databases

This section includes packages that provides access to relational databases within R.

Non-Relational Databases

This section includes packages that provides access to non-relational databases within R.

Databases Tools

This section includes packages that provides tools for working and testing with databases, databases table manipulations, etc.

CRAN packages:

Related links: