RSQLite v0.4-1


Monthly downloads



by David James

SQLite interface for R

Database Interface R driver for SQLite This package embeds the SQLite database engine in R and provides an interface compliant with the DBI version 0.1-8. The source for the SQLite engine (version 3.2.8) is included.

Functions in RSQLite

Name Description
dbConnect-methods Create a connection object to an SQLite DBMS
dbDataType-methods Determine the SQL Data Type of an S object
dbCallProc-methods Call an SQL stored procedure
dbSetDataMappings-methods Set data mappings between SQLite and R/S-Plus
dbReadTable-methods Convenience functions for Importing/Exporting DBMS tables
fetch-methods Fetch records from a previously executed query
sqliteSupport Support Functions
SQLiteResult-class Class SQLiteResult
SQLite Instantiate the SQLite engine from the current R session.
dbListTables-methods List items from an SQLite DBMS and from objects
S4R R compatibility with S version 4/S-Plus 5+ support functions
dbBuildTableDefinition Build the SQL CREATE TABLE definition as a string
dbDriver-methods SQLite implementation of the Database Interface (DBI) classes and drivers
dbObjectId-class Class dbObjectId
SQLiteObject-class Class SQLiteObject
dbCommit-methods DBMS Transaction Management
sqliteQuickColumn Return an entire column from a SQLite database
isIdCurrent Check whether an dbObjectId handle object is valid or not
SQLiteDriver-class Class SQLiteDriver
summary-methods Summarize an SQLite object
dbGetInfo-methods Database interface meta-data
safe.write Write a data.frame avoiding exceeding memory limits
SQLiteConnection-class Class SQLiteConnection
dbSendQuery-methods Execute a statement on a given database connection
make.db.names-methods Make R/S-Plus identifiers into legal SQL identifiers
No Results!

Last month downloads


Date 2006-01-18
SaveImage yes
License LGPL version 2 or newer
Packaged Thu Jan 19 10:56:32 2006; dj

Include our badge in your README