Skip to content

Releases: rstudio/pool

pool 1.0.4

07 Oct 16:57
Compare
Choose a tag to compare
  • Switched from hosted MySQL database to local SQLite database in examples.

pool 1.0.3

14 Feb 18:12
Compare
Choose a tag to compare
  • Now explicitly requires DBI 1.2.0 (#178) and messages if you're using an
    old dbplyr (#179).

pool 1.0.2

18 Jan 17:54
Compare
Choose a tag to compare
  • No longer depends on the withr package, by instead requiring R 3.6.

  • Add wrappers for dbplyr generics db_col_types() (#171) and
    db_copy_to() (#172).

  • Pool no longer generates spurious messages about needing to use
    in_schema() or avoiding the use of ident_q().

  • Add support for new DBI generics that return Arrow objects.

pool 1.0.1

21 Feb 15:22
Compare
Choose a tag to compare
  • copy_to() now returns a tbl that uses the Pool.

  • Added missing methods for sql_join_suffix() (#165) and
    sql_query_explain() (#167).

pool 1.0.0

11 Feb 17:54
Compare
Choose a tag to compare

New features

  • Pool has been re-licensed to MIT (#158).

  • dbPool() gains an onCreate parameter that allows you do something to
    every connection that pool creates. This is useful for setting options that
    you want to apply to every connection (#98).

  • New localCheckout() checkouts and then automatically returns an object.
    It only works in function scope.

Minor improvements and bug fixes

  • Pools now get a useful print method (#140).

  • pool now implements the dbplyr 2.0.0 interface, eliminating warnings when
    using pool with dplyr (#132).

  • Pool errors and warnings have been reviewed with an eye to making them
    more immediately actionable (#145).

  • Objects are now validated once on first checkout to ensure that the
    object and validation strategy are both ok.

  • Added support for SAP HANA databases (@marcosci, #103).

  • dbPool() and poolCreate() now default to validating every 60s, rather
    than every 600s. This makes pools a little more robust to shorter connection
    timeouts (#149).

  • dbPool()'s validateQuery is now actually used (#153).

  • DBI methods should dispatch correctly in more cases; in particular
    dbReadTable() and friends will now work correctly when used with
    DBI::Id() (#120).

pool 0.1.6

18 Jan 18:42
Compare
Choose a tag to compare
  • left_join() and friends once again work with pool objects (#111).

  • dbPool() objects previously could leak memory. (#115)