Update to SQLite version used by RSQLite

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:


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.

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