dimanche 22 novembre 2015

Confusion on SQLite Tables & Virtual Tables

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

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

Aucun commentaire:

Enregistrer un commentaire