Package: pool 1.0.5.9000

Hadley Wickham

pool: Object Pooling

Enables the creation of object pools, which make it less computationally expensive to fetch a new object. Currently the only supported pooled objects are 'DBI' connections.

Authors:Joe Cheng [aut], Barbara Borges [aut], Hadley Wickham [aut, cre], Posit Software, PBC [cph, fnd]

pool_1.0.5.9000.tar.gz
pool_1.0.5.9000.zip(r-4.7)pool_1.0.5.9000.zip(r-4.6)pool_1.0.5.9000.zip(r-4.5)
pool_1.0.5.9000.tgz(r-4.6-any)pool_1.0.5.9000.tgz(r-4.5-any)
pool_1.0.5.9000.tar.gz(r-4.7-any)pool_1.0.5.9000.tar.gz(r-4.6-any)
pool_1.0.5.9000.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
pool/json (API)

# Install 'pool' in R:

install.packages('pool', repos = c('https://rstudio.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/rstudio/pool/issues

Pkgdown/docs site:https://rstudio.github.io

On CRAN:

13.13 score 255 stars 34 packages 964 scripts 21k downloads 2 mentions 51 exports 5 dependencies

Last updated from:1fceff9f18. Checks:9 OK. Indexed: yes.

Target	Result	Time
linux-devel-x86_64	OK	137
source / vignettes	OK	251
linux-release-x86_64	OK	140
macos-release-arm64	OK	113
macos-oldrel-arm64	OK	97
windows-devel	OK	209
windows-release	OK	82
windows-oldrel	OK	239
wasm-release	OK	112

Exports:dbAppendTable dbAppendTableArrow dbBegin dbBreak dbCommit dbCreateTable dbCreateTableArrow dbDataType dbDisconnect dbExecute dbExistsTable dbGetInfo dbGetQuery dbGetQueryArrow dbIsReadOnly dbIsValid dbListFields dbListObjects dbListTables dbPool dbQuoteIdentifier dbQuoteLiteral dbQuoteString dbReadTable dbReadTableArrow dbRemoveTable dbRollback dbSendQuery dbSendQueryArrow dbSendStatement dbUnquoteIdentifier dbWithTransaction dbWriteTable dbWriteTableArrow demoDb localCheckout onActivate onDestroy onPassivate onValidate Pool poolCheckout poolClose poolCreate poolReturn poolWithTransaction sqlAppendTable sqlCreateTable sqlData sqlInterpolate sqlParseVariables

Dependencies:DBI later R6 Rcpp rlang

Why pool?

One connection per app | One connection per query | Pool: the best of both worlds

Rendered fromwhy-pool.Rmdusingknitr::rmarkdown

Last update: 2024-10-03
Started: 2023-01-29

Citation

Development and contributors

Readme and manuals

Help Manual

Help page	Topics
Unsupported DBI methods	dbBegin,Pool-method dbCommit,Pool-method dbDisconnect,Pool-method dbGetInfo,Pool-method DBI-custom dbIsValid,Pool-method dbRollback,Pool-method dbSendQuery,Pool-method dbSendStatement,Pool,ANY-method dbWithTransaction,Pool-method
DBI methods (simple wrappers)	dbAppendTable,Pool-method dbAppendTableArrow,Pool-method dbCreateTable,Pool-method dbCreateTableArrow,Pool-method dbDataType,Pool-method dbExecute,Pool,ANY-method dbExistsTable,Pool,ANY-method dbGetQuery,Pool,ANY-method dbGetQueryArrow,Pool-method DBI-wrap dbIsReadOnly,Pool-method dbListFields,Pool,ANY-method dbListObjects,Pool-method dbListTables,Pool-method dbQuoteIdentifier,Pool,ANY-method dbQuoteLiteral,Pool-method dbQuoteString,Pool,ANY-method dbReadTable,Pool,ANY-method dbReadTableArrow,Pool-method dbRemoveTable,Pool,ANY-method dbSendQueryArrow,Pool-method dbUnquoteIdentifier,Pool-method dbWriteTable,Pool,ANY-method dbWriteTableArrow,Pool-method sqlAppendTable,Pool-method sqlCreateTable,Pool-method sqlData,Pool-method sqlInterpolate,Pool-method sqlParseVariables,Pool-method
Create a pool of database connections	dbPool
Create a pool of reusable objects	Pool Pool-class poolClose poolClose,Pool-method poolCreate
Check out and return object from the pool	localCheckout poolCheckout poolCheckout,Pool-method poolReturn poolReturn,ANY-method
Self-contained database transactions using pool	poolWithTransaction
Use pool with dbplyr	copy_to.Pool tbl.Pool