In my app I have to search my SQLite database and I would like to know what is the best approach to take. I have been using SQL so far but that is just for simple one argument searches.
What I am trying to do
The application is to search a set of ingredients(table 1) against a set of recipes and their ingredients(table 2) and return the name of a recipe if table 1 has any of the matching ingredients.
As I am going to be searching for multiple arguments should I go with SQL queries or FTS3?
Where I want to go
I am also looking to add some AI searching down the line and cant seem to find any documentation on it, so if someone could point me in the right direction there that would be great.
Aucun commentaire:
Enregistrer un commentaire