Learn R Programming
⚠️There's a newer version (2.4.6) of this package.Take me there.

RSQLite (version 0.11.3)

SQLite interface for R

Description

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.7.16.2) is included.

Copy Link

Version

Install

install.packages('RSQLite')

Monthly Downloads

178,166

Version

0.11.3

License

LGPL (>= 2)

Maintainer

Seth Falcon

Last Published

April 16th, 2013

Functions in RSQLite (0.11.3)

make.db.names-methods

Make R/S-Plus identifiers into legal SQL identifiers
S4R

R compatibility with S version 4/S-Plus 5+ support functions
dbDataType-methods

Determine the SQL Data Type of an S object
SQLiteConnection-class

Class SQLiteConnection
dbCommit-methods

DBMS Transaction Management
sqliteCopyDatabase

Copy a SQLite database
dbGetInfo-methods

Database interface meta-data
sqliteQuickColumn

Return an entire column from a SQLite database
sqliteSupport

Support Functions
SQLite

Initialize the SQLite engine for the current R session.
dbReadTable-methods

Convenience functions for Importing/Exporting DBMS tables
dbDriver-methods

SQLite implementation of the Database Interface (DBI) classes and drivers
dbObjectId-class

Class dbObjectId
dbListTables-methods

List items from an SQLite DBMS and from objects
fetch-methods

Fetch records from a previously executed query
SQLiteResult-class

Class SQLiteResult
dbConnect-methods

Create a connection object to an SQLite DBMS
dbSendQuery-methods

Execute a SQL statement on a database connection
SQLiteObject-class

Class SQLiteObject
safe.write

Write a data.frame avoiding exceeding memory limits
isIdCurrent

Check whether an dbObjectId handle object is valid or not
SQLiteDriver-class

Class SQLiteDriver
dbCallProc-methods

Call an SQL stored procedure
dbBuildTableDefinition

Build the SQL CREATE TABLE definition as a string
dbSetDataMappings-methods

Set data mappings between SQLite and R/S-Plus
summary-methods

Summarize an SQLite object