Update to SQLite version used by RSQLite

General
1

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

2

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.