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

RSQLite (version 0.9-4)

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

Copy Link

Version

Install

install.packages('RSQLite')

Monthly Downloads

178,166

Version

0.9-4

License

LGPL (>= 2)

Maintainer

Seth Falcon

Last Published

November 24th, 2010

Functions in RSQLite (0.9-4)

fetch-methods

Fetch records from a previously executed query
dbObjectId-class

Class dbObjectId
make.db.names-methods

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

Build the SQL CREATE TABLE definition as a string
SQLiteObject-class

Class SQLiteObject
summary-methods

Summarize an SQLite object
sqliteCopyDatabase

Copy a SQLite database
SQLiteResult-class

Class SQLiteResult
dbDataType-methods

Determine the SQL Data Type of an S object
sqliteQuickColumn

Return an entire column from a SQLite database
S4R

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

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

DBMS Transaction Management
SQLite

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

Execute a SQL statement on a database connection
SQLiteConnection-class

Class SQLiteConnection
isIdCurrent

Check whether an dbObjectId handle object is valid or not
sqliteSupport

Support Functions
dbCallProc-methods

Call an SQL stored procedure
dbReadTable-methods

Convenience functions for Importing/Exporting DBMS tables
dbGetInfo-methods

Database interface meta-data
dbConnect-methods

Create a connection object to an SQLite DBMS
dbDriver-methods

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

Class SQLiteDriver
dbSetDataMappings-methods

Set data mappings between SQLite and R/S-Plus
safe.write

Write a data.frame avoiding exceeding memory limits