CRAN/E | RSQLite

RSQLite

SQLite Interface for R

Installation

About

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.

rsqlite.r-dbi.org
github.com/r-dbi/RSQLite
Bug report File report

Key Metrics

Version 2.3.6
R ≥ 3.1.0
Published 2024-03-31 25 days ago
Needs compilation? yes
License LGPL-2.1
License LGPL-3
CRAN checks RSQLite results

Downloads

Yesterday 5.979 -1%
Last 7 days 34.848 -18%
Last 30 days 165.647 +15%
Last 90 days 451.637 -6%
Last 365 days 1.633.299 -17%

Maintainer

Maintainer

Kirill Müller

kirill@cynkra.com

Authors

Kirill Müller

aut / cre

Hadley Wickham

aut

David A. James

aut

Seth Falcon

aut

D. Richard Hipp

ctb

(for the included SQLite sources)

Dan Kennedy

ctb

(for the included SQLite sources)

Joe Mistachkin

ctb

(for the included SQLite sources)

SQLite Authors

ctb

(for the included SQLite sources)

Liam Healy

ctb

(for the included SQLite sources)

R Consortium

fnd

RStudio

cph

Material

README
NEWS
Reference manual
Package source

In Views

Databases

Vignettes

RSQLite

macOS

r-release

arm64

r-oldrel

arm64

r-release

x86_64

Windows

r-devel

x86_64

r-release

x86_64

r-oldrel

x86_64

Old Sources

RSQLite archive

Depends

R ≥ 3.1.0

Imports

bit64
blob ≥ 1.2.0
DBI ≥ 1.2.0
memoise
methods
pkgconfig
rlang

Suggests

callr
DBItest ≥ 1.8.0
gert
gh
hms
knitr
magrittr
rmarkdown
rvest
testthat ≥ 3.0.0
withr
xml2

LinkingTo

plogr ≥ 0.2.0
cpp11 ≥ 0.4.0

Reverse Depends

bioassayR
CITAN
cummeRbund
DECIPHER
ECOTOXr
gde
GEOmetadb
grasp2db
PANTHER.db
pd.081229.hg18.promoter.medip.hx1
pd.2006.07.18.hg18.refseq.promoter
pd.2006.07.18.mm8.refseq.promoter
pd.2006.10.31.rn34.refseq.promoter
pd.ag
pd.aragene.1.0.st
pd.aragene.1.1.st
pd.atdschip.tiling
pd.ath1.121501
pd.barley1
pd.bovgene.1.0.st
pd.bovgene.1.1.st
pd.bovine
pd.bsubtilis
pd.cangene.1.0.st
pd.cangene.1.1.st
pd.canine
pd.canine.2
pd.celegans
pd.charm.hg18.example
pd.chicken
pd.chigene.1.0.st
pd.chigene.1.1.st
pd.chogene.2.0.st
pd.chogene.2.1.st
pd.citrus
pd.clariom.d.human
pd.clariom.s.human
pd.clariom.s.human.ht
pd.clariom.s.mouse
pd.clariom.s.mouse.ht
pd.clariom.s.rat
pd.clariom.s.rat.ht
pd.cotton
pd.cyngene.1.0.st
pd.cyngene.1.1.st
pd.cyrgene.1.0.st
pd.cyrgene.1.1.st
pd.cytogenetics.array
pd.drogene.1.0.st
pd.drogene.1.1.st
Load all 189 items
(warning: might lead to performance issues and take some time)

Reverse Imports

acc
acdcquery
activAnalyzer
AdhereRViz
affycoretools
agcounts
Andromeda
AnnotationDbi
AnnotationForge
AnnotationHub
AnnotationHubData
apsimx
archivist
BatchExperiments
BatchJobs
bdlp
BgeeDB
BiocFileCache
biodb
blsBandit
BoSSA
cansim
ChemmineDrugs
clstutils
CNEr
CompoundDb
cranlike
crossmeta
customCMPdb
customProDB
datrProfile
dbflobr
dexter
dexterMST
DIAlignR
drugTargetInteractions
eatDB
emuR
ensembldb
EpiTxDb
eplusr
expDB
FIESTA
FIESTAutils
filehashSQLite
gcbd
GenomicFeatures
geomultistar
GladiaTOX
globaltrends
Load all 134 items
(warning: might lead to performance issues and take some time)

Reverse Suggests

AnnotationFilter
arkdb
baseballr
bigchess
biglm
biglmm
bigreadr
bigsnpr
camtrapR
caroline
cdata
CDMConnector
cfbfastR
ChemmineR
chunked
CommonDataModel
condusco
connections
convey
corrr
COVID19
ctrdata
cytominer
DatabaseConnector
dataverifyr
dbglm
DBI
DBItest
dbplyr
dbx
diseasystore
disprose
dittodb
dlookr
dm
dplyr
easydb
editbl
eiR
etl
ETLUtils
fastRhockey
filematrix
finbif
geogenr
glue
gpkg
GWSDAT
hoopR
InterpretMSSpectrum
Load all 125 items
(warning: might lead to performance issues and take some time)

Reverse Enhances

MetaboAnnotation