pool 1.0.4
  • Reference
  • Articles
    • Why pool?
    • Using pool with dplyr
    • Advanced usage
  • Changelog

Reference

Generic pool tools

poolCreate() poolClose()

Create a pool of reusable objects

poolCheckout() poolReturn() localCheckout()

Check out and return object from the pool

Database functions

dbPool()

Create a pool of database connections

dbDataType(<Pool>) dbGetQuery(<Pool>,<ANY>) dbExecute(<Pool>,<ANY>) dbListFields(<Pool>,<ANY>) dbListTables(<Pool>) dbListObjects(<Pool>) dbReadTable(<Pool>,<ANY>) dbWriteTable(<Pool>,<ANY>) dbCreateTable(<Pool>) dbAppendTable(<Pool>) dbExistsTable(<Pool>,<ANY>) dbRemoveTable(<Pool>,<ANY>) dbIsReadOnly(<Pool>) sqlData(<Pool>) sqlCreateTable(<Pool>) sqlAppendTable(<Pool>) sqlInterpolate(<Pool>) sqlParseVariables(<Pool>) dbQuoteIdentifier(<Pool>,<ANY>) dbUnquoteIdentifier(<Pool>) dbQuoteLiteral(<Pool>) dbQuoteString(<Pool>,<ANY>) dbAppendTableArrow(<Pool>) dbCreateTableArrow(<Pool>) dbGetQueryArrow(<Pool>) dbReadTableArrow(<Pool>) dbSendQueryArrow(<Pool>) dbWriteTableArrow(<Pool>)

DBI methods (simple wrappers)

poolWithTransaction()

Self-contained database transactions using pool

tbl.Pool() copy_to.Pool()

Use pool with dbplyr

dbSendQuery(<Pool>) dbSendStatement(<Pool>,<ANY>) dbDisconnect(<Pool>) dbGetInfo(<Pool>) dbIsValid(<Pool>) dbBegin(<Pool>) dbCommit(<Pool>) dbRollback(<Pool>) dbWithTransaction(<Pool>)

Unsupported DBI methods

Contents

Developed by Joe Cheng, Barbara Borges, Hadley Wickham, Posit Software, PBC.

Site built with pkgdown 2.1.3.