Learn R Programming

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

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

136,204

Version

2.2.20

License

LGPL (>= 2.1)

Issues

Pull Requests

Stars

Forks

Last Published

December 22nd, 2022

Functions in RSQLite (2.2.20)

initRegExp

Add regular expression operator
initExtension

Add useful extension functions
rsqliteVersion

RSQLite version
dbGetPreparedQuery

Deprecated querying tools
reexports

Objects exported from other packages
sqliteSetBusyHandler

Configure what SQLite should do when the database is locked
dbBegin_SQLiteConnection

SQLite transaction management
SQLKeywords_SQLiteConnection

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

isIdCurrent
sqliteCopyDatabase

Copy a SQLite database
sqliteBuildTableDefinition

Build the SQL CREATE TABLE definition as a string
sqliteQuickColumn

Return an entire column from a SQLite database
SQLiteDriver-class

Class SQLiteDriver (and methods)
dbReadTable_SQLiteConnection_character

Read a database table
datasetsDb

A sample sqlite database
SQLite

Connect to an SQLite database
dbWriteTable_SQLiteConnection_character_character

Write a local data frame or file to the database
SQLiteResult-class

Class SQLiteResult (and methods)
dbBeginTransaction

Generic for creating a new transaction
dbListResults_SQLiteConnection

dbListResults
fetch_SQLiteResult

Fetch
SQLiteConnection-class

Class SQLiteConnection (and methods)