June 2020
Beginner to intermediate
522 pages
9h 6m
Chinese
Content preview from R 语言经典实例（原书第 2 版）
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
120
｜
第
4
章
中的文本字符串，或者将 SQL 放在由 R 读入的单独文件中。
通过允许 dplyr 在后台创建 SQL，你可以不必维护单独的 SQL 代码来提取数据。
dbplyr 软件包使用 DBI 连接到你的数据库，因此需要一个 DBI 后端软件包来访问数据库。
一些常用的 DBI 后端包是：
odbc
使用开放式数据库连接（Open Database Connectivity，ODBC）协议连接到许多不同的数
据库。当你连接到 Microsoft SQL Server 时，这通常是最佳选择。ODBC 在 Windows
机器上通常很简单，但可能需要花费大量精力才能在 Linux 或 macOS 中工作。
RPostgreSQL
用于连接 Postgres 和 Redshift。
RMySQL
用于连接 MySQL 和 MariaDB。
RSQLite
用于连接硬盘或内存中的 SQLite 数据库。
bigrquery
用于连接 Google 的 BigQuery。
此处讨论的每个 DBI 后端程序包都列在 CRAN 上，可以使用常用的 install.
packages ('
packagename
') 命令进行安装。
4.17.4 另请参阅
有关使用 R 和 RStudio 连接数据库的更多信息，请参阅
https://db.rstudio.com/
。
有关 dbplyr 包中 SQL 语句转换的更多详细信息，请通过 vignette("sql-translation")
或
http://bit.ly/2wVCOKe ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.