All functions

connect

connect

createConnectionDetails

createConnectionDetails

createZipFile()

Compress files and/or folders into a single zip file

DatabaseConnector

DatabaseConnector

DatabaseConnectorDriver()

Create a DatabaseConnectorDriver object

dbAppendTable(<DatabaseConnectorConnection>,<character>,<data.frame>)

Insert rows into a table

dbClearResult(<DatabaseConnectorResult>)

Clear a result set

dbColumnInfo(<DatabaseConnectorResult>)

Information about result types

dbConnect(<DatabaseConnectorDriver>)

Create a connection to a DBMS

dbCreateTable(<DatabaseConnectorConnection>,<character>,<data.frame>)

Create a table in the database

dbDisconnect(<DatabaseConnectorConnection>)

Disconnect (close) a connection

dbExecute(<DatabaseConnectorConnection>,<character>)

Execute an update statement, query number of rows affected, and then close result set

dbExistsTable(<DatabaseConnectorConnection>,<character>)

Does a table exist?

dbFetch(<DatabaseConnectorResult>)

Fetch records from a previously executed query

dbGetQuery(<DatabaseConnectorConnection>,<character>)

Send query, retrieve results and then clear result set

dbGetRowCount(<DatabaseConnectorResult>)

The number of rows fetched so far

dbGetRowsAffected(<DatabaseConnectorResult>)

The number of rows affected

dbGetStatement(<DatabaseConnectorResult>)

Get the statement associated with a result set

dbHasCompleted(<DatabaseConnectorResult>)

Completion status

dbIsValid(<DatabaseConnectorDbiConnection>)

Is this DBMS object still valid?

dbIsValid(<DatabaseConnectorJdbcConnection>)

Is this DBMS object still valid?

dbListFields(<DatabaseConnectorConnection>,<character>)

List field names of a remote table

dbListTables(<DatabaseConnectorConnection>)

List remote tables

dbQuoteIdentifier(<DatabaseConnectorConnection>,<character>)

Quote identifiers

dbQuoteString(<DatabaseConnectorConnection>,<character>)

Quote literal strings

dbReadTable(<DatabaseConnectorConnection>,<character>)

Copy data frames from database tables

dbRemoveTable(<DatabaseConnectorConnection>,<character>)

Remove a table from the database

dbSendQuery(<DatabaseConnectorDbiConnection>,<character>)

Execute a query on a given database connection

dbSendQuery(<DatabaseConnectorJdbcConnection>,<character>)

Execute a query on a given database connection

dbSendStatement(<DatabaseConnectorConnection>,<character>)

Execute a data manipulation statement on a given database connection

dbUnloadDriver(<DatabaseConnectorDriver>)

Load and unload database drivers

dbWriteTable(<DatabaseConnectorConnection>,<character>,<data.frame>)

Copy data frames to database tables

disconnect()

Disconnect from the server

executeSql()

Execute SQL code

getTableNames()

List all tables in a database schema.

insertTable()

Insert a table on the server

jdbcDrivers

How to download and use JDBC drivers for the various data platforms.

lowLevelExecuteSql()

Execute SQL code

lowLevelQuerySql.ffdf()

Low level function for retrieving data to an ffdf object

lowLevelQuerySql()

Low level function for retrieving data to a data frame

querySql.ffdf()

Retrieves data to an ffdf object

querySql()

Retrieve data to a data.frame

renderTranslateExecuteSql()

Render, translate, execute SQL code

renderTranslateQuerySql.ffdf()

Render, translate, and query to ffdf

renderTranslateQuerySql()

Render, translate, and query to data.frame

show(<DatabaseConnectorConnection>)

Show an Object

show(<DatabaseConnectorDriver>)

Show an Object