Showing 33 of total 33 results (show query)
r-dbi
RMySQL:Database Interface and 'MySQL' Driver for R
Legacy 'DBI' interface to 'MySQL' / 'MariaDB' based on old code ported from S-PLUS. A modern 'MySQL' client written in 'C++' is available from the 'RMariaDB' package.
Maintained by Jeroen Ooms. Last updated 1 months ago.
49.4 match 209 stars 13.68 score 3.7k scripts 15 dependentsr-dbi
RMariaDB:Database Interface and MariaDB Driver
Implements a DBI-compliant interface to MariaDB (<https://mariadb.org/>) and MySQL (<https://www.mysql.com/>) databases.
Maintained by Kirill Müller. Last updated 19 days ago.
33.9 match 134 stars 12.36 score 792 scripts 11 dependents
bioc
ensembldb:Utilities to create and use Ensembl-based annotation databases
The package provides functions to create and use transcript centric annotation databases/packages. The annotation for the databases are directly fetched from Ensembl using their Perl API. The functionality and data is similar to that of the TxDb packages from the GenomicFeatures package, but, in addition to retrieve all gene/transcript models and annotations from the database, ensembldb provides a filter framework allowing to retrieve annotations for specific entries like genes encoded on a chromosome region or transcript models of lincRNA genes. EnsDb databases built with ensembldb contain also protein annotations and mappings between proteins and their encoding transcripts. Finally, ensembldb provides functions to map between genomic, transcript and protein coordinates.
Maintained by Johannes Rainer. Last updated 5 months ago.
geneticsannotationdatasequencingcoverageannotationbioconductorbioconductor-packagesensembl
8.0 match 35 stars 14.08 score 892 scripts 108 dependents
joshuaulrich
quantmod:Quantitative Financial Modelling Framework
Specify, build, trade, and analyse quantitative financial trading strategies.
Maintained by Joshua M. Ulrich. Last updated 14 days ago.
algorithmic-tradingchartingdata-importfinancetime-series
6.4 match 839 stars 16.17 score 8.1k scripts 343 dependents
tidyverse
dbplyr:A 'dplyr' Back End for Databases
A 'dplyr' back end for databases that allows you to work with remote database tables as if they are in-memory data frames. Basic features works with any database that has a 'DBI' back end; more advanced features require 'SQL' translation to be provided by the package author.
Maintained by Hadley Wickham. Last updated 3 months ago.
3.5 match 481 stars 19.72 score 5.2k scripts 736 dependents
nikolaus77
rocker:Database Interface Class
'R6' class interface for handling relational database connections using 'DBI' package as backend. The class allows handling of connections to e.g. PostgreSQL, MariaDB and SQLite. The purpose is having an intuitive object allowing straightforward handling of SQL databases.
Maintained by Nikolaus Pawlowski. Last updated 3 years ago.
databasedbimariadbmysqlpostgrespostgresqlr6sqlsqlite
11.0 match 5 stars 5.24 score 7 scripts
mlr-org
mlr3db:Data Base Backend for 'mlr3'
Extends the 'mlr3' package with a backend to transparently work with databases such as 'SQLite', 'DuckDB', 'MySQL', 'MariaDB', or 'PostgreSQL'. The package provides two additional backends: 'DataBackendDplyr' relies on the abstraction of package 'dbplyr' to interact with most DBMS. 'DataBackendDuckDB' operates on 'DuckDB' data bases and also on Apache Parquet files.
Maintained by Michel Lang. Last updated 1 years ago.
bigquerydata-backenddatabaseduckdbmachine-learningmariadbmlr3mysqlodbcpostgresqlsparksqlite
11.5 match 21 stars 4.77 score 17 scriptsr-dbi
odbc:Connect to ODBC Compatible Databases (using the DBI Interface)
A DBI-compatible interface to ODBC databases.
Maintained by Hadley Wickham. Last updated 12 days ago.
2.2 match 396 stars 16.22 score 2.9k scripts 22 dependents
appsilon
shiny.telemetry:'Shiny' App Usage Telemetry
Enables instrumentation of 'Shiny' apps for tracking user session events such as input changes, browser type, and session duration. These events can be sent to any of the available storage backends and analyzed using the included 'Shiny' app to gain insights about app usage and adoption.
Maintained by André Veríssimo. Last updated 3 months ago.
3.3 match 67 stars 9.69 score 29 scriptsbioc
RImmPort:RImmPort: Enabling Ready-for-analysis Immunology Research Data
The RImmPort package simplifies access to ImmPort data for analysis in the R environment. It provides a standards-based interface to the ImmPort study data that is in a proprietary format.
Maintained by Zicheng Hu. Last updated 5 months ago.
biomedicalinformaticsdataimportdatarepresentation
7.1 match 4.33 score 27 scriptsbioc
MsBackendMassbank:Mass Spectrometry Data Backend for MassBank record Files
Mass spectrometry (MS) data backend supporting import and export of MS/MS library spectra from MassBank record files. Different backends are available that allow handling of data in plain MassBank text file format or allow also to interact directly with MassBank SQL databases. Objects from this package are supposed to be used with the Spectra Bioconductor package. This package thus adds MassBank support to the Spectra package.
Maintained by RforMassSpectrometry Package Maintainer. Last updated 18 days ago.
infrastructuremassspectrometrymetabolomicsdataimportmassbankspectra
3.0 match 3 stars 5.91 score 27 scripts
patzaw
ReDaMoR:Relational Data Modeler
The aim of this package is to manipulate relational data models in R. It provides functions to create, modify and export data models in json format. It also allows importing models created with 'MySQL Workbench' (<https://www.mysql.com/products/workbench/>). These functions are accessible through a graphical user interface made with 'shiny'. Constraints such as types, keys, uniqueness and mandatory fields are automatically checked and corrected when editing a model. Finally, real data can be confronted to a model to check their compatibility.
Maintained by Patrice Godard. Last updated 23 days ago.
2.5 match 17 stars 6.24 score 17 scripts 1 dependents
ouhscbbmc
REDCapR:Interaction Between R and REDCap
Encapsulates functions to streamline calls from R to the REDCap API. REDCap (Research Electronic Data CAPture) is a web application for building and managing online surveys and databases developed at Vanderbilt University. The Application Programming Interface (API) offers an avenue to access and modify data programmatically, improving the capacity for literate and reproducible programming.
Maintained by Will Beasley. Last updated 2 months ago.
1.3 match 118 stars 12.36 score 438 scripts 6 dependentsbioc
multiMiR:Integration of multiple microRNA-target databases with their disease and drug associations
A collection of microRNAs/targets from external resources, including validated microRNA-target databases (miRecords, miRTarBase and TarBase), predicted microRNA-target databases (DIANA-microT, ElMMo, MicroCosm, miRanda, miRDB, PicTar, PITA and TargetScan) and microRNA-disease/drug databases (miR2Disease, Pharmaco-miR VerSe and PhenomiR).
Maintained by Spencer Mahaffey. Last updated 5 months ago.
mirnadatahomo_sapiens_datamus_musculus_datarattus_norvegicus_dataorganismdatamicrorna-sequencesql
1.8 match 20 stars 8.45 score 141 scripts
langcog
childesr:Accessing the 'CHILDES' Database
Tools for connecting to 'CHILDES', an open repository for transcripts of parent-child interaction. For more information on the underlying data, see <https://langcog.github.io/childes-db-website/>.
Maintained by Mika Braginsky. Last updated 3 years ago.
2.0 match 14 stars 6.70 score 102 scripts
beanumber
etl:Extract-Transform-Load Framework for Medium Data
A predictable and pipeable framework for performing ETL (extract-transform-load) operations on publicly-accessible medium-sized data set. This package sets up the method structure and implements generic functions. Packages that depend on this package download specific data sets from the Internet, clean them up, and import them into a local or remote relational database management system.
Maintained by Benjamin S. Baumer. Last updated 1 years ago.
1.8 match 129 stars 7.17 score 38 scripts 1 dependents
cran
monitoR:Acoustic Template Detection in R
Acoustic template detection and monitoring database interface. Create, modify, save, and use templates for detection of animal vocalizations. View, verify, and extract results. Upload a MySQL schema to a existing instance, manage survey metadata, write and read templates and detections locally or to the database.
Maintained by Sasha D. Hafner. Last updated 7 years ago.
2.2 match 3 stars 3.95 score 5 dependentsbioc
epivizrData:Data Management API for epiviz interactive visualization app
Serve data from Bioconductor Objects through a WebSocket connection.
Maintained by Hector Corrada Bravo. Last updated 5 months ago.
1.7 match 1 stars 5.08 score 4 scripts 4 dependents
epiverse-trace
readepi:Read Data from Health Information Systems
Data import from several health information systems ('HIS'). The current version of the package covers 'HIS' such as 'MS SQL', 'MySQL', and 'PostGRESQL' servers, 'REDCap', 'DHIS2' and 'Fingertips'.
Maintained by Karim Mané. Last updated 9 months ago.
data-importepidemiologyepiversehealth-information-systems
1.7 match 6 stars 4.78 score 5 scripts
kwb-r
kwb.db:Functions supporting data base access
This package contains some useful functions, especially for simplifying data transfer between MS Access databases and R. With the functions of this package it is not needed any more to open and close a database connection explicitely; this is done 'behind the scenes' in the functions. Instead of a database connection the path to the database file needs to be passed to the functions as an argument. The main functions are hsGetTable and hsPutTable which transfer data from an MS Access database to a data frame in R and save data from a data frame in R into a table in an MS Access database, respectively. Take care when getting time series data from an MS Access database, see therefore hsMdbTimeSeries. Use hsTables to get a list of tables that are available in a database and hsFields to get a list of table fields that are contained in a database table.
Maintained by Hauke Sonnenberg. Last updated 1 years ago.
data-importdatabase-accessdatabase-connectionrodbc
1.9 match 3.52 score 5 scripts 22 dependents
thinkr-open
devindocker:Help Develop a R Project Inside a Docker Container
Help develop a R project inside a Docker container.
Maintained by Sébastien Rochette. Last updated 4 years ago.
1.3 match 38 stars 4.88 score 7 scripts
exetrujillo
datamedios:Scraping Chilean Media
A system for extracting news from Chilean media, specifically through Web Scapping from Chilean media. The package allows for news searches using search phrases and date filters, and returns the results in a structured format, ready for analysis. Additionally, it includes functions to clean the extracted data, visualize it, and store it in databases. All of this can be done automatically, facilitating the collection and analysis of relevant information from Chilean media.
Maintained by Exequiel Trujillo. Last updated 27 days ago.
1.8 match 1 stars 3.60 score
psychelzh
tarflow.iquizoo:Setup "targets" Workflows for "iquizoo" Data Processing
For "iquizoo" data processing, there is already a package called "preproc.iquizoo", but eventually the use of it is relied on a workflow. This package is used to build such workflows based on tools provided by "targets" package which mimics the logic of "make", automating the building processes.
Maintained by Liang Zhang. Last updated 5 months ago.
1.8 match 10 stars 3.60 score 1 scripts
wahani
templates:A System for Working with Templates
Provides tools to work with template code and text in R. It aims to provide a simple substitution mechanism for R-expressions inside these templates. Templates can be written in other languages like 'SQL', can simply be represented by characters in R, or can themselves be R-expressions or functions.
Maintained by Sebastian Warnholz. Last updated 1 years ago.
1.5 match 4 stars 3.68 score 12 scripts
datastorm-open
shinymanager:Authentication Management for 'Shiny' Applications
Simple and secure authentification mechanism for single 'Shiny' applications. Credentials can be stored in an encrypted 'SQLite' database or on your own SQL Database (Postgres, MySQL, ...). Source code of main application is protected until authentication is successful.
Maintained by Benoit Thieurmel. Last updated 10 months ago.
0.5 match 391 stars 10.51 score 316 scripts 2 dependentsbioc
UCSC.utils:Low-level utilities to retrieve data from the UCSC Genome Browser
A set of low-level utilities to retrieve data from the UCSC Genome Browser. Most functions in the package access the data via the UCSC REST API but some of them query the UCSC MySQL server directly. Note that the primary purpose of the package is to support higher-level functionalities implemented in downstream packages like GenomeInfoDb or txdbmaker.
Maintained by Hervé Pagès. Last updated 2 months ago.
infrastructuregenomeassemblyannotationgenomeannotationdataimportbioconductor-packagecore-package
0.5 match 1 stars 10.09 score 4 scripts 1.7k dependents
usepa
tcpl:ToxCast Data Analysis Pipeline
The ToxCast Data Analysis Pipeline ('tcpl') is an R package that manages, curve-fits, plots, and stores ToxCast data to populate its linked MySQL database, 'invitrodb'. The package was developed for the chemical screening data curated by the US EPA's Toxicity Forecaster (ToxCast) program, but 'tcpl' can be used to support diverse chemical screening efforts.
Maintained by Jason Brown. Last updated 2 days ago.
0.5 match 36 stars 9.41 score 90 scriptskwb-r
aquanes.report:Automated Reporting Tool for Water Suppliers
Collects, aggregates and visualises operational and analytical data from water suppliers (including a standardised reporting document).
Maintained by Michael Rustler. Last updated 6 years ago.
automated-reportingdata-aggregationdata-exportdata-importdata-visualisationpilot-plantproject-aquanesshiny-app
1.1 match 4.01 score 23 scriptskwb-r
kwb.pilot:Importing, Aggregating and Visualising Data From KWB Pilot Plants
Collects, aggregates and visualises operational and analytical data from water suppliers (including a standardised reporting document).
Maintained by Michael Rustler. Last updated 2 years ago.
data-aggregationdata-importdata-visualisationproject-aquanesproject-mbr40project-sulemanproject-ultimate
1.1 match 1 stars 4.01 score 17 scripts
ankane
dbx:A Fast, Easy-to-Use Database Interface
Provides select, insert, update, upsert, and delete database operations. Supports 'PostgreSQL', 'MySQL', 'SQLite', and more, and plays nicely with the 'DBI' package.
Maintained by Andrew Kane. Last updated 1 months ago.
0.5 match 189 stars 7.04 score 47 scripts 2 dependents
jwijffels
ETLUtils:Utility Functions to Execute Standard Extract/Transform/Load Operations (using Package 'ff') on Large Data
Provides functions to facilitate the use of the 'ff' package in interaction with big data in 'SQL' databases (e.g. in 'Oracle', 'MySQL', 'PostgreSQL', 'Hive') by allowing easy importing directly into 'ffdf' objects using 'DBI', 'RODBC' and 'RJDBC'. Also contains some basic utility functions to do fast left outer join merging based on 'match', factorisation of data and a basic function for re-coding vectors.
Maintained by Jan Wijffels. Last updated 5 years ago.
0.5 match 20 stars 4.75 score 28 scripts
skranz
shinyEventsLogin:A simple login framework as part of shinyEvents apps (probably not very secure)
A simple login framework for shinyEvents apps (probably not very secure)
Maintained by Sebastian Kranz. Last updated 9 months ago.
2.3 match 1 stars 1.00 score