I am moving a question from the CDM github over here as I think it will get more traction on the forums:
General question on database design that will be accessed via R - should the use of BIGINTs be changed to a VARCHAR (and can be the hex of the big integer)?
Base R does not support 64bit integers. The bit64 package is often used to support this and I believe that many dplyr / dbplyr functionality works with integer64 class objects vs integer. But if using Base R, then one loses the precision (down to about 52 bits I believe based on the IEEE format for a double) and IDs that are BIGINT in the database will get munged to the same real / double in R.
Since the OHDSI suite includes R packages, I’m wondering if there is a known policy / best practices on this.
-github user Brianrepko