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