Package: pool 1.0.4.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.4.9000.tar.gz
pool_1.0.4.9000.zip(r-4.5)pool_1.0.4.9000.zip(r-4.4)pool_1.0.4.9000.zip(r-4.3)
pool_1.0.4.9000.tgz(r-4.4-any)pool_1.0.4.9000.tgz(r-4.3-any)
pool_1.0.4.9000.tar.gz(r-4.5-noble)pool_1.0.4.9000.tar.gz(r-4.4-noble)
pool_1.0.4.9000.tgz(r-4.4-emscripten)pool_1.0.4.9000.tgz(r-4.3-emscripten)
pool.pdf |pool.html✨
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'))

Peer review:

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

On CRAN:

13.08 score 252 stars 25 packages 584 scripts 14k downloads 2 mentions 51 exports 5 dependencies

Last updated 2 months agofrom:bf0eeff512. Checks:OK: 7. Indexed: no.

TargetResultDate
Doc / VignettesOKNov 06 2024
R-4.5-winOKNov 06 2024
R-4.5-linuxOKNov 06 2024
R-4.4-winOKNov 06 2024
R-4.4-macOKNov 06 2024
R-4.3-winOKNov 06 2024
R-4.3-macOKNov 06 2024

Exports:dbAppendTabledbAppendTableArrowdbBegindbBreakdbCommitdbCreateTabledbCreateTableArrowdbDataTypedbDisconnectdbExecutedbExistsTabledbGetInfodbGetQuerydbGetQueryArrowdbIsReadOnlydbIsValiddbListFieldsdbListObjectsdbListTablesdbPooldbQuoteIdentifierdbQuoteLiteraldbQuoteStringdbReadTabledbReadTableArrowdbRemoveTabledbRollbackdbSendQuerydbSendQueryArrowdbSendStatementdbUnquoteIdentifierdbWithTransactiondbWriteTabledbWriteTableArrowdemoDblocalCheckoutonActivateonDestroyonPassivateonValidatePoolpoolCheckoutpoolClosepoolCreatepoolReturnpoolWithTransactionsqlAppendTablesqlCreateTablesqlDatasqlInterpolatesqlParseVariables

Dependencies:DBIlaterR6Rcpprlang

Why pool?

Rendered fromwhy-pool.Rmdusingknitr::rmarkdownon Nov 06 2024.

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