Package: RSQLite 2.3.7.9013
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:
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')) |
Bug tracker:https://github.com/r-dbi/rsqlite/issues
Last updated 8 days agofrom:fae813b078. Checks:OK: 9. Indexed: yes.
Target | Result | Date |
---|---|---|
Doc / Vignettes | OK | Aug 31 2024 |
R-4.5-win-x86_64 | OK | Aug 31 2024 |
R-4.5-linux-x86_64 | OK | Aug 31 2024 |
R-4.4-win-x86_64 | OK | Aug 31 2024 |
R-4.4-mac-x86_64 | OK | Aug 31 2024 |
R-4.4-mac-aarch64 | OK | Aug 31 2024 |
R-4.3-win-x86_64 | OK | Aug 31 2024 |
R-4.3-mac-x86_64 | OK | Aug 31 2024 |
R-4.3-mac-aarch64 | OK | Aug 31 2024 |
Exports:datasetsDbdbAppendTabledbAppendTableArrowdbBegindbBeginTransactiondbBinddbBindArrowdbBuildTableDefinitiondbCanConnectdbClearResultdbColumnInfodbCommitdbConnectdbCreateTabledbCreateTableArrowdbDataTypedbDisconnectdbDriverdbExecutedbExistsTabledbFetchdbFetchArrowdbFetchArrowChunkdbGetConnectArgsdbGetExceptiondbGetInfodbGetPreparedQuerydbGetQuerydbGetQueryArrowdbGetRowCountdbGetRowsAffecteddbGetStatementdbHasCompleteddbIsReadOnlydbIsValiddbListFieldsdbListObjectsdbListResultsdbListTablesdbQuoteIdentifierdbQuoteLiteraldbQuoteStringdbReadTabledbReadTableArrowdbRemoveTabledbRollbackdbSendPreparedQuerydbSendQuerydbSendQueryArrowdbSendStatementdbUnloadDriverdbUnquoteIdentifierdbWithTransactiondbWriteTabledbWriteTableArrowfetchIdinitExtensioninitRegExpisIdCurrentisSQLKeywordmake.db.namesrsqliteVersionshowsqlDataSQLiteSQLITE_ROSQLITE_RWSQLITE_RWCsqliteBuildTableDefinitionsqliteCopyDatabasesqliteIsTransactingsqliteQuickColumnsqliteSetBusyHandlerSQLKeywords
Dependencies:bitbit64blobcachemclicpp11DBIfastmapgluelifecyclememoisepkgconfigplogrrlangvctrs
Readme and manuals
Help Manual
Help page | Topics |
---|---|
A sample sqlite database | datasetsDb |
SQLite transaction management | dbBegin,SQLiteConnection-method dbBegin_SQLiteConnection dbCommit,SQLiteConnection-method dbCommit_SQLiteConnection dbRollback,SQLiteConnection-method dbRollback_SQLiteConnection sqlite-transaction sqliteIsTransacting |
Read a database table | dbReadTable,SQLiteConnection,character-method dbReadTable_SQLiteConnection_character |
Write a local data frame or file to the database | dbWriteTable,SQLiteConnection,character,character-method dbWriteTable,SQLiteConnection,character,data.frame-method dbWriteTable_SQLiteConnection_character_character dbWriteTable_SQLiteConnection_character_data.frame |
Add useful extension functions | initExtension |
RSQLite version | rsqliteVersion |
Connect to an SQLite database | RSQLite-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 database | sqliteCopyDatabase |
Configure what SQLite should do when the database is locked | sqliteSetBusyHandler |