Man pages for RSQLite
SQLite Interface for R

datasetsDbA sample sqlite database
dbBeginTransactionGeneric for creating a new transaction
dbListResultsdbListResults
dbReadTableRead a database table
dbWriteTableWrite a local data frame or file to the database
fetchFetch
initExtensionAdd useful extension functions
initRegExpAdd regular expression operator
isIdCurrentisIdCurrent
keywords-depMake R/S-Plus identifiers into legal SQL identifiers
query-depDeprecated querying tools
reexportsObjects exported from other packages
rsqliteVersionRSQLite version
SQLiteConnect to an SQLite database
sqliteBuildTableDefinitionBuild the SQL CREATE TABLE definition as a string
SQLiteConnection-classClass SQLiteConnection (and methods)
sqliteCopyDatabaseCopy a SQLite database
SQLiteDriver-classClass SQLiteDriver (and methods)
sqliteHasHttpVFSCheck for HTTP VFS support
sqliteHttpConfigConfigure experimental HTTP VFS behavior (optional)
sqliteHttpStatsExperimental HTTP VFS statistics
sqliteHttpVfsCompiledWas HTTP VFS compiled into this build?
sqliteQuickColumnReturn an entire column from a SQLite database
sqliteRemoteConvenience helper for opening remote SQLite databases over...
SQLiteResult-classClass SQLiteResult (and methods)
sqliteSetBusyHandlerConfigure what SQLite should do when the database is locked
sqlite-transactionSQLite transaction management
RSQLite documentation built on July 1, 2026, 1:06 a.m.