Package: RSQLite 3.53.0.9001

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.0.9001.tar.gz
RSQLite_3.53.0.9001.zip(r-4.7)RSQLite_3.53.0.9001.zip(r-4.6)RSQLite_3.53.0.9001.zip(r-4.5)
RSQLite_3.53.0.9001.tgz(r-4.6-x86_64)RSQLite_3.53.0.9001.tgz(r-4.6-arm64)RSQLite_3.53.0.9001.tgz(r-4.5-x86_64)RSQLite_3.53.0.9001.tgz(r-4.5-arm64)
RSQLite_3.53.0.9001.tar.gz(r-4.7-arm64)RSQLite_3.53.0.9001.tar.gz(r-4.7-x86_64)RSQLite_3.53.0.9001.tar.gz(r-4.6-arm64)RSQLite_3.53.0.9001.tar.gz(r-4.6-x86_64)
RSQLite_3.53.0.9001.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://cynkra.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.27 score 336 stars 1.2k packages 11k scripts 235k downloads 27 mentions 75 exports 14 dependencies

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

TargetResultTimeFilesSyslog
linux-devel-arm64OK198
linux-devel-x86_64OK207
source / vignettesOK323
linux-release-arm64OK216
linux-release-x86_64OK204
macos-release-arm64OK123
macos-release-x86_64OK490
macos-oldrel-arm64OK125
macos-oldrel-x86_64OK318
windows-develOK299
windows-releaseOK270
windows-oldrelOK298
wasm-releaseOK183

Exports:datasetsDbdbAppendTabledbAppendTableArrowdbBegindbBeginTransactiondbBinddbBindArrowdbBuildTableDefinitiondbCanConnectdbClearResultdbColumnInfodbCommitdbConnectdbCreateTabledbCreateTableArrowdbDataTypedbDisconnectdbDriverdbExecutedbExistsTabledbFetchdbFetchArrowdbFetchArrowChunkdbGetConnectArgsdbGetExceptiondbGetInfodbGetPreparedQuerydbGetQuerydbGetQueryArrowdbGetRowCountdbGetRowsAffecteddbGetStatementdbHasCompleteddbIsReadOnlydbIsValiddbListFieldsdbListObjectsdbListResultsdbListTablesdbQuoteIdentifierdbQuoteLiteraldbQuoteStringdbReadTabledbReadTableArrowdbRemoveTabledbRollbackdbSendPreparedQuerydbSendQuerydbSendQueryArrowdbSendStatementdbUnloadDriverdbUnquoteIdentifierdbWithTransactiondbWriteTabledbWriteTableArrowfetchIdinitExtensioninitRegExpisIdCurrentisSQLKeywordmake.db.namesrsqliteVersionshowsqlDataSQLiteSQLITE_ROSQLITE_RWSQLITE_RWCsqliteBuildTableDefinitionsqliteCopyDatabasesqliteIsTransactingsqliteQuickColumnsqliteSetBusyHandlerSQLKeywords

Dependencies:bitbit64blobcachemclicpp11DBIfastmapgluelifecyclememoisepkgconfigrlangvctrs

RSQLite

Hadley Wickham

Rendered fromRSQLite.Rmdusingknitr::rmarkdownon May 25 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