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]
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.9, https://cran.r-project.org/web/packages/RSQLite. Accessed 31 Jan. 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
Get rewarded with contribution points by helping add
Reviews / comments / questions /suggestions ↴↴↴

Today's Hot Picks in Authors and Packages

nlpred  
Estimators of Non-Linear Cross-Validated Risks Optimized for Small Samples
Methods for obtaining improved estimates of non-linear cross-validated risks are obtained using targ ...
Download / Learn more Package Citations See dependency  
pim  
Fit Probabilistic Index Models
Fit a probabilistic index model as described in Thas et al, 2012: ...
Download / Learn more Package Citations See dependency  
nextGenShinyApps  
Craft Exceptional 'R Shiny' Applications and Dashboards with Novel Responsive Tools
Nove responsive tools for designing and developing 'Shiny' dashboards and applications. The scripts ...
Download / Learn more Package Citations See dependency  
GEEmediate  
Mediation Analysis for Generalized Linear Models Using the Difference Method
Causal mediation analysis for a single exposure/treatment and a single mediator, both allowed to be ...
Download / Learn more Package Citations See dependency  

23,580

R Packages

204,057

Dependencies

63,980

Author Associations

23,581

Publication Badges

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