Closed Lelelo1 closed 2 years ago
Lelelo1
commented
2 years ago There is seems to be some option with the sql syntax, LIKE bu also Match. The later is some sort of text search add on: https://blog.xojo.com/2014/03/14/full-text-search-with-sqlite/
Lelelo1
commented
2 years ago I will go for sqlite sql search for now. I could try some search libraries, and create externs for it to be used instead later on, it should be usable for the other goals for the specific search.
Lelelo1
commented
2 years ago To do full text search with sqlite, it seems you enable it by preforming some sql commands: https://www.sqlite.org/fts5.html: It would be good to compare the results with and without - when it is time for that
Search
The first categorical search will use sqlite. And simply make a sql query to find a match. A localized db will be created and saved following the language specified in the parameter of the search.
Overview: As I see it there are cloud and semantic matching approach. Then established java text search engines like Elasti Search that are also available on cloud. The cloud solutions where considered to have too high and unpredictable scale of costs. While semantic is considered an enhancement. Making search for the embeddable database is difficult - since there are no available search packages in haxe. Therefore going with sqlite was considered the best - since there is at least some basic working search in the sql language itself, compared json. There is the possibility of creating a C/C++/ObjC extern library for Groonga, which unfortunately seem overkill and server based. Then there are also the option of have native search (dotnet, cocoa)