SQLite Interface for R


[Up] [Top]

Documentation for package ‘RSQLite’ version 3.53.2

Help Pages

RSQLite-package Connect to an SQLite database
datasetsDb A sample sqlite database
dbBegin-method SQLite transaction management
dbBegin_SQLiteConnection SQLite transaction management
dbCommit-method SQLite transaction management
dbCommit_SQLiteConnection SQLite transaction management
dbConnect-method Connect to an SQLite database
dbConnect_SQLiteConnection Connect to an SQLite database
dbConnect_SQLiteDriver Connect to an SQLite database
dbDisconnect-method Connect to an SQLite database
dbDisconnect_SQLiteConnection Connect to an SQLite database
dbReadTable-method Read a database table
dbReadTable_SQLiteConnection_character Read a database table
dbRollback-method SQLite transaction management
dbRollback_SQLiteConnection SQLite transaction management
dbWriteTable-method Write a local data frame or file to the database
dbWriteTable_SQLiteConnection_character_character Write a local data frame or file to the database
dbWriteTable_SQLiteConnection_character_data.frame Write a local data frame or file to the database
initExtension Add useful extension functions
RSQLite Connect to an SQLite database
rsqliteVersion RSQLite version
SQLite Connect to an SQLite database
sqlite-transaction SQLite transaction management
sqliteCopyDatabase Copy a SQLite database
sqliteHasHttpVFS Check for HTTP VFS support
sqliteHttpConfig Configure experimental HTTP VFS behavior (optional)
sqliteHttpStats Experimental HTTP VFS statistics
sqliteHttpVfsCompiled Was HTTP VFS compiled into this build?
sqliteIsTransacting SQLite transaction management
sqliteRemote Convenience helper for opening remote SQLite databases over HTTP/HTTPS
sqliteSetBusyHandler Configure what SQLite should do when the database is locked
SQLITE_RO Connect to an SQLite database
SQLITE_RW Connect to an SQLite database
SQLITE_RWC Connect to an SQLite database