R Development Page

Contributed R Packages

Below is a list of all packages provided by project Easy database interface.

Important note for package
binaries: R-Forge provides these binaries only for
the most recent version of R, but not for older
versions. In order to successfully install the
packages provided on R-Forge, you have to switch
to the most recent version of R or, alternatively,
install from the package sources (.tar.gz).

Packages

easydb

Generic S3 Classes for Simple Database Interfaces

Generic S3 classes for simple database interfaces. (presently RODBC and RSQLite). easydb provide common S3 classes for reading, writing, listing and subsetting tables in RODBC and (R)SQLite databases. Functions in easydb alone DO NOT provide any database interface, but they are used in other packages that provide inteface to various database systems (see suggests). easydb allows to retrieve, write and subset databases tables in a similar way as data.frames, using single square brackets db[,,,]. easydb internalise many database operations (otherwise tedious) such as rows and columns subsetting (no SQL needed) and connection and disconnection to / from databases.

Simple database interface for MS Access. easyrodbcaccess is build on top of RODBC. It provides functions for reading, writing, listing and subsetting tables in MS Access. easyrodbcaccess allow to retrieve, write and subset databases tables in a similar way as data.frames, using single square brackets db[,,,]. easyrodbcaccess internalise many database operations (otherwise tedious) such as rows and columns subsetting (no SQL needed) and connection and disconnection to / from databases.

Simple database interface for RODBC Excel. Package build on top of RODBC. Provides functions for reading, writing, listing and subsetting tables in Excel. Allows to retrieve, write and subset Excel filess spreadsheets in a similar way as data.frames, using single square brackets db[,,,]. easyrodbcexcel internalise many database operations (otherwise tedious) such as rows and columns subsetting (no SQL needed) and connection and disconnection to / from databases.

Simple database interface for MySQL. easyrodbcmysql is build on top of RODBC. It provides functions for reading, writing, listing and subsetting tables in MySQL. easyrodbcmysql allow to retrieve, write and subset databases tables in a similar way as data.frames, using single square brackets db[,,,]. easyrodbcmysql internalise many database operations (otherwise tedious) such as rows and columns subsetting (no SQL needed) and connection and disconnection to / from databases.

Simple database interface for SQLite. easyrsqlite is build on top of RSQLite. It provides functions for reading, writing, listing and subsetting tables in SQLite. easyrsqlite allow to retrieve, write and subset databases tables in a similar way as data.frames, using single square brackets db[,,,]. easyrsqlite internalise many database operations (otherwise tedious) such as rows and columns subsetting (no SQL needed) and connection and disconnection to / from databases.

Build status codes

0 - Current: the package is available for download. The corresponding package passed checks on the Linux and Windows platform without ERRORs.
1 - Scheduled for build: the package has been recognized by the build system and provided in the staging area.
2 - Building: the package has been sent to the build machines. It will be built and checked using the latest patched version of R. Note that it is included in a batch of several packages. Thus, this process will take some time to finish.
3 - Failed to build: the package failed to build or did not pass the checks on the Linux and/or Windows platform. It is not made available since it does not meet the policies.
4 - Conflicts: two or more packages of the same name exist. None of them will be built. Maintainers are asked to negotiate further actions.
5 - Offline: the package is not available. The build system may be offline or the package maintainer did not trigger a rebuild (done e.g., via committing to the package repository).