Function reference • RSQLite

All functions

SQLite() dbConnect(<SQLiteConnection>) dbConnect(<SQLiteDriver>) dbDisconnect(<SQLiteConnection>): Connect to an SQLite database

datasetsDb(): A sample sqlite database

dbReadTable(<SQLiteConnection>,<character>): Read a database table

dbWriteTable(<SQLiteConnection>,<character>,<character>) dbWriteTable(<SQLiteConnection>,<character>,<data.frame>): Write a local data frame or file to the database

initExtension(): Add useful extension functions

rsqliteVersion(): RSQLite version

dbBegin(<SQLiteConnection>) dbCommit(<SQLiteConnection>) dbRollback(<SQLiteConnection>) sqliteIsTransacting(): SQLite transaction management

sqliteCopyDatabase(): Copy a SQLite database

sqliteSetBusyHandler(): Configure what SQLite should do when the database is locked