Tag: mydb

Installation and set up of R6 rocker object

Installation of current released version from CRAN install.packages(“rocker”) Installation of current development version from GitHub install.packages(“devtools”) devtools::install_github(“nikolaus77/rocker”) Create new rocker database handling object Option 1 db <- rocker::newDB() # New database handling object #> dctr | New object Option 2 db <- rocker::rocker$new() # New database handling object #> dctr…

Continue Reading Installation and set up of R6 rocker object

R connection to sqlite – Stackify

SQLite is a file level database, hence to reference it requires a full directory path. No where do you specify the working directory or a full path in the file name. By default, R will use the current working directory contained in getwd(). If database is not contained in this…

Continue Reading R connection to sqlite – Stackify

r – RSQlite – Find values with most occurences in group

I’m using RSQlite to import Datasets from an SQlite-Database. There are multiple millions of observations within the Database. Therefor I’d like to do as much as possible of Data selection and aggregation within the Database. At some point I need to aggregate a character variable. I want to get the…

Continue Reading r – RSQlite – Find values with most occurences in group