Package: RSQLite 2.3.8

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.8.tar.gz
RSQLite_2.3.8.tar.gz(r-4.5-noble)RSQLite_2.3.8.tar.gz(r-4.4-noble)
RSQLite.pdf |RSQLite.html✨
RSQLite/json (API)
NEWS

# Install 'RSQLite' in R:
install.packages('RSQLite', repos = c('https://cran.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

13.88 score 3 stars 1.1k packages 8.0k scripts 128k downloads 27 mentions 75 exports 15 dependencies

Last updated 3 days agofrom:e92ffae1ee. Checks:OK: 1 NOTE: 1. Indexed: no.

TargetResultDate
Doc / VignettesOKNov 18 2024
R-4.5-linux-x86_64NOTENov 18 2024

Exports:datasetsDbdbAppendTabledbAppendTableArrowdbBegindbBeginTransactiondbBinddbBindArrowdbBuildTableDefinitiondbCanConnectdbClearResultdbColumnInfodbCommitdbConnectdbCreateTabledbCreateTableArrowdbDataTypedbDisconnectdbDriverdbExecutedbExistsTabledbFetchdbFetchArrowdbFetchArrowChunkdbGetConnectArgsdbGetExceptiondbGetInfodbGetPreparedQuerydbGetQuerydbGetQueryArrowdbGetRowCountdbGetRowsAffecteddbGetStatementdbHasCompleteddbIsReadOnlydbIsValiddbListFieldsdbListObjectsdbListResultsdbListTablesdbQuoteIdentifierdbQuoteLiteraldbQuoteStringdbReadTabledbReadTableArrowdbRemoveTabledbRollbackdbSendPreparedQuerydbSendQuerydbSendQueryArrowdbSendStatementdbUnloadDriverdbUnquoteIdentifierdbWithTransactiondbWriteTabledbWriteTableArrowfetchIdinitExtensioninitRegExpisIdCurrentisSQLKeywordmake.db.namesrsqliteVersionshowsqlDataSQLiteSQLITE_ROSQLITE_RWSQLITE_RWCsqliteBuildTableDefinitionsqliteCopyDatabasesqliteIsTransactingsqliteQuickColumnsqliteSetBusyHandlerSQLKeywords

Dependencies:bitbit64blobcachemclicpp11DBIfastmapgluelifecyclememoisepkgconfigplogrrlangvctrs

RSQLite

Hadley Wickham

Rendered fromRSQLite.Rmdusingknitr::rmarkdownon Nov 18 2024.

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