Package: RSQLite 3.53.1.9006

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.

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.1.9006.tar.gz
RSQLite_3.53.1.9006.zip(r-4.7)RSQLite_3.53.1.9006.zip(r-4.6)RSQLite_3.53.1.9006.zip(r-4.5)
RSQLite_3.53.1.9006.tgz(r-4.6-x86_64)RSQLite_3.53.1.9006.tgz(r-4.6-arm64)RSQLite_3.53.1.9006.tgz(r-4.5-x86_64)RSQLite_3.53.1.9006.tgz(r-4.5-arm64)
RSQLite_3.53.1.9006.tar.gz(r-4.7-arm64)RSQLite_3.53.1.9006.tar.gz(r-4.7-x86_64)RSQLite_3.53.1.9006.tar.gz(r-4.6-arm64)RSQLite_3.53.1.9006.tar.gz(r-4.6-x86_64)
RSQLite_3.53.1.9006.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://ar-puuk.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:
  • c++– GNU Standard C++ Library v3

On CRAN:

Conda:

databasesqlite3cpp

19.33 score 337 stars 1.2k packages 11k scripts 262k downloads 27 mentions 75 exports 14 dependencies

Last updated from:d3b0d08f0e. Checks:13 OK. Indexed: no.

TargetResultTimeFilesSyslog
linux-devel-arm64OK183
linux-devel-x86_64OK196
source / vignettesOK242
linux-release-arm64OK190
linux-release-x86_64OK201
macos-release-arm64OK187
macos-release-x86_64OK254
macos-oldrel-arm64OK126
macos-oldrel-x86_64OK332
windows-develOK214
windows-releaseOK320
windows-oldrelOK327
wasm-releaseOK158

Exports:datasetsDbdbAppendTabledbAppendTableArrowdbBegindbBeginTransactiondbBinddbBindArrowdbBuildTableDefinitiondbCanConnectdbClearResultdbColumnInfodbCommitdbConnectdbCreateTabledbCreateTableArrowdbDataTypedbDisconnectdbDriverdbExecutedbExistsTabledbFetchdbFetchArrowdbFetchArrowChunkdbGetConnectArgsdbGetExceptiondbGetInfodbGetPreparedQuerydbGetQuerydbGetQueryArrowdbGetRowCountdbGetRowsAffecteddbGetStatementdbHasCompleteddbIsReadOnlydbIsValiddbListFieldsdbListObjectsdbListResultsdbListTablesdbQuoteIdentifierdbQuoteLiteraldbQuoteStringdbReadTabledbReadTableArrowdbRemoveTabledbRollbackdbSendPreparedQuerydbSendQuerydbSendQueryArrowdbSendStatementdbUnloadDriverdbUnquoteIdentifierdbWithTransactiondbWriteTabledbWriteTableArrowfetchIdinitExtensioninitRegExpisIdCurrentisSQLKeywordmake.db.namesrsqliteVersionshowsqlDataSQLiteSQLITE_ROSQLITE_RWSQLITE_RWCsqliteBuildTableDefinitionsqliteCopyDatabasesqliteIsTransactingsqliteQuickColumnsqliteSetBusyHandlerSQLKeywords

Dependencies:bitbit64blobcachemclicpp11DBIfastmapgluelifecyclememoisepkgconfigrlangvctrs

RSQLite

Hadley Wickham

Rendered fromRSQLite.Rmdusingknitr::rmarkdownon Jun 10 2026.

Last update: 2022-08-16
Started: 2015-02-04

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
Configure what SQLite should do when the database is lockedsqliteSetBusyHandler