DBI: R Database Interface

A database interface definition for communication between R and relational database management systems. All classes in this package are virtual and need to be extended by the various R/DBMS implementations.

Version: 1.2.3
Depends: methods, R (≥ 3.0.0)
Suggests: arrow, blob, covr, DBItest, dbplyr, downlit, dplyr, glue, hms, knitr, magrittr, nanoarrow (≥ 0.3.0.1), RMariaDB, rmarkdown, rprojroot, RSQLite (≥ 1.1-2), testthat (≥ 3.0.0), vctrs, xml2
Published: 2024-06-02
DOI: 10.32614/CRAN.package.DBI
Author: R Special Interest Group on Databases (R-SIG-DB) [aut], Hadley Wickham [aut], Kirill Müller ORCID iD [aut, cre], R Consortium [fnd]
Maintainer: Kirill Müller <kirill at cynkra.com>
BugReports: https://github.com/r-dbi/DBI/issues
License: LGPL-2.1 | LGPL-3 [expanded from: LGPL (≥ 2.1)]
URL: https://dbi.r-dbi.org, https://github.com/r-dbi/DBI
NeedsCompilation: no
Materials: README NEWS
In views: Databases
CRAN checks: DBI results

Documentation:

Reference manual: DBI.pdf
Vignettes: A Common Database Interface (DBI)
Advanced DBI Usage
Using DBI with Arrow
History of DBI
A Common Interface to Relational Databases from R and S – A Proposal
Introduction to DBI
Implementing a new backend
DBI specification

Downloads:

Package source: DBI_1.2.3.tar.gz
Windows binaries: r-devel: DBI_1.2.3.zip, r-release: DBI_1.2.3.zip, r-oldrel: DBI_1.2.3.zip
macOS binaries: r-release (arm64): DBI_1.2.3.tgz, r-oldrel (arm64): DBI_1.2.3.tgz, r-release (x86_64): DBI_1.2.3.tgz, r-oldrel (x86_64): DBI_1.2.3.tgz
Old sources: DBI archive

Reverse dependencies:

Reverse depends: biglm, bioassayR, ckanr, combi, dbWebForms, dittodb, duckdb, eiR, gmDatabase, implyr, ODB, 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, RCM, RecordLinkage, repana, RJDBC, RMySQL, ROracle, rpostgis, RPostgreSQL, RRedshiftSQL, specL, stacomirtools, TKCat
Reverse imports: acc, acdcquery, ActiSleep, adbi, AdhereRViz, affycoretools, afmToolkit, africamonitor, agcounts, allofus, AlphaMissenseR, Andromeda, annaffy, annmap, annotate, AnnotationDbi, AnnotationForge, AnnotationHubData, AnVILBilling, apsimx, archivist, arkdb, AzureKusto, basedosdados, BatchExperiments, BatchJobs, bcdata, bdlp, BETS, BIEN, bigrquery, BiocFileCache, BiocOncoTK, biolink, birdscanR, blsBandit, brclimr, cansim, Category, CDMConnector, celldex, censo2017, censobr, ChemmineR, childesr, ChIPpeakAnno, chunked, CITAN, ClickHouseHTTP, clintrialx, cn.farms, CNEr, CodelistGenerator, CohortSurvival, CommonDataModel, CompoundDb, connections, covidmx, cranlike, crossmeta, ctrialsgov, CuratedAtlasQueryR, customProDB, D3GB, DatabaseConnector, dbflobr, dbglm, DBItest, dbplyr, dbx, DECIPHER, dexter, dextergui, dexterMST, DIAlignR, diseasystore, DisImpact, DIZutils, DMwR2, duckdbfs, duckplyr, easydb, eatDB, emuR, ensembldb, epidm, EpiTxDb, etl, Eunomia, expDB, ExperimentHubData, farr, FeatureExtraction, FIESTA, FIESTAutils, filehashSQLite, frma, frmaTools, gcbd, GenomicFeatures, genomicper, GenVisR, GladiaTOX, globaltrends, GOSemSim, gpkg, GWalkR, GWASTools, HPO.db, htsr, IntEREst, iNZightTools, ipanema, ipdDb, IsoformSwitchAnalyzeR, ITALICS, keggorthology, kidsides, landsepi, lazysf, liteq, login, LRBaseDbi, lucas, lumi, lumiHumanIDMapping, marmap, MCOE, MDMAPR, mdsr, Mega2R, MetaIntegrator, metrica, mfdb, mimager, miRBaseVersions.db, miRNAmeConverter, miRNAtap, miRNAtap.db, mitools, MonetDB.R, moodleR, mpathsenser, MPO.db, MsBackendMassbank, MsBackendSql, MsExperiment, msPurity, MSstatsBig, neonstore, NetSAM, NetSimR, neuroimaGene, noctua, nodbi, NoRCE, occCite, octopus, odbc, oligo, oligoClasses, openSkies, orderly, Organism.dplyr, OrganismDbi, overtureR, PANACEA, parquetize, pathfindR, pdInfoBuilder, pestr, pgTools, phylosignal, Pigengene, PKbioanalysis, pmparser, pointblank, pool, ProfoundData, prrd, pubtatordb, pysparklyr, QBMS, qst, rangeMapper, rapsimng, RAthena, RClickhouse, readwritesqlite, regutools, restez, ResultModelManager, ReviewR, RGreenplum, RImmPort, RMariaDB, rocker, RODBCDBI, RPostgres, RPresto, rSHAPE, RSQL, RSQLite, rsyncrosim, rTRM, samadb, SangerTools, SCDB, scRNAseq, scRNAseqApp, SEERaBomb, sehrnett, sejmRP, sergeant, sf, shinyChatR, shinyHugePlot, shinymanager, shinymgr, shinyNotes, simplegraphdb, snowquery, snplist, soilDB, SomaScan.db, soundClass, sparkavro, sparklyr, sparkwarc, SQL, SQLDataFrame, sqldf, sqlhelper, sqlHelpers, sqliter, sqliteutils, SQLove, sqltargets, srcr, stacomiR, starwarsdb, svrep, synaptome.db, SynExtend, taxadb, tcpl, TestGenerator, TFBSTools, tidyhydat, tidywikidatar, tigre, tigreBrowserWriter, timeseriesdb, topGO, toxSummary, twitteR, txdbmaker, ugatsdb, VariantAnnotation, vegdata, VicmapR, virtuoso, vismeteor, when, zipcodeR
Reverse suggests: activAnalyzer, ag.db, aroma.affymetrix, arrow, ath1121501.db, autonomics, AzureCosmosR, baseballr, bdc, biotmle, bovine.db, canine.db, canine2.db, catalog, cdata, celegans.db, chicken.db, clariomdhumanprobeset.db, clariomdhumantranscriptcluster.db, clariomshumanhttranscriptcluster.db, clariomshumantranscriptcluster.db, clariomsmousehttranscriptcluster.db, clariomsmousetranscriptcluster.db, clariomsrathttranscriptcluster.db, clariomsrattranscriptcluster.db, CohortCharacteristics, CohortConstructor, CohortSymmetry, convey, corrr, cytominer, DataFakeR, dataverifyr, disprose, dlookr, dm, dplyr, drosgenome1.db, drosophila2.db, DrugExposureDiagnostics, DrugUtilisation, ecoli2.db, ECOTOXr, editbl, epivizrData, ETLUtils, fastRhockey, finbif, geogenr, geojsonio, glue, GO.db, GWSDAT, gypsum, hcg110.db, hgfocus.db, hgu133a.db, hgu133a2.db, hgu133b.db, hgu133plus2.db, hgu219.db, hgu95a.db, hgu95av2.db, hgu95b.db, hgu95c.db, hgu95d.db, hgu95e.db, hguatlas13k.db, hgubeta7.db, hguDKFZ31.db, hgug4100a.db, hgug4101a.db, hgug4110b.db, hgug4111a.db, hgug4112a.db, hguqiagenv3.db, hoopR, Hs6UG171.db, HsAgilentDesign026652.db, hta20probeset.db, hta20transcriptcluster.db, hthgu133a.db, hthgu133b.db, hthgu133plusa.db, hthgu133plusb.db, hthgu133pluspm.db, htmg430a.db, htmg430b.db, htmg430pm.db, htrat230pm.db, htratfocus.db, hu35ksuba.db, hu35ksubb.db, hu35ksubc.db, hu35ksubd.db, hu6800.db, huex10stprobeset.db, huex10sttranscriptcluster.db, hugene10stprobeset.db, hugene10sttranscriptcluster.db, hugene11stprobeset.db, hugene11sttranscriptcluster.db, hugene20stprobeset.db, hugene20sttranscriptcluster.db, hugene21stprobeset.db, hugene21sttranscriptcluster.db, HuO22.db, hyd1d, IncidencePrevalence, indac.db, intendo, InterpretMSSpectrum, iNZightPlots, ipumsr, isobar, JazaeriMetaData.db, knitr, LAPOINTE.db, learnr, lgrExtra, mgsa, mgu74a.db, mgu74av2.db, mgu74b.db, mgu74bv2.db, mgu74c.db, mgu74cv2.db, mguatlas5k.db, mgug4104a.db, mgug4120a.db, mgug4121a.db, mgug4122a.db, mlr3db, mlr3oml, MmAgilentDesign026655.db, modeldb, moe430a.db, moe430b.db, moex10stprobeset.db, moex10sttranscriptcluster.db, mogene10stprobeset.db, mogene10sttranscriptcluster.db, mogene11stprobeset.db, mogene11sttranscriptcluster.db, mogene20stprobeset.db, mogene20sttranscriptcluster.db, mogene21stprobeset.db, mogene21sttranscriptcluster.db, mouse4302.db, mouse430a2.db, mpedbarray.db, mta10probeset.db, mta10transcriptcluster.db, mu11ksuba.db, mu11ksubb.db, Mu15v1.db, mu19ksuba.db, mu19ksubb.db, mu19ksubc.db, Mu22v3.db, nanoparquet, nflfastR, nhanesA, nngeo, Norway981.db, oai, oce, oddsapiR, OmopSketch, OperonHumanV3.db, orbital, org.Ag.eg.db, org.At.tair.db, org.Bt.eg.db, org.Ce.eg.db, org.Cf.eg.db, org.Dm.eg.db, org.Dr.eg.db, org.EcK12.eg.db, org.EcSakai.eg.db, org.Gg.eg.db, org.Hs.eg.db, org.Mm.eg.db, org.Mmu.eg.db, org.Mxanthus.db, org.Pf.plasmo.db, org.Pt.eg.db, org.Rn.eg.db, org.Sc.sgd.db, org.Ss.eg.db, org.Xl.eg.db, Orthology.eg.db, PartheenMetaData.db, PatientProfiles, pedbarrayv10.db, pedbarrayv9.db, PFAM.db, PhysicalActivity, pillar, POCRCannotation.db, porcine.db, ProjectTemplate, prqlr, quantmod, R6P, radiant.data, rae230a.db, rae230b.db, raex10stprobeset.db, raex10sttranscriptcluster.db, ragene10stprobeset.db, ragene10sttranscriptcluster.db, ragene11stprobeset.db, ragene11sttranscriptcluster.db, ragene20stprobeset.db, ragene20sttranscriptcluster.db, ragene21stprobeset.db, ragene21sttranscriptcluster.db, RaMS, rat2302.db, rdataretriever, REDCapR, reproducible, resourcer, rgu34a.db, rgu34b.db, rgu34c.db, rguatlas4k.db, rgug4105a.db, rgug4130a.db, rgug4131a.db, RnAgilentDesign028282.db, rnu34.db, Roberts2005Annotation.db, rolap, rqdatatable, rquery, rta10probeset.db, rta10transcriptcluster.db, rtu34.db, scrime, SHDZ.db, shiny.reglog, shinyauthr, shinylogs, simaerep, SpliceWiz, srvyr, stevemisc, storr, stream, survey, tidyfinance, tidypredict, tidyquery, toxpiR, TreatmentPatterns, u133x3p.db, UCSC.utils, valr, vtreat, wehoop, winch, withr, xlaevis.db, yeast2.db, ygs98.db, zebrafish.db
Reverse enhances: caroline

Linking:

Please use the canonical form https://CRAN.R-project.org/package=DBI to link to this page.