Learn R Programming

RSQLite

Embeds the SQLite database engine in R, providing a DBI-compliant interface. SQLite is a public-domain, single-user, very light-weight database engine that implements a decent subset of the SQL 92 standard, including the core table creation, updating, insertion, and selection operations, plus transaction management.

You can install the latest released version from CRAN with:

Or install the latest development version from GitHub with:

Discussions associated with DBI and related database packages take place on R-SIG-DB. The website Databases using R describes the tools and best practices in this ecosystem.

Basic usage

Acknowledgements

Many thanks to Doug Bates, Seth Falcon, Detlef Groth, Ronggui Huang, Kurt Hornik, Uwe Ligges, Charles Loboz, Duncan Murdoch, and Brian D. Ripley for comments, suggestions, bug reports, and/or patches.


Please note that the ‘RSQLite’ project is released with a Contributor Code of Conduct. By contributing to this project, you agree to abide by its terms.

Copy Link

Version

Install

install.packages('RSQLite')

Monthly Downloads

118,470

Version

2.3.7

License

LGPL (>= 2.1)

Issues

Pull Requests

Stars

Forks

Last Published

May 27th, 2024

Functions in RSQLite (2.3.7)

SQLKeywords_SQLiteConnection

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

Return an entire column from a SQLite database
sqliteSetBusyHandler

Configure what SQLite should do when the database is locked
dbBeginTransaction

Generic for creating a new transaction
SQLite

Connect to an SQLite database
dbReadTable_SQLiteConnection_character

Read a database table
datasetsDb

A sample sqlite database
dbWriteTable_SQLiteConnection_character_character

Write a local data frame or file to the database
sqliteCopyDatabase

Copy a SQLite database
initExtension

Add useful extension functions
fetch_SQLiteResult

Fetch
initRegExp

Add regular expression operator
sqliteBuildTableDefinition

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

Class SQLiteConnection (and methods)
dbGetPreparedQuery

Deprecated querying tools
isIdCurrent

isIdCurrent
dbListResults_SQLiteConnection

dbListResults
SQLiteDriver-class

Class SQLiteDriver (and methods)
reexports

Objects exported from other packages
SQLiteResult-class

Class SQLiteResult (and methods)
rsqliteVersion

RSQLite version
dbBegin_SQLiteConnection

SQLite transaction management