Package: RSQLite 3.53.2

Kirill Müller

RSQLite: SQLite Interface for R

Embeds the SQLite database engine in R and provides an interface compliant with the DBI package. The source for the SQLite engine and for various extensions is included. System libraries will never be consulted because this package relies on static linking for the plugins it includes; this also ensures a consistent experience across all installations. Optionally, when libcurl is available at build time, an experimental HTTP/HTTPS virtual file system (VFS) can be enabled to allow read-only access to remote immutable SQLite database files via URIs.

Authors:Kirill Müller [aut, cre], Hadley Wickham [aut], David A. James [aut], Seth Falcon [aut], D. Richard Hipp [ctb], Dan Kennedy [ctb], Joe Mistachkin [ctb], SQLite Authors [ctb], Liam Healy [ctb], R Consortium [fnd], RStudio [cph]

RSQLite_3.53.2.tar.gz
RSQLite_3.53.2.tar.gz(r-4.7-arm64)RSQLite_3.53.2.tar.gz(r-4.7-x86_64)RSQLite_3.53.2.tar.gz(r-4.6-arm64)RSQLite_3.53.2.tar.gz(r-4.6-x86_64)
RSQLite_3.53.2.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
RSQLite/json (API)
NEWS

# Install 'RSQLite' in R:
install.packages('RSQLite', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/r-dbi/rsqlite/issues

Pkgdown/docs site:https://rsqlite.r-dbi.org

Uses libs:
  • curl– Easy-to-use client-side URL transfer library
  • c++– GNU Standard C++ Library v3

On CRAN:

Conda:

curlcpp

14.67 score 3 stars 1.2k packages 15k scripts 250k downloads 27 mentions 80 exports 14 dependencies

Last updated from:d89d10f088. Checks:6 OK. Indexed: no.

TargetResultTimeFilesSyslog
linux-devel-arm64OK195
linux-devel-x86_64OK227
source / vignettesOK340
linux-release-arm64OK210
linux-release-x86_64OK211
wasm-releaseOK177

Exports:datasetsDbdbAppendTabledbAppendTableArrowdbBegindbBeginTransactiondbBinddbBindArrowdbBuildTableDefinitiondbCanConnectdbClearResultdbColumnInfodbCommitdbConnectdbCreateTabledbCreateTableArrowdbDataTypedbDisconnectdbDriverdbExecutedbExistsTabledbFetchdbFetchArrowdbFetchArrowChunkdbGetConnectArgsdbGetExceptiondbGetInfodbGetPreparedQuerydbGetQuerydbGetQueryArrowdbGetRowCountdbGetRowsAffecteddbGetStatementdbHasCompleteddbIsReadOnlydbIsValiddbListFieldsdbListObjectsdbListResultsdbListTablesdbQuoteIdentifierdbQuoteLiteraldbQuoteStringdbReadTabledbReadTableArrowdbRemoveTabledbRollbackdbSendPreparedQuerydbSendQuerydbSendQueryArrowdbSendStatementdbUnloadDriverdbUnquoteIdentifierdbWithTransactiondbWriteTabledbWriteTableArrowfetchIdinitExtensioninitRegExpisIdCurrentisSQLKeywordmake.db.namesrsqliteVersionshowsqlDataSQLiteSQLITE_ROSQLITE_RWSQLITE_RWCsqliteBuildTableDefinitionsqliteCopyDatabasesqliteHasHttpVFSsqliteHttpConfigsqliteHttpStatssqliteHttpVfsCompiledsqliteIsTransactingsqliteQuickColumnsqliteRemotesqliteSetBusyHandlerSQLKeywords

Dependencies:bitbit64blobcachemclicpp11DBIfastmapgluelifecyclememoisepkgconfigrlangvctrs

RSQLite

Hadley Wickham

Rendered fromRSQLite.Rmdusingknitr::rmarkdownon Jun 17 2026.

Last update: 2022-08-17
Started: 2016-11-27

Readme and manuals

Help Manual

Help pageTopics
A sample sqlite databasedatasetsDb
SQLite transaction managementdbBegin,SQLiteConnection-method dbBegin_SQLiteConnection dbCommit,SQLiteConnection-method dbCommit_SQLiteConnection dbRollback,SQLiteConnection-method dbRollback_SQLiteConnection sqlite-transaction sqliteIsTransacting
Read a database tabledbReadTable,SQLiteConnection,character-method dbReadTable_SQLiteConnection_character
Write a local data frame or file to the databasedbWriteTable,SQLiteConnection,character,character-method dbWriteTable,SQLiteConnection,character,data.frame-method dbWriteTable_SQLiteConnection_character_character dbWriteTable_SQLiteConnection_character_data.frame
Add useful extension functionsinitExtension
RSQLite versionrsqliteVersion
Connect to an SQLite databaseRSQLite-package dbConnect,SQLiteConnection-method dbConnect,SQLiteDriver-method dbConnect_SQLiteConnection dbConnect_SQLiteDriver dbDisconnect,SQLiteConnection-method dbDisconnect_SQLiteConnection RSQLite SQLite SQLITE_RO SQLITE_RW SQLITE_RWC
Copy a SQLite databasesqliteCopyDatabase
Check for HTTP VFS supportsqliteHasHttpVFS
Configure experimental HTTP VFS behavior (optional)sqliteHttpConfig
Experimental HTTP VFS statisticssqliteHttpStats
Was HTTP VFS compiled into this build?sqliteHttpVfsCompiled
Convenience helper for opening remote SQLite databases over HTTP/HTTPSsqliteRemote
Configure what SQLite should do when the database is lockedsqliteSetBusyHandler