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.3.9")



Attach the package and use:
library("RSQLite")
Maintained by
Kirill Müller
[Scholar Profile | Author Map]
First Published: 2001-11-03
Latest Update: 2024-01-21
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.3.9, https://cran.r-project.org/web/packages/RSQLite. Accessed 13 Apr. 2025.
Previous versions and publish date:
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)
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
03/1403/1503/1603/1703/1803/1903/2003/2103/2203/2303/2403/2503/2603/2703/2803/2903/3003/3104/0104/0204/0304/0404/0504/0604/0704/0804/0904/1004/11Downloads for RSQLite20002500300035004000450050005500600065007000TrendBars

Today's Hot Picks in Authors and Packages

MLeval  
Machine Learning Model Evaluation
Straightforward and detailed evaluation of machine learning models. 'MLeval' can produce receiver op ...
Download / Learn more Package Citations See dependency  
LDABiplots  
Biplot Graphical Interface for LDA Models
Contains the development of a tool that provides a web-based graphical user interface (GUI) to perf ...
Download / Learn more Package Citations See dependency  
ggprism  
A 'ggplot2' Extension Inspired by 'GraphPad Prism'
Provides various themes, palettes, and other functions that are used to customise ggplots to look l ...
Download / Learn more Package Citations See dependency  
COMPoissonReg  
Conway-Maxwell Poisson (COM-Poisson) Regression
Fit Conway-Maxwell Poisson (COM-Poisson or CMP) regression models to count data (Sellers & Shmueli, ...
Download / Learn more Package Citations See dependency  
SPOTMisc  
Misc Extensions for the "SPOT" Package
Implements additional models, simulation tools, and interfaces as extensions to 'SPOT'. It provides ...
Download / Learn more Package Citations See dependency  
optimParallel  
Parallel Version of the L-BFGS-B Optimization Method
Provides a parallel version of the L-BFGS-B method of optim(). The main function of the package is o ...
Download / Learn more Package Citations See dependency  

24,012

R Packages

207,311

Dependencies

64,867

Author Associations

24,013

Publication Badges

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