RSQLite v0.8-2


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

Last month downloads


LazyLoad yes
License LGPL (>= 2)
Collate zzz.R S4R.R dbObjectId.R SQLite.R SQLiteSupport.R
Packaged 2010-01-21 19:30:17 UTC; sfalcon
Repository CRAN
Date/Publication 2010-01-22 07:47:18

Include our badge in your README