edward-burn
edward-burn
At the moment I don't think there is any easy way to generate the result json from the results saved in the database. I was in this situation with someone...
In trying to run [this study](https://github.com/oxford-pharmacoepi/ROC22_CovVaxComparativeSafety/tree/main/CovVaxComparativeSafety) from @Xintong-Li-ZnCu the repeated calls to connect and disconnect to the database here https://github.com/OHDSI/CohortMethod/blob/79b86e4435f66825cecfc8e518d0d1d034d3d4ef/R/DataLoadingSaving.R#L158 causes problems running on sidiap´s postgres database (at some point...
- add str_ilike function - deprecate ignore_case argument in str_like - add tests of case sensitivity for both - update NEWS.md - update _pkgdown.yml
Now that the pr for some clock functions has been merged in https://github.com/tidyverse/dbplyr/pull/1496, there is another function I think is particularly useful for analytics: [date_count_between](https://clock.r-lib.org/reference/date_count_between.html) @krlmlr would you happy for...
In sql server with a very large table with 6 billion rows the below error occurs because COUNT is being used rather than COUNT_BIG. I was able to fix this...
For #1495, adds translations for clock::date_count_between() for a number of backends along with tests and update of news.
To go with existing clock translations (like these https://github.com/tidyverse/dbplyr/blob/8f2fcb0852994afe11cc6792ef59ef5ffda84936/R/backend-postgres.R#L240), one other function from clock that I think would be very useful to translate would be date_count_between, so code like below...
Relates to issue #1488 This pr would change behaviour to the following ``` r library(dbplyr) lf_postgres WHERE (`d` ILIKE 'Y') lf_redshift |> dplyr::filter(stringr::str_like(d, "Y", ignore_case = TRUE)) #> #> SELECT...
@hadley @mgirlich I notice that with the current version of dbplyr if I put head() in my pipeline it will return the same sql whether it was before or after...