RSQLite v0.8-0


Monthly downloads



by Seth Falcon

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 package. The source for the SQLite engine (version 3.6.21) is included.

Functions in RSQLite

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

Last month downloads


LazyLoad yes
License LGPL (>= 2)
Collate zzz.R S4R.R dbObjectId.R SQLite.R SQLiteSupport.R
Packaged 2009-12-21 19:58:22 UTC; sfalcon
Repository CRAN
Date/Publication 2009-12-22 07:54:51

Include our badge in your README