Showing 15 of total 15 results (show query)
r-dbi
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.
Maintained by Kirill Müller. Last updated 13 days ago.
302 stars 20.87 score 19k scripts 2.9k dependentsr-dbi
RSQLite:SQLite Interface for R
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 in a recent version 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.
Maintained by Kirill Müller. Last updated 2 days ago.
331 stars 18.78 score 8.1k scripts 1.1k dependentsr-dbi
RPostgres:C++ Interface to PostgreSQL
Fully DBI-compliant C++-backed interface to PostgreSQL <https://www.postgresql.org/>, an open-source relational database.
Maintained by Kirill Müller. Last updated 1 months ago.
338 stars 14.78 score 1.6k scripts 31 dependentsr-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 2 months ago.
209 stars 13.68 score 3.7k scripts 15 dependents
ohdsi
DatabaseConnector:Connecting to Various Database Platforms
An R 'DataBase Interface' ('DBI') compatible interface to various database platforms ('PostgreSQL', 'Oracle', 'Microsoft SQL Server', 'Amazon Redshift', 'Microsoft Parallel Database Warehouse', 'IBM Netezza', 'Apache Impala', 'Google BigQuery', 'Snowflake', 'Spark', 'SQLite', and 'InterSystems IRIS'). Also includes support for fetching data as 'Andromeda' objects. Uses either 'Java Database Connectivity' ('JDBC') or other 'DBI' drivers to connect to databases.
Maintained by Martijn Schuemie. Last updated 2 months ago.
56 stars 12.63 score 772 scripts 11 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 1 months ago.
133 stars 12.20 score 792 scripts 10 dependents
tomoakin
RPostgreSQL:R Interface to the 'PostgreSQL' Database System
Database interface and 'PostgreSQL' driver for 'R'. This package provides a Database Interface 'DBI' compliant driver for 'R' to access 'PostgreSQL' database systems. In order to build and install this package from source, 'PostgreSQL' itself must be present your system to provide 'PostgreSQL' functionality via its libraries and header files. These files are provided as 'postgresql-devel' package under some Linux distributions. On 'macOS' and 'Microsoft Windows' system the attached 'libpq' library source will be used.
Maintained by Tomoaki Nishiyama. Last updated 3 days ago.
66 stars 12.11 score 4.5k scripts 19 dependents
prestodb
RPresto:DBI Connector to Presto
Implements a 'DBI' compliant interface to Presto. Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes: <https://prestodb.io/>.
Maintained by Jarod G.R. Meng. Last updated 2 months ago.
132 stars 9.73 score 25 scripts 4 dependents
s-u
RJDBC:Provides Access to Databases Through the JDBC Interface
The RJDBC package is an implementation of R's DBI interface using JDBC as a back-end. This allows R to connect to any DBMS that has a JDBC driver.
Maintained by Simon Urbanek. Last updated 2 years ago.
52 stars 9.52 score 1.1k scripts 6 dependents
imsmwu
RClickhouse:'Yandex Clickhouse' Interface for R with Basic 'dplyr' Support
'Yandex Clickhouse' (<https://clickhouse.com/>) is a high-performance relational column-store database to enable big data exploration and 'analytics' scaling to petabytes of data. Methods are provided that enable working with 'Yandex Clickhouse' databases via 'DBI' methods and using 'dplyr'/'dbplyr' idioms.
Maintained by Christian Hotz-Behofsits. Last updated 1 months ago.
clickhouseclickhouse-databasedbi-interfacedplyrdplyr-sql-backendscpp
94 stars 5.98 score 11 scripts
hypertidy
lazysf:Delayed Read for 'GDAL' Vector Data Sources
Lazy read for drawings. A 'dplyr' back end for data sources supported by 'GDAL' vector drivers, that allows working with local or remote sources as if they are in-memory data frames. Basic features works with any drawing format ('GDAL vector data source') supported by the 'sf' package.
Maintained by Michael Sumner. Last updated 1 years ago.
22 stars 5.04 score 10 scriptsr-dbi
adbi:'DBI' Compliant Database Access Using 'ADBC'
In order to make Arrow Database Connectivity ('ADBC' <https://arrow.apache.org/adbc/>) accessible from R, an interface compliant with the 'DBI' package is provided, using driver back-ends that are implemented in the 'adbcdrivermanager' framework. This enables interacting with database systems using the Arrow data format, thereby offering an efficient alternative to 'ODBC' for analytical applications.
Maintained by Nicolas Bennett. Last updated 4 months ago.
17 stars 5.01 score 1 scripts
teramonagi
RODBCDBI:Provides Access to Databases Through the ODBC Interface
An implementation of R's DBI interface using ODBC package as a back-end. This allows R to connect to any DBMS that has a ODBC driver.
Maintained by Nagi Teramo. Last updated 8 years ago.
12 stars 4.69 score 41 scripts
owp-spatial
hfsubsetR:Hydrofabric Subsetter
Subset Hydrofabric Data in R.
Maintained by Mike Johnson. Last updated 1 months ago.
geospatialhydrofabricnextgennoaa-owpsubsetting
7 stars 4.02 score 8 scripts
hrbrmstr
sergeant:Tools to Transform and Query Data with Apache Drill
Apache Drill is a low-latency distributed query engine designed to enable data exploration and analysis on both relational and non-relational data stores, scaling to petabytes of data. Methods are provided that enable working with Apache Drill instances via the REST API, DBI methods and using 'dplyr'/'dbplyr' idioms. Helper functions are included to facilitate using official Drill Docker images/containers.
Maintained by Bob Rudis. Last updated 4 years ago.
3.45 score 56 scripts