Skip to contents

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
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?
sqliteRemote()
Convenience helper for opening remote SQLite databases over HTTP/HTTPS
sqliteSetBusyHandler()
Configure what SQLite should do when the database is locked