My question pertains to the version of SQLite engaged by RSQLite package. In January SQLite v 3.31.0 was released. This version enables the creation of generated columns. I am attempting to build a SQLite database with R to store biological data using RMarkdown. My database would benefit from the addition of generated columns to the schema. Currently I get an error when trying to implement generated columns...
when I run
SELECT sqlite_version()
It returns 3.30.1. I have tried the most recent CRAN version and the development version on Github:
devtools::install_github("r-dbi/RSQLite")
I have SQLite v 3.31.1 installed on my machine, is there any way to link the RSQLite to this version or do I need to wait until the developers update RSQLite package?
Thanks in advance for any assistance.
Chris