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 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. Optionally, when
libcurl is available at build time, an experimental HTTP/HTTPS
virtual file system (VFS) can be enabled to allow read-only access
to remote immutable SQLite database files via URIs.
| Version: |
3.53.2 |
| Depends: |
R (≥ 3.1.0) |
| Imports: |
bit64, blob (≥ 1.2.0), DBI (≥ 1.2.0), memoise, methods, pkgconfig, rlang |
| LinkingTo: |
cpp11 (≥ 0.4.0) |
| Suggests: |
callr, cli, DBItest (≥ 1.8.0), decor, gert, gh, hms, httpuv, knitr, magrittr, rmarkdown, rvest, testthat (≥ 3.0.0), withr, xml2 |
| Published: |
2026-06-17 |
| DOI: |
10.32614/CRAN.package.RSQLite |
| Author: |
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] |
| Maintainer: |
Kirill Müller <kirill at cynkra.com> |
| BugReports: |
https://github.com/r-dbi/RSQLite/issues |
| License: |
LGPL-2.1 | LGPL-3 [expanded from: LGPL (≥ 2.1)] |
| URL: |
https://rsqlite.r-dbi.org, https://github.com/r-dbi/RSQLite |
| NeedsCompilation: |
yes |
| Materials: |
README, NEWS |
| In views: |
Databases |
| CRAN checks: |
RSQLite results |
| Reverse depends: |
AssessORFData, bioassayR, CITAN, D4TAlink.light, 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, pd.drosgenome1, pd.drosophila.2, pd.e.coli.2, pd.ecoli, pd.ecoli.asv2, pd.elegene.1.0.st, pd.elegene.1.1.st, pd.equgene.1.0.st, pd.equgene.1.1.st, pd.feinberg.hg18.me.hx1, pd.feinberg.mm8.me.hx1, pd.felgene.1.0.st, pd.felgene.1.1.st, pd.fingene.1.0.st, pd.fingene.1.1.st, pd.genomewidesnp.5, pd.genomewidesnp.6, pd.guigene.1.0.st, pd.guigene.1.1.st, pd.hc.g110, pd.hg.focus, pd.hg.u133.plus.2, pd.hg.u133a, pd.hg.u133a.2, pd.hg.u133a.tag, pd.hg.u133b, pd.hg.u219, pd.hg.u95a, pd.hg.u95av2, pd.hg.u95b, pd.hg.u95c, pd.hg.u95d, pd.hg.u95e, pd.hg18.60mer.expr, pd.ht.hg.u133.plus.pm, pd.ht.hg.u133a, pd.ht.mg.430a, pd.hta.2.0, pd.hu6800, pd.huex.1.0.st.v2, pd.hugene.1.0.st.v1, pd.hugene.1.1.st.v1, pd.hugene.2.0.st, pd.hugene.2.1.st, pd.maize, pd.mapping250k.nsp, pd.mapping250k.sty, pd.mapping50k.hind240, pd.mapping50k.xba240, pd.margene.1.0.st, pd.margene.1.1.st, pd.medgene.1.0.st, pd.medgene.1.1.st, pd.medicago, pd.mg.u74a, pd.mg.u74av2, pd.mg.u74b, pd.mg.u74bv2, pd.mg.u74c, pd.mg.u74cv2, pd.mirna.1.0, pd.mirna.2.0, pd.mirna.3.0, pd.mirna.3.1, pd.mirna.4.0, pd.moe430a, pd.moe430b, pd.moex.1.0.st.v1, pd.mogene.1.0.st.v1, pd.mogene.1.1.st.v1, pd.mogene.2.0.st, pd.mogene.2.1.st, pd.mouse430.2, pd.mouse430a.2, pd.mta.1.0, pd.mu11ksuba, pd.mu11ksubb, pd.nugo.hs1a520180, pd.nugo.mm1a520177, pd.ovigene.1.0.st, pd.ovigene.1.1.st, pd.pae.g1a, pd.plasmodium.anopheles, pd.poplar, pd.porcine, pd.porgene.1.0.st, pd.porgene.1.1.st, pd.rabgene.1.0.st, pd.rabgene.1.1.st, pd.rae230a, pd.rae230b, pd.raex.1.0.st.v1, pd.ragene.1.0.st.v1, pd.ragene.1.1.st.v1, pd.ragene.2.0.st, pd.ragene.2.1.st, pd.rat230.2, pd.rcngene.1.0.st, pd.rcngene.1.1.st, pd.rg.u34a, pd.rg.u34b, pd.rg.u34c, pd.rhegene.1.0.st, pd.rhegene.1.1.st, pd.rhesus, pd.rice, pd.rjpgene.1.0.st, pd.rjpgene.1.1.st, pd.rn.u34, pd.rta.1.0, pd.rusgene.1.0.st, pd.rusgene.1.1.st, pd.s.aureus, pd.soybean, pd.soygene.1.0.st, pd.soygene.1.1.st, pd.sugar.cane, pd.tomato, pd.u133.x3p, pd.vitis.vinifera, pd.wheat, pd.x.laevis.2, pd.x.tropicalis, pd.xenopus.laevis, pd.yeast.2, pd.yg.s98, pd.zebgene.1.0.st, pd.zebgene.1.1.st, pd.zebrafish, pdInfoBuilder, PolyPhen.Hsapiens.dbSNP131, RecordLinkage, RSQLite.toolkit, SIFT.Hsapiens.dbSNP132, SIFT.Hsapiens.dbSNP137, snplist, specL, sqldf, SRAdb |
| Reverse imports: |
acc, acdcquery, actigraph.sleepr, activAnalyzer, AdhereRViz, affycoretools, agcounts, ankiR, AnnotationDbi, AnnotationForge, AnnotationHub, AnnotationHubData, apsimx, archivist, BatchExperiments, BatchJobs, bdlp, BgeeCall, BgeeDB, bidux, BiocFileCache, biodb, blsBandit, BoSSA, cansim, celldex, CENTREannotation, CENTREprecomputed, ChemmineDrugs, chevreulProcess, chevreulShiny, ciecl, clstutils, CNEr, CompoundDb, cranlike, customCMPdb, customProDB, D3GB, datrProfile, dexter, dqcheckr, drugTargetInteractions, earthUI, eatDB, elcf4R, emuR, ensembldb, epiSeeker, EpiTxDb, eplusr, Eunomia, expDB, FeatureExtraction, FIESTA, FIESTAutils, filehashSQLite, firmmatchr, framework, gcbd, geeLite, geomultistar, GladiaTOX, globaltrends, GRAB, GWASinspector, GWASTools, htsr, hybridEHR, hydrodownloadR, InPAS, ipdDb, kidsides, landsepi, lcmsPlot, liteq, LLMAgentR, LRBaseDbi, lumi, marmap, MatchingPursuit, MeSHDbi, meshr, metaseqR2, MethReg, metrica, miRBaseVersions.db, miRNAtap, miRNAtap.db, monaLisa, moodleR, mpathsenser, msPurity, NCA, NetSimR, neuroimaGene, nlpembeds, NoRCE, nordstatExtras, oligo, oligoClasses, omicsViewer, OmnipathR, openappr, PAGE, PAMmisc, PAMpal, parquetize, pathdb, pestr, piecemeal, prrd, pubchem.bio, QBMS, qst, qtl2, rangeMapper, rapsimng, rb3, RCAS, rcprd, readepi, recoup, regutools, ReviewR, RImmPort, rsyncrosim, rTRM, scopr, scRNAseq, scRNAseqApp, scTensor, SEERaBomb, sehrnett, sendigR, SGP, shiny.telemetry, shinymanager, shinymgr, shinyNotes, signatureSearch, simplegraphdb, sitadela, snowquery, soundClass, SpliceWiz, sqliter, sqliteutils, SSN2, SSNbler, synaptome.db, SynExtend, systemPipeShiny, tabs, taxizedb, taxonomizr, TFBSTools, tidyhydat, tidywikidatar, tigre, tigreBrowserWriter, toxSummary, trackeR, txdbmaker, VectrixDB, zipcodeR |
| Reverse suggests: |
aisdk, AnnotationFilter, arkdb, AssessORF, autonomics, baseballr, biglm, biglmm, bigreadr, bigsnpr, camtrapR, caroline, cdata, CDMConnector, cfbfastR, ChemmineR, chunked, CohortMethod, CommonDataModel, connections, connector, convey, cookiemonster, corrr, COVID19, CRISPRball, ctrdata, cytominer, DatabaseConnector, datadiff, dataverifyr, dbglm, DBI, dbi.table, DBItest, dbplot, dbplyr, dbx, DECIPHER, diseasystore, dittodb, dlookr, dm, dplyr, easydb, editbl, eiR, emburden, etl, ETLUtils, FakeDataR, fastRhockey, featdelta, filematrix, finbif, geoflow, geogenr, GitStats, glue, gooseR, gpkg, GRaNIE, GWSDAT, gypsum, healthdb, hoopR, InterpretMSSpectrum, iNZightPlots, iNZightTools, ipumsr, janitor, JASPAR2024, learnr, LexisNexisTools, lgrExtra, macleish, maGUI, MetMashR, mfdb, mgsa, mlr3db, modeldb, MsBackendMassbank, MsBackendSql, MsExperiment, mstherm, nflfastR, nodbi, oai, oce, octopus, odbc, oddsapiR, OhdsiReportGenerator, orbital, orderly, palimpsestr, PatientLevelPrediction, pdfminer, PhysicalActivity, pmparser, pointblank, pool, PortfolioTesteR, posDemux, ProjectTemplate, prqlr, qryflow, quantmod, querychat, R6P, radiant.data, RaMS, rcdf, rdataretriever, reactome.db, redquack, repana, reproducible, ResultModelManager, rocker, rolap, rqdatatable, rquery, RSQL, SCDB, scrime, sf, shinyauthr, shinyChatR, shinylogs, soilDB, soilKey, SpaDES.core, sqlhelper, sqlq, sqltargets, srcr, srvyr, stenographer, stepmetrics, stevemisc, storr, stream, survey, svrep, taxadb, tidier, tidylearn, tidypredict, tidyquery, ursa, vtreat, wehoop, when, winch, withr, writer |
| Reverse enhances: |
login, MetaboAnnotation |