RSQLite: 'SQLite' Interface for R
Version 1.1-2

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.

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
URL https://github.com/rstats-db/RSQLite
Package repositoryView on CRAN
InstallationInstall the latest version of this package by entering the following in R:
install.packages("RSQLite")

Getting started

README.md
RSQLite

Popular man pages

dbExistsTable-SQLiteConnection-character-method: Tables in a database
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
SQLite: Connect to an SQLite database
sqliteCopyDatabase: Copy a SQLite database
sqlite-query: Execute a SQL statement on a database connection
See all...

All man pages Function index File listing

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

Functions

SQLITE_RO Man page
SQLITE_RW Man page
SQLITE_RWC Man page
SQLKeywords,SQLiteConnection-method Man page
SQLite Man page Source code
SQLiteConnection-class Man page
SQLiteDriver-class Man page
SQLiteResult-class Man page
check_quoted_identifier Source code
check_vfs Source code
compatRowNames Source code
datasetsDb Man page Source code
dbBegin,SQLiteConnection-method Man page
dbBeginTransaction Man page
dbBind,SQLiteResult-method Man page
dbBuildTableDefinition Man page Source code
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
db_bind Source code
db_data_types Source code
dummy-methods Man page
factor_to_string Source code
fetch,SQLiteResult-method Man page
field_def Source code
initExtension Man page Source code
init_logging Source code
isIdCurrent Man page Source code
isSQLKeyword,SQLiteConnection,character-method Man page
is_url_or_special_filename Source code
make.db.names,SQLiteConnection,character-method Man page
match_col Source code
onUnload Source code
parameterised_insert Source code
query-dep Man page
raw_to_string Source code
reexports Man page Man page
rsqliteVersion Man page Source code
rsqlite_bind_rows Source code
rsqlite_clear_result Source code
rsqlite_column_info Source code
rsqlite_connect Source code
rsqlite_connection_valid Source code
rsqlite_copy_database Source code
rsqlite_disconnect Source code
rsqlite_fetch Source code
rsqlite_find_params Source code
rsqlite_has_completed Source code
rsqlite_import_file Source code
rsqlite_result_valid Source code
rsqlite_row_count Source code
rsqlite_rows_affected Source code
rsqlite_send_query Source code
show,SQLiteConnection-method Man page
sqlData,SQLiteConnection-method Man page
sqlite-meta Man page
sqlite-query Man page
sqlite-transaction Man page
sqliteBuildTableDefinition Man page Source code
sqliteCopyDatabase Man page Source code
sqliteListTables Source code
sqliteListTablesQuery Source code
sqliteListTablesWithName Source code
sqliteQuickColumn Man page Source code
stopc Source code
string_to_utf8 Source code
vcapply Source code
vlapply Source code
warningc Source code

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
RSQLite documentation built on May 19, 2017, 8:29 a.m.