Confusion on SQLite Tables & Virtual Tables

Question

I am currently developing a notebook application for the Android environment, however I am stuck on how to approach a SQL search interface. From conducting research, I have found the most effective approach would be to use the "Full Text Search" module (FTS4).

What I am stuck on is the way which I have to handle this. Do I have to:

1. Create both a Note Table and a Virtual Table and use a simple Trigger logic to insert into both tables.

or

2. Do I create a Virtual Table ONLY and maintain the list of Notes within there.

Answer 1

You just have to create a virtual table and maintain list of nodes within there. That is my understanding after reading FTS doc