![]() The odbc R package is DBI-compliant, and is recommended for ODBC connections. The odbc R package provides a standard way for you to connect to any database as long as you have an ODBC driver installed. As of this writing, SQL variants are supported for the following databases: Oracle, Microsoft SQL Server, PostgreSQL, Amazon Redshift, Apache Hive, and Apache Impala. The dplyr package now has a generalized SQL backend for talking to databases, and the new dbplyr package translates R code into database-specific variants. ![]() ![]() When working with databases, you should always use packages that are DBI-compliant. The DBI specification has gone through many recent improvements. The query examples below demonstrate some of the capabilities of these R packages. Several recent package improvements make it easier for you to use databases with R.
0 Comments
Leave a Reply. |