The hardware and bandwidth for this mirror is donated by dogado GmbH, the Webhosting and Full Service-Cloud Provider. Check out our Wordpress Tutorial.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]dogado.de.

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, biglmm, 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, 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, ctrialsgov, CuratedAtlasQueryR, customProDB, D3GB, DatabaseConnector, dbflobr, dbglm, dbi.table, DBItest, dbplyr, dbx, DECIPHER, dexter, dextergui, dexterMST, 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, HDO.db, HPO.db, htsr, IntEREst, iNZightTools, ipanema, ipdDb, IsoformSwitchAnalyzeR, ITALICS, keggorthology, kidsides, landsepi, lazysf, liteq, login, LRBaseDbi, lucas, lumi, lumiHumanIDMapping, marmap, MCOE, MDMAPR, mdsr, Mega2R, 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, openappr, 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, spanishoddata, sparkavro, sparklyr, sparkwarc, SQL, SQLDataFrame, sqldf, sqlhelper, sqlHelpers, sqliter, sqliteutils, SQLove, sqltargets, srcr, stacomiR, starwarsdb, surveydown, svrep, synaptome.db, SynExtend, taxadb, tcpl, TestGenerator, TFBSTools, tidyhydat, tidywikidatar, tigre, tigreBrowserWriter, timeseriesdb, topGO, toxSummary, TrialEmulation, 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, 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, PhenotypeR, 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.

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.
Health stats visible at Monitor.