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.
copy_to() now returns a tbl that uses the Pool.
Added missing methods for sql_join_suffix() (#165) and
sql_query_explain() (#167).
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.
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.
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).
left_join() and friends once again work with pool objects (#111).
dbPool() objects previously could leak memory. (#115)
dplyr and dbplyr are now Suggests instead of Imports. Thanks, @AkhilGNair! (#106)
When used with dbplyr, tbls now store a copy of the pool, not a checked
out connection. (#107)
dbListObjects(), dbCreateTable(), dbAppendTable(), dbIsReadOnly(), dbQuoteLiteral(), and dbUnquoteIdentifier() methods are now implemented for pool objects. (#100, #109)
options(warn=1) when running tasks. It now ensures that the value of warn can be 1 or greater. This can be useful in debugging, so that options(warn=2) can be used. (#90)dbExistsTable(), dbRemoveTable(), dbWriteTable(), dbGetQuery(), dbExecute(), dbListFields() and dbReadTable() to dispatch over the first two arguments, as per the default definition in DBI. (#57)requireNamespace("pkg", quietly = TRUE) for RMySQL and RSQLite in the examples and tests since these are "Suggests" packages (i.e. not "Depends"). (commit 4205feb)Included more examples in the documentation. (#50)
Fixed the "test-create-destroy.R" test. Previously, this test had to be run manually because it uses later and its async nature could not be captured by testthat. However, using later::run_now() immediately after the relevant code snippet (i.e. still inside the first argument of expect_*) solves the issue. (#50)
Use difftime(t1, t0, units = "secs") when calculating a time interval. Unlike the simpler t1 - t0 method, this guarantees that the result will always be consistently the number of seconds. However, there's no change when calculating a new time (not a time interval) using t2 <- t1 - interval, since we want t2 to be a time, rather than a time interval (which is always what is returned by difftime). (#50 and #48, thank you @caewok!)
Fix all dbplyr wrapper functions that weren't passing in additional arguments because the call to the original dbplyr function included ... = ... instead of .... Also, pass temporary = temporary in copy_to.Pool, so that we don't defeat the whole purpose of that wrapper. (#50)
Change the place where the check for the maximum number of objects is made. Previously, this chunk of code was misplaced and it would result in buggy behavior: namely, once the maximum number of objects was reached, no more objects could be checked out (even if you returned any/all objects back to the pool). The only reason this wasn't spotted earlier is because the default maxSize is Inf (and there's usually not a good reason to change it). (#50)
Fix #39: Moved dplyr support in pool from dplyr 0.5.0 to dplyr 0.7.0, which includes a lot of breaking changes including the addition of a brand new package called dbplyr. (#42)
For pool users, the main change is that all the src_* functions are now gone (from dplyr and pool). Therefore, if you had something like:
data <- src_pool(pool) %>% tbl("test")
You can just change it to the simpler:
data <- pool %>% tbl("test")
If you're still on an old version of dplyr and want to use pool as well, please install the package using the tag created for that purpose:
devtools::install_github("rstudio/[email protected]")
Changed all time arguments to accept number of seconds, instead of milliseconds. This is because this is what the later package uses and there was no reason for pool to be different, except backward compatibility. Since both time arguments to dbPool (idleTimeout and validationInterval) have default values, we're hoping this change won't even be noticed by most users. If you were setting either of those directly, however, you will need to update your app if you update the pool package. (#44)
Dropped the Pool methods around dbConnect and dbDisconnect, because these made it easier to lose track of whether you're operating on a Pool object or on a database connection directly. From now on, only these allow you to get a connection from the pool and return it back, respectively: (#44)
con <- poolCheckout(pool)
poolReturn(con)
later package for scheduling tasks (#44). This also has the side effect of fixing #40 and #43 since later allows us to get rid of the naiveScheduler completely.