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



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: 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.6, https://cran.r-project.org/web/packages/RSQLite
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)
Other packages that cited RSQLite R package
View RSQLite citation profile
Other R packages that RSQLite depends, imports, suggests or enhances
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
Get rewarded with contribution points by helping add
Reviews / comments / questions /suggestions ↴↴↴

Today's Hot Picks in Authors and Packages

scrobbler  
Download 'Scrobbles' from 'Last.fm'
'Last.fm'<https://www.last.fm> is a music plat ...
Download / Learn more Package Citations See dependency  
BayesGPfit  
Fast Bayesian Gaussian Process Regression Fitting
Bayesian inferences on nonparametric regression via Gaussian Processes with a modified exponential s ...
Download / Learn more Package Citations See dependency  
HLSM  
Hierarchical Latent Space Network Model
Implements Hierarchical Latent Space Network Model (HLSM) for ensemble of networks as described in S ...
Download / Learn more Package Citations See dependency  
sejmRP  
An Information About Deputies and Votings in Polish Diet from Seventh to Eighth Term of Office
Set of functions that access information about deputies and votings in Polish diet from webpage < ...
Download / Learn more Package Citations See dependency  
DIconvex  
Finding Patterns of Monotonicity and Convexity in Data
Givenan initial set of points, this package minimizes the number of elements to discard from this se ...
Download / Learn more Package Citations See dependency  
qrmdata  
Data Sets for Quantitative Risk Management Practice
Various data sets (stocks, stock indices, constituent data, FX, zero-coupon bond yield curves, vola ...
Download / Learn more Package Citations See dependency  

21,994

R Packages

186,816

Dependencies

55,244

Author Associations

21,995

Publication Badges

© Copyright 2022 - present. All right reserved, rpkg.net. Contact Us / Suggestions / Concerns