Is Sqlite Fts3 Still The Best Way To Go For Rolling Out Your Full Text Search?

I need to support full text search for a 10 mb document and wondering if I should implement FTS with CoreData or Sqlite3. I am familiar with CoreData and not too fond of Sqlite3.

Solution 1:

It'll be pretty hard to better Core Data by doing it by hand, so try Core Data first; it will be quicker anyway to get your app / tests going. On an iOS device Core Data will use a sqlite database anyway. I've got good results with an in-app database of 3-4Mbytes using Core Data, and without any special coding.