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✨
card.svg |card.png
pool/json (API)
NEWS

# Install 'pool' in R:
install.packages('pool', repos = c('https://posit-dev-shinycoreci.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:

Conda:

13.07 score 254 stars 33 packages 1.1k scripts 17k downloads 2 mentions 51 exports 5 dependencies

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

TargetResultTimeFilesSyslog
linux-devel-x86_64OK192
source / vignettesOK224
linux-release-x86_64OK131
macos-release-arm64OK103
macos-oldrel-arm64OK134
windows-develOK94
windows-releaseOK92
windows-oldrelOK118
wasm-releaseOK115

Exports:dbAppendTabledbAppendTableArrowdbBegindbBreakdbCommitdbCreateTabledbCreateTableArrowdbDataTypedbDisconnectdbExecutedbExistsTabledbGetInfodbGetQuerydbGetQueryArrowdbIsReadOnlydbIsValiddbListFieldsdbListObjectsdbListTablesdbPooldbQuoteIdentifierdbQuoteLiteraldbQuoteStringdbReadTabledbReadTableArrowdbRemoveTabledbRollbackdbSendQuerydbSendQueryArrowdbSendStatementdbUnquoteIdentifierdbWithTransactiondbWriteTabledbWriteTableArrowdemoDblocalCheckoutonActivateonDestroyonPassivateonValidatePoolpoolCheckoutpoolClosepoolCreatepoolReturnpoolWithTransactionsqlAppendTablesqlCreateTablesqlDatasqlInterpolatesqlParseVariables

Dependencies:DBIlaterR6Rcpprlang

Why pool?

Rendered fromwhy-pool.Rmdusingknitr::rmarkdownon May 19 2026.

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

Readme and manuals

Help Manual

Help pageTopics
Unsupported DBI methodsdbBegin,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 connectionsdbPool
Create a pool of reusable objectsPool Pool-class poolClose poolClose,Pool-method poolCreate
Check out and return object from the poollocalCheckout poolCheckout poolCheckout,Pool-method poolReturn poolReturn,ANY-method
Self-contained database transactions using poolpoolWithTransaction
Use pool with dbplyrcopy_to.Pool tbl.Pool