RSQLite

v. 
by Kirill Müller
0

Monthly downloads

0th

Percentile

0
Date 2017-01-07
LinkingTo Rcpp, BH, plogr
Encoding UTF-8
License LGPL (>= 2)
URL https://github.com/rstats-db/RSQLite
BugReports https://github.com/rstats-db/RSQLite/issues
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
RoxygenNote 5.0.1.9000
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 3.8.8.2) 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!

Dependencies

Get your badge !

[![Rdoc](http://www.rdocumentation.org/badges/version/RSQLite)](http://www.rdocumentation.org/packages/RSQLite)