Category "dbplyr"

How to speed up collect() from a dbconnect database

I'm reading tables from an odbc driver on an amazonaws server. I am using R 4.0.0 on a 64 bit windows computer. Working from home and using company's VPN so my

Rolling mean, standard deviation in dbplyr

I want to set a new variable with rolling function (rolling mean, stdev...etc.) in dbplyr Here is a database library(odbc) library(DBI) library(tidyverse) libra