DBI v0.3.0
0
Monthly downloads
R Database Interface
A database interface (DBI) definition for communication
between R and relational database management systems. All
classes in this package are virtual and need to be extended by
the various R/DBMS implementations.
Functions in DBI
| Name | Description | |
| DBIConnection-class | DBIConnection class. | |
| dbGetRowCount | The number of rows fetched so far. | |
| dbGetDBIVersion | Determine the current version of the package. | |
| dbDisconnect | Disconnect (close) a connection | |
| SQL | SQL quoting. | |
| dbListTables | List remote tables. | |
| dbReadTable | Copy data frames to and from database tables. | |
| DBIDriver-class | DBIDriver class. | |
| dbExistsTable | Does a table exist? | |
| dbColumnInfo | Information about result types. | |
| dbConnect | Create a connection to a DBMS. | |
| dbDriver | Load and unload database drivers. | |
| dbGetRowsAffected | The number of rows affected by data modifying query. | |
| dbIsValid | Is this DBMS object still valid? | |
| dbHasCompleted | Has the operation completed? | |
| dbGetInfo | Get DBMS metadata. | |
| DBIObject-class | DBIObject class. | |
| dbCallProc | Call an SQL stored procedure | |
| dbRemoveTable | Remove a table from the database. | |
| transactions | Begin/commit/rollback SQL transactions | |
| dbDataType | Determine the SQL data type of an object. | |
| dbSendQuery | Execute a statement on a given database connection. | |
| dbGetQuery | Send query, retrieve results and then clear result set. | |
| print.list.pairs | Print a list of pairs. | |
| dbSetDataMappings | Set data mappings between an DBMS and R. | |
| dbGetStatement | Get the statement associated with a result set | |
| dbListFields | List field names of a remote table. | |
| dbFetch | Fetch records from a previously executed query. | |
| DBIResult-class | DBIResult class. | |
| dbClearResult | Clear a result set. | |
| dbListConnections | List currently open connections. | |
| dbListResults | A list of all pending results. | |
| dbGetException | Get DBMS exceptions. | |
| make.db.names | Make R identifiers into legal SQL identifiers. | |
| dbiCheckCompliance | Check a driver for compliance with DBI. | |
| No Results! | ||
Last month downloads
Details
| License | LGPL (>= 2) |
| URL | https://github.com/rstats-db/DBI |
| BugReports | https://github.com/rstats-db/DBI/issues |
| Collate | 'DBObject.R' 'DBConnection.R' 'DBDriver.R' 'DBResult.R' 'compliance.R' 'keywords.R' 'quote.R' 'util.R' |
| NeedsCompilation | no |
| Packaged | 2014-09-02 23:05:32 UTC; ligges |
| Repository | CRAN |
| Date/Publication | 2014-09-03 01:05:44 |
| depends | base (>= 2.15.0) , methods , R (>= 2.15.0) |
| suggests | RSQLite , testthat |
| Contributors | R Interest Group on Databases |
Include our badge in your README
[](http://www.rdocumentation.org/packages/DBI)