What issues did you have with FTS5 that made you switch to Tantivy? Does using Tantivy mean you have to load the entire Sqlite db into memory? I ask because in

What issues did you have with FTS5 that made you switch to Tantivy? Does using Tantivy mean you have to load the entire Sqlite db into memory? I ask because in my own project I have my own search query grammar [0] written in Lezer that more or less "transpiles" [1] to SQL+FTS5 that's been uh, tedious to build. [0] https://github.com/AlexErrant/Pentive/blob/main/shared-dom/src/language/query.grammar [1] https://github.com/AlexErrant/Pentive/blob/main/shared-dom/src/language/query2sql.ts