# SQLite Interface for R

## Documentation for package ‘RSQLite’ version 1.0.0

- DESCRIPTION file.

## Help Pages

datasetsDb | A sample sqlite database.
dbBegin-method | SQLite transaction management.
dbClearResult-method | Execute a SQL statement on a database connection
dbColumnInfo-method | Database interface meta-data.
dbCommit-method | SQLite transaction management.
dbConnect-method | Connect to/disconnect from a SQLite database.
dbDataType-method | Determine the SQL Data Type of an R object.
dbDisconnect-method | Connect to/disconnect from a SQLite database.
dbExistsTable-method | Does the table exist?
dbFetch-method | Execute a SQL statement on a database connection
dbGetInfo | Get metadata about a database object.
dbGetInfo-method | Get metadata about a database object.
dbGetPreparedQuery | Generics for getting and sending prepared queries.
dbGetPreparedQuery-method | Execute a SQL statement on a database connection
dbGetQuery-method | Execute a SQL statement on a database connection
dbGetRowCount-method | Database interface meta-data.
dbGetRowsAffected-method | Database interface meta-data.
dbGetStatement-method | Database interface meta-data.
dbHasCompleted-method | Database interface meta-data.
dbIsValid | Check whether an SQLite object is valid or not.
dbIsValid-method | Check whether an SQLite object is valid or not.
dbListFields-method | List fields in specified table.
dbListResults-method | Execute a SQL statement on a database connection
dbListTables-method | List available SQLite tables.
dbReadTable-method | Convenience functions for importing/exporting DBMS tables
dbRemoveTable-method | Remove a table from the database.
dbRollback-method | SQLite transaction management.
dbSendPreparedQuery | Generics for getting and sending prepared queries.
dbSendPreparedQuery-method | Execute a SQL statement on a database connection
dbSendQuery-method | Execute a SQL statement on a database connection
dbUnloadDriver-method | Unload SQLite driver.
dbWriteTable-method | Write a local data frame or file to the database.
fetch-method | Execute a SQL statement on a database connection
initExtension | Add useful extension functions.
isIdCurrent | Check whether an SQLite object is valid or not.
query | Execute a SQL statement on a database connection
SQLite | Class SQLiteDriver with constructor SQLite.
sqlite-meta | Database interface meta-data.
SQLiteConnection-class | Class SQLiteConnection.
sqliteCopyDatabase | Copy a SQLite database
SQLiteDriver-class | Class SQLiteDriver with constructor SQLite.
sqliteQuickColumn | Return an entire column from a SQLite database
SQLiteResult-class | Class SQLiteResult
SQLITE_RO | Connect to/disconnect from a SQLite database.
SQLITE_RW | Connect to/disconnect from a SQLite database.
SQLITE_RWC | Connect to/disconnect from a SQLite database.
transactions | SQLite transaction management.