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 [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 |
| Reverse depends: | biglm,biglmm,bioassayR,ckanr,combi,D4TAlink.light,dbWebForms,dittodb,duckdb,eiR,gmDatabase,implyr,odbc.resourcer,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,RecordLinkage,repana,RJDBC,RMySQL,ROracle,rpostgis,RPostgreSQL,RRedshiftSQL,specL,stacomirtools,TKCat |
| Reverse imports: | acc,acdcquery,ActiSleep,adbi,AdhereRViz,affycoretools,africamonitor,agcounts,allofus,AlphaMissenseR,Andromeda,annaffy,annmap,annotate,AnnotationDbi,AnnotationForge,AnnotationHubData,AnVILBilling,apsimx,archivist,arkdb,AzureKusto,basedosdados,BatchExperiments,BatchJobs,bcdata,bdlp,BETS,bidux,BIEN,bigrquery,BiocFileCache,biolink,birdscanR,blsBandit,brclimr,brickster,cansim,Category,CDMConnector,celldex,censo2017,CENTREannotation,CENTREprecomputed,ChemmineR,chevreulProcess,chevreulShiny,childesr,ChIPpeakAnno,chunked,CITAN,ClickHouseHTTP,clintrialx,cn.farms,CNEr,CodelistGenerator,CohortSurvival,CommonDataModel,CompoundDb,connections,connector,connector.databricks,contoso,covidmx,cranlike,csdb,ctrialsgov,CuratedAtlasQueryR,D3GB,DatabaseConnector,dbglm,dbi.table,DBItest,dbplyr,dbx,DECIPHER,dexter,dextergui,diseasystore,DisImpact,DIZutils,duckdbfs,duckplyr,duckspatial,easydb,eatDB,emuR,ensembldb,epidm,EpiTxDb,etl,Eunomia,expDB,ExperimentHubData,eyeris,farr,FeatureExtraction,FIESTA,FIESTAutils,filehashSQLite,frma,frmaTools,gcbd,GenomicFeatures,genomicper,geocodebr,GladiaTOX,globaltrends,GOSemSim,gpkg,greenR,GWalkR,GWASTools,HDO.db,HPO.db,htsr,IntEREst,iNZightTools,ipanema,ipdDb,IsoformSwitchAnalyzeR,ITALICS,keggorthology,kidsides,landsepi,lazysf,linkSet,liteq,LLMAgentR,login,LRBaseDbi,lucas,lumi,lumiHumanIDMapping,marmap,MCOE,MDMAPR,mdsr,MeasurementDiagnostics,metrica,mfdb,mimager,miRBaseVersions.db,miRNAmeConverter,miRNAtap,miRNAtap.db,mitools,moodleR,motherduck,mpathsenser,MPO.db,MsBackendMassbank,MsBackendSql,MsExperiment,msPurity,MSstatsBig,neonstore,NetSAM,NetSimR,neuroimaGene,noctua,nodbi,NoRCE,occCite,octopus,odbc,oligo,oligoClasses,OmopOnSpark,openappr,OpenRange,openSkies,org.Hbacteriophora.eg.db,Organism.dplyr,OrganismDbi,overtureR,PANACEA,parquetize,pathfindR,pdInfoBuilder,pestr,pgTools,phylosignal,PKbioanalysis,pmparser,pointblank,pool,prrd,pysparklyr,QBMS,qryflow,qst,RAGFlowChainR,ragnar,rangeMapper,rapsimng,RAthena,rb3,rcdf,RClickhouse,readepi,redquack,regutools,restez,ResultModelManager,ReviewR,RGreenplum,RImmPort,RMariaDB,rocker,RODBCDBI,rpgconn,RPostgres,RPresto,RSQL,RSQLite,rsyncrosim,rTRM,samadb,SangerTools,SCDB,scRNAseq,scRNAseqApp,sdstudio,SEERaBomb,sehrnett,sejmRP,sergeant,sf,shinyChatR,shinyHugePlot,shinymanager,shinymgr,shinyNotes,simplegraphdb,snowquery,snplist,soilDB,SomaScan.db,soundClass,spanishoddata,sparkavro,sparklyr,sparkwarc,SQL,sqldf,sqlhelper,sqlHelpers,sqliter,sqliteutils,SQLove,sqlq,sqltargets,srcr,starwarsdb,stenographer,surveydown,svrep,synaptome.db,SynExtend,taskqueue,taxadb,taxizedb,tcpl,TestGenerator,TFBSTools,tidyhydat,tidywikidatar,tigre,tigreBrowserWriter,timeseriesdb,topGO,toxSummary,TrialEmulation,txdbmaker,ugatsdb,VariantAnnotation,vegdata,virtuoso,vismeteor,when,wizaRdry,writer,zipcodeR |
| Reverse suggests: | activAnalyzer,ag.db,aroma.affymetrix,arrow,ath1121501.db,autonomics,AzureCosmosR,baseballr,bdc,biotmle,bovine.db,btw,canine.db,canine2.db,catalog,cdata,celegans.db,censobr,cfbfastR,chicken.db,clariomdhumanprobeset.db,clariomdhumantranscriptcluster.db,clariomshumanhttranscriptcluster.db,clariomshumantranscriptcluster.db,clariomsmousehttranscriptcluster.db,clariomsmousetranscriptcluster.db,clariomsrathttranscriptcluster.db,clariomsrattranscriptcluster.db,CohortCharacteristics,CohortConstructor,CohortSymmetry,convey,cookiemonster,corrr,cytominer,dataverifyr,dlookr,dm,dplyr,drosgenome1.db,drosophila2.db,DrugExposureDiagnostics,DrugUtilisation,ecoli2.db,ECOTOXr,editbl,epivizrData,ETLUtils,fabricQueryR,FakeDataR,fastRhockey,finbif,geoflow,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,omock,OmopSketch,OperonHumanV3.db,orbital,orderly,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,scRNAstat,SHDZ.db,shiny.reglog,shinyauthr,shinylogs,simaerep,sixtyfour,SpliceWiz,srvyr,stevemisc,storr,stream,survey,tidyfinance,tidypredict,tidyprompt,tidyquery,toxpiR,TreatmentPatterns,u133x3p.db,UCSC.utils,valr,vtreat,wehoop,winch,withr,xlaevis.db,yeast2.db,ygs98.db,zebrafish.db |
| Reverse enhances: | caroline |