Learn R Programming

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

RSQLite (version 0.6-9)

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

Copy Link

Version

Install

install.packages('RSQLite')

Monthly Downloads

114,555

Version

0.6-9

License

LGPL (>= 2)

Maintainer

Last Published

May 27th, 2024

Functions in RSQLite (0.6-9)

Write a data.frame avoiding exceeding memory limits

make.db.names-methods

Make R/S-Plus identifiers into legal SQL identifiers

dbConnect-methods

Create a connection object to an SQLite DBMS

SQLiteResult-class

Class SQLiteResult

Fetch records from a previously executed query

sqliteQuickColumn

Return an entire column from a SQLite database

dbCallProc-methods

Call an SQL stored procedure

dbReadTable-methods

Convenience functions for Importing/Exporting DBMS tables

SQLiteDriver-class

Class SQLiteDriver

dbSendQuery-methods

Execute a SQL statement on a database connection

dbObjectId-class

Class dbObjectId

dbListTables-methods

List items from an SQLite DBMS and from objects

SQLiteObject-class

Class SQLiteObject

Instantiate the SQLite engine from the current R session.

dbSetDataMappings-methods

Set data mappings between SQLite and R/S-Plus

dbDataType-methods

Determine the SQL Data Type of an S object

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

SQLiteConnection-class

Class SQLiteConnection

summary-methods

Summarize an SQLite object

dbDriver-methods

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

dbBuildTableDefinition

Build the SQL CREATE TABLE definition as a string

dbGetInfo-methods

Database interface meta-data

Support Functions

dbCommit-methods

DBMS Transaction Management

Check whether an dbObjectId handle object is valid or not