# SQLite interface for R

## Documentation for package ‘RSQLite’ version 0.11.2

- DESCRIPTION file.
- Package NEWS.

## Help Pages

C D F I L M P S misc

## -- C --

coerce-method | Summarize an SQLite object
coerce-methods | Summarize an SQLite object

## -- D --

dbBeginTransaction | DBMS Transaction Management
dbBeginTransaction-method | DBMS Transaction Management
dbBeginTransaction-methods | DBMS Transaction Management
dbBuildTableDefinition | Build the SQL CREATE TABLE definition as a string
dbCallProc-method | Call an SQL stored procedure
dbCallProc-methods | Call an SQL stored procedure
dbClearResult-method | Execute a SQL statement on a database connection
dbColumnInfo-method | Database interface meta-data
dbColumnInfo-methods | Database interface meta-data
dbCommit-method | DBMS Transaction Management
dbCommit-methods | DBMS Transaction Management
dbConnect-method | Create a connection object to an SQLite DBMS
dbConnect-methods | Create a connection object to an SQLite DBMS
dbDataType-method | Determine the SQL Data Type of an S object
dbDataType-methods | Determine the SQL Data Type of an S object
dbDisconnect-method | Create a connection object to an SQLite DBMS
dbDisconnect-methods | Create a connection object to an SQLite DBMS
dbDriver-method | SQLite implementation of the Database Interface (DBI) classes and drivers
dbDriver-methods | SQLite implementation of the Database Interface (DBI) classes and drivers
dbExistsTable-method | Convenience functions for Importing/Exporting DBMS tables
dbExistsTable-methods | Convenience functions for Importing/Exporting DBMS tables
dbGetDBIVersion-methods | Database interface meta-data
dbGetException-method | Execute a SQL statement on a database connection
dbGetException-methods | Execute a SQL statement on a database connection
dbGetInfo | Database interface meta-data
dbGetInfo-method | Database interface meta-data
dbGetPreparedQuery | Execute a SQL statement on a database connection
dbGetPreparedQuery-method | Execute a SQL statement on a database connection
dbGetPreparedQuery-methods | Execute a SQL statement on a database connection
dbGetQuery-method | Execute a SQL statement on a database connection
dbGetQuery-methods | Execute a SQL statement on a database connection
dbGetRowCount-method | Database interface meta-data
dbGetRowCount-methods | Database interface meta-data
dbGetRowsAffected-method | Database interface meta-data
dbGetRowsAffected-methods | Database interface meta-data
dbGetStatement-method | Database interface meta-data
dbGetStatement-methods | Database interface meta-data
dbHasCompleted-method | Database interface meta-data
dbHasCompleted-methods | Database interface meta-data
dbListConnections-method | List items from an SQLite DBMS and from objects
dbListConnections-methods | List items from an SQLite DBMS and from objects
dbListFields-method | List items from an SQLite DBMS and from objects
dbListFields-methods | List items from an SQLite DBMS and from objects
dbListResults-method | List items from an SQLite DBMS and from objects
dbListResults-methods | List items from an SQLite DBMS and from objects
dbListTables-method | List items from an SQLite DBMS and from objects
dbListTables-methods | List items from an SQLite DBMS and from objects
dbObjectId-class | Class dbObjectId
dbReadTable-method | Convenience functions for Importing/Exporting DBMS tables
dbReadTable-methods | Convenience functions for Importing/Exporting DBMS tables
dbRemoveTable-method | Convenience functions for Importing/Exporting DBMS tables
dbRemoveTable-methods | Convenience functions for Importing/Exporting DBMS tables
dbRollback-method | DBMS Transaction Management
dbRollback-methods | DBMS Transaction Management
dbSendPreparedQuery | Execute a SQL statement on a database connection
dbSendPreparedQuery-method | Execute a SQL statement on a database connection
dbSendPreparedQuery-methods | Execute a SQL statement on a database connection
dbSendQuery-method | Execute a SQL statement on a database connection
dbSendQuery-methods | Execute a SQL statement on a database connection
dbSetDataMappings-method | Set data mappings between SQLite and R/S-Plus
dbSetDataMappings-methods | Set data mappings between SQLite and R/S-Plus
dbUnloadDriver-method | SQLite implementation of the Database Interface (DBI) classes and drivers
dbUnloadDriver-methods | SQLite implementation of the Database Interface (DBI) classes and drivers
dbWriteTable-method | Convenience functions for Importing/Exporting DBMS tables
dbWriteTable-methods | Convenience functions for Importing/Exporting DBMS tables

## -- F --

fetch-method | Fetch records from a previously executed query
fetch-methods | Fetch records from a previously executed query
format-method | Summarize an SQLite object
format-methods | Summarize an SQLite object

## -- I --

isIdCurrent | Check whether an dbObjectId handle object is valid or not
isSQLKeyword-method | Make R/S-Plus identifiers into legal SQL identifiers
isSQLKeyword-methods | Make R/S-Plus identifiers into legal SQL identifiers

## -- L --

last.warning | Support Functions

## -- M --

make.db.names-method | Make R/S-Plus identifiers into legal SQL identifiers

## -- P --

print-method | Summarize an SQLite object

## -- S --

show-method | Summarize an SQLite object
show-methods | Summarize an SQLite object
SQLite | Initialize the SQLite engine for the current R session.
sqliteCloseConnection | Support Functions
sqliteCloseDriver | Support Functions
sqliteCloseResult | Support Functions
SQLiteConnection-class | Class SQLiteConnection
sqliteConnectionInfo | Support Functions
sqliteCopyDatabase | Copy a SQLite database
sqliteDataType | Support Functions
sqliteDescribeConnection | Support Functions
sqliteDescribeDriver | Support Functions
sqliteDescribeResult | Support Functions
SQLiteDriver | Initialize the SQLite engine for the current R session.
SQLiteDriver-class | Class SQLiteDriver
sqliteDriverInfo | Support Functions
sqliteExecStatement | Support Functions
sqliteFetch | Support Functions
sqliteFetchOneColumn | Support Functions
sqliteImportFile | Support Functions
sqliteInitDriver | Support Functions
sqliteNewConnection | Support Functions
SQLiteObject-class | Class SQLiteObject
sqliteQuickColumn | Return an entire column from a SQLite database
sqliteQuickSQL | Support Functions
sqliteReadTable | Support Functions
SQLiteResult-class | Class SQLiteResult
sqliteResultInfo | Support Functions
sqliteTableFields | Support Functions
sqliteTransactionStatement | Support Functions
sqliteWriteTable | Support Functions
SQLITE_RO | Support Functions
SQLITE_RW | Support Functions
SQLITE_RWC | Support Functions
SQLKeywords-method | Make R/S-Plus identifiers into legal SQL identifiers
SQLKeywords-methods | Make R/S-Plus identifiers into legal SQL identifiers
summary-method | Summarize an SQLite object
summary-methods | Summarize an SQLite object

## -- misc --

.conflicts.OK | Support Functions
.SQLite.NA.string | Support Functions
.SQLitePkgName | Support Functions
.SQLitePkgRCS | Support Functions
.SQLitePkgVersion | Support Functions