Learn R Programming

⚠️There's a newer version (2.3.9) 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:

To install from GitHub, you’ll need a development environment.

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

132,817

Version

2.2.3

License

LGPL (>= 2.1)

Issues

Pull Requests

Stars

Forks

Maintainer

Kirill Müller

Last Published

January 24th, 2021

Functions in RSQLite (2.2.3)

dbSendPreparedQuery

Deprecated querying tools
reexports

Objects exported from other packages
sqliteBuildTableDefinition

Build the SQL CREATE TABLE definition as a string
isIdCurrent

isIdCurrent
initExtension

Add useful extension functions
sqliteCopyDatabase

Copy a SQLite database
make.db.names,SQLiteConnection,character-method

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

Add regular expression operator
rsqliteVersion

RSQLite version
sqlite-transaction

SQLite transaction management
sqliteQuickColumn

Return an entire column from a SQLite database
dbBeginTransaction

Generic for creating a new transaction
SQLiteDriver-class

Class SQLiteDriver (and methods)
dbWriteTable,SQLiteConnection,character,data.frame-method

Write a local data frame or file to the database
dbReadTable,SQLiteConnection,character-method

Read a database table
datasetsDb

A sample sqlite database
SQLite

Connect to an SQLite database
fetch,SQLiteResult-method

Fetch
dbListResults,SQLiteConnection-method

dbListResults
SQLiteResult-class

Class SQLiteResult (and methods)
SQLiteConnection-class

Class SQLiteConnection (and methods)