About

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.

Functions included

• 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

References

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

• RPostgres - Reference