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 (version 3.8.8.2) is included.

Install the latest version of this package by entering the following in R:
install.packages("RSQLite")
AuthorKirill Müller [aut, cre], Hadley Wickham [aut], David A. James [aut], Seth Falcon [aut], SQLite Authors [ctb] (for the included SQLite sources), Liam Healy [ctb] (for the included SQLite sources), R Consortium [cph], RStudio [cph]
Date of publication2017-01-08 16:57:09
MaintainerKirill Müller <krlmlr+r@mailbox.org>
LicenseLGPL (>= 2)
Version1.1-2
https://github.com/rstats-db/RSQLite

View on CRAN

Functions

datasetsDb Man page
dbBegin,SQLiteConnection-method Man page
dbBeginTransaction Man page
dbBind,SQLiteResult-method Man page
dbBuildTableDefinition Man page
dbClearResult,SQLiteResult-method Man page
dbColumnInfo,SQLiteResult-method Man page
dbCommit,SQLiteConnection-method Man page
dbConnect,SQLiteConnection-method Man page
dbConnect,SQLiteDriver-method Man page
dbDataType,SQLiteConnection-method Man page
dbDataType,SQLiteDriver-method Man page
dbDisconnect,SQLiteConnection-method Man page
dbDriver Man page
dbExistsTable,SQLiteConnection,character-method Man page
dbFetch,SQLiteResult-method Man page
dbGetException,SQLiteConnection-method Man page
dbGetInfo Man page
dbGetInfo,SQLiteConnection-method Man page
dbGetInfo,SQLiteDriver-method Man page
dbGetPreparedQuery Man page
dbGetPreparedQuery,SQLiteConnection,character,data.frame-method Man page
dbGetQuery Man page
dbGetQuery,NULL,ANY-method Man page
dbGetRowCount,SQLiteResult-method Man page
dbGetRowsAffected,SQLiteResult-method Man page
dbGetStatement,SQLiteResult-method Man page
dbHasCompleted,SQLiteResult-method Man page
dbIsValid,SQLiteConnection-method Man page
dbIsValid,SQLiteDriver-method Man page
dbIsValid,SQLiteResult-method Man page
dbListFields,SQLiteConnection,character-method Man page
dbListResults,SQLiteConnection-method Man page
dbListTables,SQLiteConnection-method Man page
dbReadTable,SQLiteConnection,character-method Man page
dbRemoveTable,SQLiteConnection,character-method Man page
dbRollback,SQLiteConnection-method Man page
dbSendPreparedQuery Man page
dbSendPreparedQuery,SQLiteConnection,character,data.frame-method Man page
dbSendQuery,SQLiteConnection,character-method Man page
dbUnloadDriver,SQLiteDriver-method Man page
dbWriteTable,SQLiteConnection,character,character-method Man page
dbWriteTable,SQLiteConnection,character,data.frame-method Man page
dummy-methods Man page
fetch,SQLiteResult-method Man page
initExtension Man page
isIdCurrent Man page
isSQLKeyword,SQLiteConnection,character-method Man page
make.db.names,SQLiteConnection,character-method Man page
query-dep Man page
reexports Man page
rsqliteVersion Man page
show,SQLiteConnection-method Man page
sqlData,SQLiteConnection-method Man page
SQLite Man page
sqliteBuildTableDefinition Man page
SQLiteConnection-class Man page
sqliteCopyDatabase Man page
SQLiteDriver-class Man page
sqlite-meta Man page
sqlite-query Man page
sqliteQuickColumn Man page
SQLiteResult-class Man page
SQLITE_RO Man page
SQLITE_RW Man page
SQLITE_RWC Man page
sqlite-transaction Man page
SQLKeywords,SQLiteConnection-method Man page

Files

inst
inst/db
inst/db/datasets.sqlite
inst/doc
inst/doc/RSQLite.Rmd
inst/doc/RSQLite.R
inst/doc/RSQLite.html
tests
tests/testthat.R
tests/testthat
tests/testthat/test-basic-types.R tests/testthat/test-field-types.R tests/testthat/test-blob.R tests/testthat/helper-tibble.R tests/testthat/test-DBItest.R tests/testthat/test-data-type.R tests/testthat/helper-astyle.R tests/testthat/test-dbConnect.R
tests/testthat/dat-n.txt
tests/testthat/test-dbSendQuery.R tests/testthat/test-affinity.R
tests/testthat/dat-rn.txt
tests/testthat/test-dbClearResult.R tests/testthat/test-error.R tests/testthat/test-sqliteCopyDatabase.R tests/testthat/helper-DBItest.R tests/testthat/test-astyle.R tests/testthat/test-dbWriteTableAutoincrement.R tests/testthat/test-exception.R tests/testthat/test-sqliteQuickColumn.R tests/testthat/test-dbWriteTable.R tests/testthat/test-json.R tests/testthat/helper-memdb.R tests/testthat/test-transactions.R
src
src/result.cpp
src/SqliteResultImpl.h
src/SqliteResultImpl.cpp
src/Makevars
src/RSQLite_types.h
src/SqliteConnection.h
src/import-file.c
src/SqliteResult.cpp
src/affinity.c
src/affinity.h
src/sqlite3.h
src/SqliteDataFrame.h
src/connection.cpp
src/SqliteUtils.h
src/SqliteResult.h
src/sqlite3
src/sqlite3/sqlite3.h
src/sqlite3/sqlite3ext.h
src/sqlite3/sqlite3.h.orig
src/sqlite3/sqlite3.c
src/sqlite3/extension-functions.c
src/SqliteConnection.cpp
src/workarounds
src/workarounds/XPtr.h
src/SqliteDataFrame.cpp
src/RSQLite.h
src/RcppExports.cpp
src/rsqlite.cpp
NAMESPACE
NEWS.md
R
R/dummy.R R/utils.R R/extensions.R R/copy.R R/connect.R R/rownames.R R/query.R R/RcppExports.R R/deprecated.R R/SQLiteConnection.R R/transactions.R R/table.R R/SQLiteDriver.R R/SQLiteResult.R R/datasetsDb.R R/zzz.R
vignettes
vignettes/RSQLite.Rmd
README.md
MD5
build
build/vignette.rds
DESCRIPTION
man
man/SQLiteResult-class.Rd man/dbGetInfo.Rd man/SQLiteDriver-class.Rd man/isIdCurrent.Rd man/dummy-methods.Rd man/initExtension.Rd man/sqliteCopyDatabase.Rd man/dbExistsTable-SQLiteConnection-character-method.Rd man/datasetsDb.Rd man/dbDataType-SQLiteDriver-method.Rd man/sqliteBuildTableDefinition.Rd man/dbListResults-SQLiteConnection-method.Rd man/SQLite.Rd man/sqlite-transaction.Rd man/fetch-SQLiteResult-method.Rd man/dbRemoveTable-SQLiteConnection-character-method.Rd man/sqlite-query.Rd man/dbWriteTable.Rd man/sqlite-meta.Rd man/reexports.Rd man/dbBeginTransaction.Rd man/make.db.names-SQLiteConnection-character-method.Rd man/query-dep.Rd man/sqliteQuickColumn.Rd man/dbReadTable-SQLiteConnection-character-method.Rd man/SQLiteConnection-class.Rd man/dbListFields-SQLiteConnection-character-method.Rd man/rsqliteVersion.Rd

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

Please suggest features or report bugs with the GitHub issue tracker.

All documentation is copyright its authors; we didn't write any of that.