Learn R Programming

⚠️There's a newer version (2.3.10) of this package.Take me there.

RSQLite (version 0.11.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.17) is included.

Copy Link

Version

Install

install.packages('RSQLite')

Monthly Downloads

150,030

Version

0.11.4

License

LGPL (>= 2)

Maintainer

Seth Falcon

Last Published

May 26th, 2013

Functions in RSQLite (0.11.4)

SQLiteResult-class

Class SQLiteResult

dbSetDataMappings-methods

Set data mappings between SQLite and R/S-Plus

dbDriver-methods

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

dbListTables-methods

List items from an SQLite DBMS and from objects

Check whether an dbObjectId handle object is valid or not

Initialize the SQLite engine for the current R session.

summary-methods

Summarize an SQLite object

sqliteQuickColumn

Return an entire column from a SQLite database

dbObjectId-class

Class dbObjectId

sqliteCopyDatabase

Copy a SQLite database

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

SQLiteConnection-class

Class SQLiteConnection

SQLiteObject-class

Class SQLiteObject

Fetch records from a previously executed query

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

Support Functions

dbCommit-methods

DBMS Transaction Management

dbSendQuery-methods

Execute a SQL statement on a database connection

dbGetInfo-methods

Database interface meta-data

make.db.names-methods

Make R/S-Plus identifiers into legal SQL identifiers

SQLiteDriver-class

Class SQLiteDriver

dbReadTable-methods

Convenience functions for Importing/Exporting DBMS tables

dbBuildTableDefinition

Build the SQL CREATE TABLE definition as a string

Write a data.frame avoiding exceeding memory limits