Package: pool 1.0.4

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.4.tar.gz
pool_1.0.4.tar.gz(r-4.5-noble)pool_1.0.4.tar.gz(r-4.4-noble)
pool_1.0.4.tgz(r-4.4-emscripten)pool_1.0.4.tgz(r-4.3-emscripten)
pool.pdf |pool.html✨
pool/json (API)
NEWS

# Install 'pool' in R:
install.packages('pool', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

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

Pkgdown:https://rstudio.github.io

8.28 score 25 packages 624 scripts 14k downloads 2 mentions 51 exports 5 dependencies

Last updated 3 months agofrom:5b76f915c8. Checks:OK: 2. Indexed: no.

TargetResultDate
Doc / VignettesOKDec 07 2024
R-4.5-linuxOKDec 07 2024

Exports:dbAppendTabledbAppendTableArrowdbBegindbBreakdbCommitdbCreateTabledbCreateTableArrowdbDataTypedbDisconnectdbExecutedbExistsTabledbGetInfodbGetQuerydbGetQueryArrowdbIsReadOnlydbIsValiddbListFieldsdbListObjectsdbListTablesdbPooldbQuoteIdentifierdbQuoteLiteraldbQuoteStringdbReadTabledbReadTableArrowdbRemoveTabledbRollbackdbSendQuerydbSendQueryArrowdbSendStatementdbUnquoteIdentifierdbWithTransactiondbWriteTabledbWriteTableArrowdemoDblocalCheckoutonActivateonDestroyonPassivateonValidatePoolpoolCheckoutpoolClosepoolCreatepoolReturnpoolWithTransactionsqlAppendTablesqlCreateTablesqlDatasqlInterpolatesqlParseVariables

Dependencies:DBIlaterR6Rcpprlang

Why pool?

Rendered fromwhy-pool.Rmdusingknitr::rmarkdownon Dec 07 2024.

Last update: 2024-10-08
Started: 2023-02-11

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