ANSI | A dummy DBI connector that simulates ANSI-SQL compliance |
dbAppendTable | Insert rows into a table |
dbAppendTableArrow | Insert rows into a table from an Arrow stream |
dbBind | Bind values to a parameterized/prepared statement |
dbCallProc | Call an SQL stored procedure |
dbCanConnect | Check if a connection to a DBMS can be established |
dbClearResult | Clear a result set |
dbColumnInfo | Information about result types |
dbConnect | Create a connection to a DBMS |
dbCreateTable | Create a table in the database |
dbCreateTableArrow | Create a table in the database based on an Arrow object |
dbDataType | Determine the SQL data type of an object |
dbDisconnect | Disconnect (close) a connection |
dbDriver | Load and unload database drivers |
dbExecute | Change database state |
dbExistsTable | Does a table exist? |
dbFetch | Fetch records from a previously executed query |
dbFetchArrow | Fetch records from a previously executed query as an Arrow... |
dbFetchArrowChunk | Fetch the next batch of records from a previously executed... |
dbGetConnectArgs | Get connection arguments |
dbGetDBIVersion | Determine the current version of the package. |
dbGetException | Get DBMS exceptions |
dbGetInfo | Get DBMS metadata |
dbGetQuery | Retrieve results from a query |
dbGetQueryArrow | Retrieve results from a query as an Arrow object |
dbGetRowCount | The number of rows fetched so far |
dbGetRowsAffected | The number of rows affected |
dbGetStatement | Get the statement associated with a result set |
dbHasCompleted | Completion status |
DBIConnection-class | DBIConnection class |
DBIConnector-class | DBIConnector class |
DBIDriver-class | DBIDriver class |
DBIObject-class | DBIObject class |
DBI-package | DBI: R Database Interface |
DBIResultArrow-class | DBIResultArrow class |
DBIResult-class | DBIResult class |
dbIsReadOnly | Is this DBMS object read only? |
dbIsValid | Is this DBMS object still valid? |
dbListConnections | List currently open connections |
dbListFields | List field names of a remote table |
dbListObjects | List remote objects |
dbListResults | A list of all pending results |
dbListTables | List remote tables |
dbQuoteIdentifier | Quote identifiers |
dbQuoteLiteral | Quote literal values |
dbQuoteString | Quote literal strings |
dbReadTable | Read database tables as data frames |
dbReadTableArrow | Read database tables as Arrow objects |
dbRemoveTable | Remove a table from the database |
dbSendQuery | Execute a query on a given database connection |
dbSendQueryArrow | Execute a query on a given database connection for retrieval... |
dbSendStatement | Execute a data manipulation statement on a given database... |
dbSetDataMappings | Set data mappings between an DBMS and R. |
dbUnquoteIdentifier | Unquote identifiers |
dbWithTransaction | Self-contained SQL transactions |
dbWriteTable | Copy data frames to database tables |
dbWriteTableArrow | Copy Arrow objects to database tables |
dot-SQL92Keywords | Keywords according to the SQL-92 standard |
hidden_aliases | Internal page for hidden aliases |
Id | Refer to a table nested in a hierarchy (e.g. within a schema) |
make.db.names | Make R identifiers into legal SQL identifiers |
rownames | Convert row names back and forth between columns |
SQL | SQL quoting |
sqlAppendTable | Compose query to insert rows into a table |
sqlCreateTable | Compose query to create a simple table |
sqlData | Convert a data frame into form suitable for upload to an SQL... |
sqlInterpolate | Safely interpolate values into an SQL string |
sqlParseVariables | Parse interpolated variables from SQL. |
transactions | Begin/commit/rollback SQL transactions |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.