Other packages > Find by keyword >

RSQLite  

SQLite Interface for R
View on CRAN: Click here


Download and install RSQLite package within the R console
Install from CRAN:
install.packages("RSQLite")

Install from Github:
library("remotes")
install_github("cran/RSQLite")

Install by package version:
library("remotes")
install_version("RSQLite", "2.4.5")



Attach the package and use:
library("RSQLite")
Maintained by
Kirill Müller
[Scholar Profile | Author Map]
All associated links for this package
First Published: 2001-11-03
Latest Update: 2025-07-18
Description:
Embeds the SQLite database engine in R and provides an interface compliant with the DBI package. The source for the SQLite engine and for various extensions in a recent version is included. System libraries will never be consulted because this package relies on static linking for the plugins it includes; this also ensures a consistent experience across all installations.
How to cite:
Kirill Müller (2001). RSQLite: SQLite Interface for R. R package version 2.4.5, https://cran.r-project.org/web/packages/RSQLite. Accessed 15 Jul. 2026.
Previous versions and publish date:
(2026-07-09 08:20), 0.2-1 (2001-11-03 20:53), 0.3-0 (2002-10-01 20:19), 0.3-1 (2003-04-07 16:20), 0.3-2 (2003-06-18 22:50), 0.3-3 (2003-11-12 11:27), 0.3-4 (2004-06-22 20:13), 0.3-5 (2005-01-31 16:50), 0.4-0 (2005-04-07 17:30), 0.4-1 (2006-01-19 19:22), 0.4-4 (2006-10-07 21:25), 0.4-9 (2006-10-27 17:13), 0.4-13 (2006-11-09 11:12), 0.4-15 (2006-12-04 22:00), 0.4-18 (2007-01-05 14:21), 0.4-19 (2007-01-18 11:16), 0.4-20 (2007-02-28 15:32), 0.5-1 (2007-03-21 10:11), 0.5-2 (2007-03-28 09:45), 0.5-3 (2007-03-29 10:34), 0.5-4 (2007-05-01 21:03), 0.5-6 (2007-07-18 21:42), 0.6-0 (2007-06-10 21:48), 0.6-2 (2007-07-18 21:41), 0.6-3 (2007-10-03 12:11), 0.6-4 (2007-10-30 19:52), 0.6-7 (2008-01-27 11:49), 0.6-8 (2008-02-27 08:51), 0.6-9 (2008-06-11 11:15), 0.7-0 (2008-08-24 21:30), 0.7-1 (2008-10-26 19:29), 0.7-2 (2009-08-14 22:24), 0.7-3 (2009-10-04 17:43), 0.8-0 (2009-12-22 08:54), 0.8-1 (2010-01-07 16:41), 0.8-2 (2010-01-22 08:47), 0.8-3 (2010-02-11 09:45), 0.8-4 (2010-03-10 17:04), 0.9-0 (2010-05-07 18:39), 0.9-1 (2010-05-29 10:01), 0.9-2 (2010-07-24 21:42), 0.9-3 (2010-11-07 09:22), 0.9-4 (2010-11-24 08:49), 0.10.0 (2011-10-02 09:31), 0.11.0 (2011-12-01 09:00), 0.11.1 (2011-12-07 11:13), 0.11.2 (2012-09-16 07:57), 0.11.3 (2013-04-16 07:43), 0.11.4 (2013-05-26 08:32), 1.0.0 (2014-10-25 01:58), 1.1-1 (2016-12-10 23:13), 1.1-2 (2017-01-08 16:57), 1.1 (2016-11-27 16:31), 2.0 (2017-06-19 13:51), 2.1.0 (2018-03-29 23:58), 2.1.1 (2018-05-06 19:55), 2.1.2 (2019-07-24 12:20), 2.1.3 (2019-12-03 13:22), 2.1.4 (2019-12-04 23:30), 2.1.5 (2019-12-18 16:30), 2.2.0 (2020-01-07 15:30), 2.2.1 (2020-09-30 09:20), 2.2.2 (2021-01-08 17:20), 2.2.3 (2021-01-24 08:30), 2.2.4 (2021-03-12 10:20), 2.2.5 (2021-03-27 09:40), 2.2.6 (2021-04-11 19:00), 2.2.7 (2021-04-22 17:30), 2.2.8 (2021-08-21 18:30), 2.2.9 (2021-12-06 08:00), 2.2.10 (2022-02-17 01:50), 2.2.11 (2022-03-23 08:50), 2.2.12 (2022-04-02 22:20), 2.2.13 (2022-04-29 10:10), 2.2.14 (2022-05-07 14:20), 2.2.15 (2022-07-17 22:50), 2.2.16 (2022-08-17 09:00), 2.2.17 (2022-09-10 09:22), 2.2.18 (2022-10-04 10:10), 2.2.19 (2022-11-24 09:30), 2.2.20 (2022-12-22 10:30), 2.3.0 (2023-02-17 09:30), 2.3.1 (2023-04-03 13:40), 2.3.2 (2023-10-28 23:00), 2.3.3 (2023-11-04 19:20), 2.3.4 (2023-12-08 01:10), 2.3.5 (2024-01-21 17:52), 2.3.6 (2024-04-01 00:20), 2.3.7 (2024-05-27 12:10), 2.3.8 (2024-11-17 19:10), 2.3.9 (2024-12-03 20:30), 2.3.10 (2025-05-02 11:40), 2.3.11 (2025-05-04 11:40), 2.4.0 (2025-05-31 23:10), 2.4.1 (2025-06-08 11:10), 2.4.2 (2025-07-19 00:30), 2.4.3 (2025-08-20 10:10), 2.4.4 (2025-11-10 09:50), 2.4.5 (2025-11-30 08:10), 2.4.6 (2026-02-06 11:50), 3.52.0 (2026-05-10 07:10), 3.53.1 (2026-05-23 07:11), 3.53.2 (2026-06-17 11:10)
Other packages that cited RSQLite R package
View RSQLite citation profile
Other R packages that RSQLite depends, imports, suggests or enhances
Complete documentation for RSQLite
Functions, R codes and Examples using the RSQLite R package
Some associated functions: SQLite . SQLiteConnection-class . SQLiteDriver-class . SQLiteResult-class . datasetsDb . dbBeginTransaction . dbListResults . dbReadTable . dbWriteTable . fetch . initExtension . initRegExp . isIdCurrent . keywords-dep . query-dep . reexports . rsqliteVersion . sqlite-transaction . sqliteBuildTableDefinition . sqliteCopyDatabase . sqliteQuickColumn . sqliteSetBusyHandler . 
Some associated R codes: RcppExports.R . SQLKeywords_SQLiteConnection.R . SQLite.R . SQLiteConnection.R . SQLiteDriver.R . SQLiteResult.R . coerce.R . compatRowNames.R . copy.R . datasetsDb.R . dbAppendTable_SQLiteConnection.R . dbBeginTransaction.R . dbBegin_SQLiteConnection.R . dbBind_SQLiteResult.R . dbClearResult_SQLiteResult.R . dbColumnInfo_SQLiteResult.R . dbCommit_SQLiteConnection.R . dbConnect_SQLiteConnection.R . dbConnect_SQLiteDriver.R . dbDataType_SQLiteConnection.R . dbDataType_SQLiteDriver.R . dbDisconnect_SQLiteConnection.R . dbExistsTable_SQLiteConnection_character.R . dbFetch_SQLiteResult.R . dbGetException_SQLiteConnection.R . dbGetInfo_SQLiteConnection.R . dbGetInfo_SQLiteDriver.R . dbGetPreparedQuery.R . dbGetPreparedQuery_SQLiteConnection_character_data.frame.R . dbGetRowCount_SQLiteResult.R . dbGetRowsAffected_SQLiteResult.R . dbGetStatement_SQLiteResult.R . dbHasCompleted_SQLiteResult.R . dbIsValid_SQLiteConnection.R . dbIsValid_SQLiteDriver.R . dbIsValid_SQLiteResult.R . dbListResults_SQLiteConnection.R . dbListTables_SQLiteConnection.R . dbQuoteIdentifier_SQLiteConnection_SQL.R . dbQuoteIdentifier_SQLiteConnection_character.R . dbReadTable_SQLiteConnection_character.R . dbRemoveTable_SQLiteConnection_character.R . dbRollback_SQLiteConnection.R . dbSendPreparedQuery.R . dbSendPreparedQuery_SQLiteConnection_character_data.frame.R . dbSendQuery_SQLiteConnection_character.R . dbUnloadDriver_SQLiteDriver.R . dbUnquoteIdentifier_SQLiteConnection_SQL.R . dbWriteTable_SQLiteConnection_character_character.R . dbWriteTable_SQLiteConnection_character_data.frame.R . db_bind.R . deprecated.R . export.R . fetch_SQLiteResult.R . initExtension.R . initRegExp.R . isSQLKeyword_SQLiteConnection_character.R . make.db.names_SQLiteConnection_character.R . names.R . pkgconfig.R . show_SQLiteConnection.R . sqlData_SQLiteConnection.R . table.R . transactions.R . utils.R . zzz.R .  Full RSQLite package functions and examples
Downloads during the last 30 days

Today's Hot Picks in Authors and Packages

r2resize  
In-Text Resize for Images, Tables and Fancy Resize Containers in 'shiny', 'rmarkdown' and 'quarto' Documents
Automatic resizing toolbar for containers, images and tables. Various resizable or expandable contai ...
Download / Learn more Package Citations See dependency  
PermAlgo  
Permutational Algorithm to Simulate Survival Data
This version of the permutational algorithm generates a dataset in which event and censoring times ...
Download / Learn more Package Citations See dependency  
binhf  
Haar-Fisz Functions for Binomial Data
Binomial Haar-Fisz transforms for Gaussianization as in Nunes and Nason (2009). ...
Download / Learn more Package Citations See dependency  
gscaLCA  
Generalized Structure Component Analysis- Latent Class Analysis & Latent Class Regression
Execute Latent Class Analysis (LCA) and Latent Class Regression (LCR) by using Generalized Structu ...
Download / Learn more Package Citations See dependency  
footBayes  
Fitting Bayesian and MLE Football Models
This is the first package allowing for the estimation, visualization and prediction of the most wel ...
Download / Learn more Package Citations See dependency  
SECFISH  
Disaggregate Variable Costs
These functions were developed within SECFISH project (Strengthening regional cooperation in the are ...
Download / Learn more Package Citations See dependency  

27,806

R Packages

239,283

Dependencies

73,837

Author Associations

27,807

Publication Badges

© Copyright since 2022. All right reserved, rpkg.net.  Based in Cambridge, Massachusetts, USA