by Kirill Müller

Monthly downloads



Date 2017-01-07
LinkingTo Rcpp, BH, plogr
Encoding UTF-8
License LGPL (>= 2)
Collate 'RcppExports.R' 'SQLiteConnection.R' 'SQLiteDriver.R' 'SQLiteResult.R' 'connect.R' 'copy.R' 'datasetsDb.R' 'deprecated.R' 'dummy.R' 'extensions.R' 'query.R' 'rownames.R' 'table.R' 'transactions.R' 'utils.R' 'zzz.R'
VignetteBuilder knitr
NeedsCompilation yes
Packaged 2017-01-08 00:12:25 UTC; muelleki
Repository CRAN
Date/Publication 2017-01-08 16:57:09

'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 is included.
Full Readme

Functions in RSQLite

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


Get your badge !