This is a set of user-defined functions that DBI + RPostgres users would find useful. They take similar arguments to DBI functions and behave similarly. The source code is in scr/def.Rmd.
This article provides an overview of each function, its definition code, and examples.
Some familiarity with DBI is assumed since they all heavily rely on it. For more information on these packages, please refer to the articles in references.
- Connections
- Issue a connection
- Disconnect connections at once
- Views
- Create a view
- List views
- Test existence of a view
- Drop a view
- Misc
- Free resources
- Drop a table with options
Introduction
- 巨大なデータがSQLサーバーにあるときに、Rでどう立ち向かうかマニュアル：dbplyrパッケージを中心として
- Introduction to dbplyr
- R: Working with Databases
- Introduction to DBI
DBI
- RSQLite & DBIの使い方
- DBI specification
- DBI: R Database Interface .pdf
- Code Examples for DBI and RPostgres
RPostgres