I want to experiment / use FTS5 (Full Text Search) SQLite Extension in Datagrip. However the JAR is version 3.8.9 (FTS5 is introduced in 3.9) and whenever I try to create an virtual table I receive an error.
CREATE VIRTUAL TABLE email USING fts5(sender, title, body);
[SQLITE_ERROR] SQL error or missing database (no such module: fts5)
I am neither a Java Expert nor an SQLite expert.
1. Is there a newer driver available (I searched the internet but without success)?
2. Can I load the FTS5 Module into the current Datagrip "configuration"?
3. IS it mandatory to load the extension regardless of the driver version?