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. Anyone with experience care to enlighten me? What other options do i have? Thanks!
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.