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

RSQLite (version 0.3-5)

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 version 0.1-7. The source for the SQLite engine (version 2.8.6) is included here.

Copy Link

Version

Install

install.packages('RSQLite')

Monthly Downloads

178,166

Version

0.3-5

License

LGPL version 2 or newer

Maintainer

David James

Last Published

February 6th, 2026

Functions in RSQLite (0.3-5)

S4R

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

dbCallProc-methods

Call an SQL stored procedure

dbDataType-methods

Determine the SQL Data Type of an S object

dbDriver-methods

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

SQLite

Instantiate the SQLite engine from the current R/S-Plus session.

dbSendQuery-methods

Execute a statement on a given database connection

SQLiteObject-class

Class SQLiteObject

make.db.names-methods

Make R/S-Plus identifiers into legal SQL identifiers

dbListTables-methods

List items from an SQLite DBMS and from objects

Summarize an SQLite object

SQLiteDriver-class

Class SQLiteDriver

dbCommit-methods

DBMS Transaction Management

dbReadTable-methods

Convenience functions for Importing/Exporting DBMS tables

dbGetInfo-methods

Database interface meta-data

sqliteSupport

Support Functions

dbConnect-methods

Create a connection object to an SQLite DBMS

isIdCurrent

Check whether an dbObjectId handle object is valid or not

dbSetDataMappings-methods

Set data mappings between SQLite and R/S-Plus

safe.write

Write a data.frame avoiding exceeding memory limits

SQLiteConnection-class

Class SQLiteConnection

fetch-methods

Fetch records from a previously executed query