Data Science. TileDB. Open Source. Quant Research. R. C++. Debian. Linux. Adjunct Clinical Professor, University of Illinois. Lots of coffee. And some running.
Then do look at r2u which extends 'easier access / use/ (`bspm`) with a repo full of 19k pre-made binaries (all of CRAN plus bits of BioC) all *with full system-level dependency resolution* for Ubuntu 20.04 and 22.04.
eddelbuettel.github.io/r2u/
Currently home-alone (as "my wife left me" for a sabbatical month at Berkeley, plus some travel before and after) so I
✔️cooked a decent dinner sauce and froze half of it
✔️varying other half day by day: linguini y'day, rigatoni today, penne tomorrow 😀
cooking.nytimes.com/recipes/…
Don't do JSON. R's own serialize is much better. You may just need `serialize(x, ascii=TRUE)`. We do this in another context (that is not on CRAN) and it ... just works. Give it a few more whirls, it is worth it.
Friends don't let friends use JSON for large data.
Yes, from `qs` and like my `RcppRedis` package this sits on top of base R `(un)serialize` via my `RApiSerialize` package. `qs` is great and clever too, may you can "bend it" for your PostgreSQL use.
Not obscure but also ... not obvious. Mapping 'complex' data structures to schemas is hard; running `serialize()` is easier. You can then `rawToChar()` it and should be able to store in a varchar, get it back and call `charToRaw(unserialize()). See my RcppRedis package.
As `nanotime` uses int64_t representation via `bit64::integer64` you can join on that (if you don't convert)!
The `data.table` package does a few things right here (IDate, IDateTime) and has long had both `nanotime` support and joins for time-series.
This is #rstats R FAQ 7.31, but in a trenchcoat.
You cannot (generally, reliably) test equality on floats -- which POSIXct is under the hood -- so in turn joins are tricky to impossible. You can truncate down, or do approximate joins, or ...
More #r2u in action: this time it fits into overall system management. During a daily `apt` update via `wajig` we see ten upgrades, seven new (all new CRAN packages). The update gets us new Ubuntu packages, new RStudio (via my PPA) plus one CRAN update - in one command. #rstats
Thrilled to have learned hat I will get to talk about #r2u at the upcoming Ontario Statistical Software Conference in Toronto! Very much looking forward to it, and now debating whether to be 'in person' or merely virtual... Come join me, and register at the link below. #rstats
A sneak peek at our preliminary speaker lineup for our first annual Statistical Software Conference.
This is a one-day conference bringing together academic and industry participants to share best practices on developing statistical software.
Learn more: bit.ly/3EqA23v
Sorry to hear that, but no, not as a general rule (and both `Rcpp` and the packages using it are in generally good shape at CRAN). Can you try smaller and smaller subsets of your package or routines to find a _minimally verifiable complete example_ that differs?
There are no short or one-line answers as it depends on the OS, the use case (development too? if so how/which tools?), and more. And #Rstats itself ships with an entire manual devoted to this for a reason:
rstudio.github.io/r-manuals/…