This package is considered a duplicate. The official version of this package is found at:https://r-dbi.r-universe.dev/RSQLite

Package: RSQLite 3.53.2.9007

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. Optionally, when libcurl is available at build time, an experimental HTTP/HTTPS virtual file system (VFS) can be enabled to allow read-only access to remote immutable SQLite database files via URIs.

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.2.9007.tar.gz
RSQLite_3.53.2.9007.zip(r-4.7)RSQLite_3.53.2.9007.zip(r-4.6)RSQLite_3.53.2.9007.zip(r-4.5)
RSQLite_3.53.2.9007.tgz(r-4.6-x86_64)RSQLite_3.53.2.9007.tgz(r-4.6-arm64)RSQLite_3.53.2.9007.tgz(r-4.5-arm64)RSQLite_3.53.2.9007.tgz(r-4.5-x86_64)
RSQLite_3.53.2.9007.tar.gz(r-4.7-arm64)RSQLite_3.53.2.9007.tar.gz(r-4.7-x86_64)RSQLite_3.53.2.9007.tar.gz(r-4.6-arm64)RSQLite_3.53.2.9007.tar.gz(r-4.6-x86_64)
RSQLite_3.53.2.9007.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
RSQLite/json (API)

# 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:

curl– Easy-to-use client-side URL transfer library
c++– GNU Standard C++ Library v3

On CRAN:

database sqlite3 curl cpp

19.49 score 338 stars 1.2k packages 15k scripts 267k downloads 27 mentions 80 exports 14 dependencies

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

Target	Result	Time
linux-devel-arm64	OK	214
linux-devel-x86_64	OK	225
source / vignettes	OK	308
linux-release-arm64	OK	221
linux-release-x86_64	OK	225
macos-release-arm64	OK	126
macos-release-x86_64	OK	397
macos-oldrel-arm64	OK	170
macos-oldrel-x86_64	OK	557
windows-devel	OK	423
windows-release	OK	332
windows-oldrel	OK	378
wasm-release	OK	206

Exports:datasetsDb dbAppendTable dbAppendTableArrow dbBegin dbBeginTransaction dbBind dbBindArrow dbBuildTableDefinition dbCanConnect dbClearResult dbColumnInfo dbCommit dbConnect dbCreateTable dbCreateTableArrow dbDataType dbDisconnect dbDriver dbExecute dbExistsTable dbFetch dbFetchArrow dbFetchArrowChunk dbGetConnectArgs dbGetException dbGetInfo dbGetPreparedQuery dbGetQuery dbGetQueryArrow dbGetRowCount dbGetRowsAffected dbGetStatement dbHasCompleted dbIsReadOnly dbIsValid dbListFields dbListObjects dbListResults dbListTables dbQuoteIdentifier dbQuoteLiteral dbQuoteString dbReadTable dbReadTableArrow dbRemoveTable dbRollback dbSendPreparedQuery dbSendQuery dbSendQueryArrow dbSendStatement dbUnloadDriver dbUnquoteIdentifier dbWithTransaction dbWriteTable dbWriteTableArrow fetch Id initExtension initRegExp isIdCurrent isSQLKeyword make.db.names rsqliteVersion show sqlData SQLite SQLITE_RO SQLITE_RW SQLITE_RWC sqliteBuildTableDefinition sqliteCopyDatabase sqliteHasHttpVFS sqliteHttpConfig sqliteHttpStats sqliteHttpVfsCompiled sqliteIsTransacting sqliteQuickColumn sqliteRemote sqliteSetBusyHandler SQLKeywords

Dependencies:bit bit64 blob cachem cli cpp11 DBI fastmap glue lifecycle memoise pkgconfig rlang vctrs

RSQLite

Rendered fromRSQLite.Rmdusingknitr::rmarkdown

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

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
Check for HTTP VFS support	sqliteHasHttpVFS
Configure experimental HTTP VFS behavior (optional)	sqliteHttpConfig
Experimental HTTP VFS statistics	sqliteHttpStats
Was HTTP VFS compiled into this build?	sqliteHttpVfsCompiled
Convenience helper for opening remote SQLite databases over HTTP/HTTPS	sqliteRemote
Configure what SQLite should do when the database is locked	sqliteSetBusyHandler

Package: RSQLite 3.53.2.9007

RSQLite: SQLite Interface for R

Citation

Development and contributors

Readme and manuals

Help Manual

Usage by other packages (reverse dependencies)