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.

Author
Kirill 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 publication
2016-11-27 16:31:52
Maintainer
Kirill Müller <krlmlr+r@mailbox.org>
License
LGPL (>= 2)
Version
1.1
URLs

View on CRAN

Man pages

datasetsDb
A sample sqlite database
dbBeginTransaction
Generic for creating a new transaction
dbDataType-SQLiteDriver-method
Determine the SQL Data Type of an R object
dbExistsTable-SQLiteConnection-character-method
Tables in a database
dbGetInfo
Get metadata about a database object
dbListFields-SQLiteConnection-character-method
List fields in a table
dbListResults-SQLiteConnection-method
dbListResults
dbReadTable-SQLiteConnection-character-method
Read a database table
dbRemoveTable-SQLiteConnection-character-method
Remove a table from the database
dbWriteTable
Write a local data frame or file to the database
dummy-methods
Dummy methods
fetch-SQLiteResult-method
Fetch
initExtension
Add useful extension functions
isIdCurrent
isIdCurrent
make.db.names-SQLiteConnection-character-method
Make R/S-Plus identifiers into legal SQL identifiers
query-dep
Deprecated querying tools
reexports
Objects exported from other packages
rsqliteVersion
RSQLite version
SQLite
Connect to an SQLite database
sqliteBuildTableDefinition
Build the SQL CREATE TABLE definition as a string
SQLiteConnection-class
Class SQLiteConnection
sqliteCopyDatabase
Copy a SQLite database
SQLiteDriver-class
Class SQLiteDriver (and methods)
sqlite-meta
Result information
sqlite-query
Execute a SQL statement on a database connection
sqliteQuickColumn
Return an entire column from a SQLite database
SQLiteResult-class
Class SQLiteResult
sqlite-transaction
SQLite transaction management

Files in this package

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