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 database's tables in a similar way as data.frame's, 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.

Author
Julien MOEYS <Julien.Moeys@mark.slu.se>
Date of publication
2016-06-09 08:48:05
Maintainer
Julien MOEYS <Julien.Moeys@mark.slu.se>
License
AGPL-3
Version
0.7.8
URLs

View on R-Forge

Man pages

easydb-package
Generic S3 classes for simple database interfaces.
edb
Create a database description (class 'edb'), to be used by...
edbColnames
Retrieve column names of a table in a database (referenced by...
edbDataSource
Create an RODBC data source (from an 'edb' reference). Only...
edbDelete
Delete all or some rows in a table in a database (referenced...
edbDim
Retrieve the dimension of a table in a database (referenced...
edbDrop
Drop a table in a database (referenced by 'edb').
edbLog
Write an operation "log" (used when modifying the database)
edbNames
Retrieve table names in a database (referenced by 'edb').
edbNCol
Retrieve the number of columns of a table in a database...
edbNRow
Retrieve the number of rows of a table in a database...
edbQuery
Read all or part of a table in a database (referenced by...
edbRead
Read all or part of a table in a database (referenced by...
edbWrite
Write data in a table in a database (referenced by 'edb').

Files in this package

easydb/DESCRIPTION
easydb/NAMESPACE
easydb/NEWS
easydb/R
easydb/R/R2SQL.R
easydb/R/easydb.R
easydb/R/onAttach.R
easydb/inst
easydb/inst/SVN_VERSION
easydb/man
easydb/man/easydb-package.Rd
easydb/man/edb.Rd
easydb/man/edbColnames.Rd
easydb/man/edbDataSource.Rd
easydb/man/edbDelete.Rd
easydb/man/edbDim.Rd
easydb/man/edbDrop.Rd
easydb/man/edbLog.Rd
easydb/man/edbNCol.Rd
easydb/man/edbNRow.Rd
easydb/man/edbNames.Rd
easydb/man/edbQuery.Rd
easydb/man/edbRead.Rd
easydb/man/edbWrite.Rd
easydb/tests
easydb/tests/edbColnames.R
easydb/tests/edbDelete.R
easydb/tests/edbDim.R
easydb/tests/edbDrop.R
easydb/tests/edbNCol.R
easydb/tests/edbNRow.R
easydb/tests/edbNames.R
easydb/tests/edbQuery.R
easydb/tests/edbRead.R
easydb/tests/edbWrite.R
easydb/tests/sCol.format.R
easydb/tests/splitBySize.R