Package: RSQLite 2.3.7.9013

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 in a recent version 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_2.3.7.9013.tar.gz
RSQLite_2.3.7.9013.zip(r-4.5)RSQLite_2.3.7.9013.zip(r-4.4)RSQLite_2.3.7.9013.zip(r-4.3)
RSQLite_2.3.7.9013.tgz(r-4.4-x86_64)RSQLite_2.3.7.9013.tgz(r-4.4-arm64)RSQLite_2.3.7.9013.tgz(r-4.3-x86_64)RSQLite_2.3.7.9013.tgz(r-4.3-arm64)
RSQLite_2.3.7.9013.tar.gz(r-4.5-noble)RSQLite_2.3.7.9013.tar.gz(r-4.4-noble)
RSQLite_2.3.7.9013.tgz(r-4.4-emscripten)RSQLite_2.3.7.9013.tgz(r-4.3-emscripten)
RSQLite.pdf |RSQLite.html✨
RSQLite/json (API)
NEWS

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

Peer review:

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

Uses libs:
  • c++– GNU Standard C++ Library v3

On CRAN:

databasesqlite3

75 exports 326 stars 12.83 score 15 dependencies 1077 dependents 27 mentions 7.8k scripts 113.0k downloads

Last updated 8 days agofrom:fae813b078. Checks:OK: 9. Indexed: yes.

TargetResultDate
Doc / VignettesOKAug 31 2024
R-4.5-win-x86_64OKAug 31 2024
R-4.5-linux-x86_64OKAug 31 2024
R-4.4-win-x86_64OKAug 31 2024
R-4.4-mac-x86_64OKAug 31 2024
R-4.4-mac-aarch64OKAug 31 2024
R-4.3-win-x86_64OKAug 31 2024
R-4.3-mac-x86_64OKAug 31 2024
R-4.3-mac-aarch64OKAug 31 2024

Exports:datasetsDbdbAppendTabledbAppendTableArrowdbBegindbBeginTransactiondbBinddbBindArrowdbBuildTableDefinitiondbCanConnectdbClearResultdbColumnInfodbCommitdbConnectdbCreateTabledbCreateTableArrowdbDataTypedbDisconnectdbDriverdbExecutedbExistsTabledbFetchdbFetchArrowdbFetchArrowChunkdbGetConnectArgsdbGetExceptiondbGetInfodbGetPreparedQuerydbGetQuerydbGetQueryArrowdbGetRowCountdbGetRowsAffecteddbGetStatementdbHasCompleteddbIsReadOnlydbIsValiddbListFieldsdbListObjectsdbListResultsdbListTablesdbQuoteIdentifierdbQuoteLiteraldbQuoteStringdbReadTabledbReadTableArrowdbRemoveTabledbRollbackdbSendPreparedQuerydbSendQuerydbSendQueryArrowdbSendStatementdbUnloadDriverdbUnquoteIdentifierdbWithTransactiondbWriteTabledbWriteTableArrowfetchIdinitExtensioninitRegExpisIdCurrentisSQLKeywordmake.db.namesrsqliteVersionshowsqlDataSQLiteSQLITE_ROSQLITE_RWSQLITE_RWCsqliteBuildTableDefinitionsqliteCopyDatabasesqliteIsTransactingsqliteQuickColumnsqliteSetBusyHandlerSQLKeywords

Dependencies:bitbit64blobcachemclicpp11DBIfastmapgluelifecyclememoisepkgconfigplogrrlangvctrs

RSQLite

Hadley Wickham

Rendered fromRSQLite.Rmdusingknitr::rmarkdownon Aug 31 2024.

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