Following are some of my questions regarding Database/FTS sample project:
- Why do u disable the SearchView in doSearch() when it will shortly be re-enabled in onModelLoaded()?
- If FTS tables ignore constraints like PRIMARY KEY, DEFAULT, NOT NULL, do we have to write code and apply these constraints before inserting data into the table? If yes, whats the best to apply the PRIMARY KEY constraint through java code?
- FTS finds only those SO posts where the full query text is matched. How do we achieve the ‘contains’ or LIKE behaviour using FTS? For instance, an SO post containing the word ‘snackbar’ will be displayed only when the search term is ‘snackbar’; how to display this post if the search term is ‘snack’?