SQLite / Driver 3.8.9 / FTS5

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?

thanks,

 

Please sign in to leave a comment.