'SQLite' Interface for R

[Up] [Top]

Documentation for package ‘RSQLite’ version 1.1-2

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