# 'SQLite' Interface for R

## Documentation for package ‘RSQLite’ version 1.1

- DESCRIPTION file.
- User guides, package vignettes and other documentation.

## Help Pages

datasetsDb | A sample sqlite database
dbBegin-method | SQLite transaction management
dbBind-method | Execute a SQL statement on a database connection
dbClearResult-method | Execute a SQL statement on a database connection
dbColumnInfo-method | Result information
dbCommit-method | SQLite transaction management
dbConnect-method | Connect to an SQLite database
dbDataType-method | Determine the SQL Data Type of an R object
dbDisconnect-method | Connect to an SQLite database
dbExistsTable-method | Tables in a database
dbFetch-method | Execute a SQL statement on a database connection
dbGetRowCount-method | Result information
dbGetRowsAffected-method | Result information
dbGetStatement-method | Result information
dbHasCompleted-method | Result information
dbListFields-method | List fields in a table
dbListTables-method | Tables in a database
dbReadTable-method | Read a database table
dbRemoveTable-method | Remove a table from the database
dbRollback-method | SQLite transaction management
dbSendQuery-method | Execute a SQL statement on a database connection
dbWriteTable-method | Write a local data frame or file to the database
initExtension | Add useful extension functions
rsqliteVersion | RSQLite version
sqlData-method | Write a local data frame or file to the database
SQLite | Connect to an SQLite database
sqlite-meta | Result information
sqlite-query | Execute a SQL statement on a database connection
sqlite-transaction | SQLite transaction management
sqliteCopyDatabase | Copy a SQLite database
SQLITE_RO | Connect to an SQLite database
SQLITE_RW | Connect to an SQLite database
SQLITE_RWC | Connect to an SQLite database