SQLite Interface for R
A sample sqlite database
Generic for creating a new transaction
dbListResults
Read a database table
Write a local data frame or file to the database
Fetch
Add useful extension functions
Add regular expression operator
isIdCurrent
Make R/S-Plus identifiers into legal SQL identifiers
Deprecated querying tools
Objects exported from other packages
RSQLite version
SQLite transaction management
Connect to an SQLite database
Build the SQL CREATE TABLE definition as a string
Class SQLiteConnection (and methods)
Copy a SQLite database
Class SQLiteDriver (and methods)
Return an entire column from a SQLite database
Class SQLiteResult (and methods)
Configure what SQLite should do when the database is locked
Embeds the SQLite database engine in R and provides an interface compliant with the DBI package. The source for the SQLite engine (version 3.50.4) and for various extensions is included. System libraries will never be consulted because this package relies on static linking for the plugins it includes; this also ensures a consistent experience across all installations.
Useful links