6

I am interested in using the full text search capability of SQLite.

I understand it was not compiled in to the iPhone/iOS version.

Is this still the case?

p.campbell
  • 98,673
  • 67
  • 256
  • 322
MobileGuy
  • 1,232
  • 1
  • 11
  • 21
  • I am not an expert with iPhone/iOS but would't it be possible to link your (FTS) enabled SQLite lib into your program? At least statically should work. – schoetbi May 10 '11 at 18:15

1 Answers1

4

It is not available in the standard build of sqlite3 on iOS But you can still use it.

The best way to use it is to download the sqlite3 amalgamation and configure it for FTS3. Add the sqlite3.c and sqlite3.h file to your project and remove sqlite3 from your frameworks list on your application.

Statically adding it this way will work perfectly.

davydotcom
  • 2,170
  • 1
  • 16
  • 18
  • We use coredata in the project. Am i going to have an issue if i remove sqlite3 from my project's frameworks? – MobileGuy May 12 '11 at 19:45
  • Yes, you'll have a problem. Core Data pulls from the standard build of SQLite. – Ken Jul 06 '11 at 23:02
  • With iOS 10.2 (possibly much earlier), checking with `"PRAGMA compile_options;"` seems to indicate support: ( "COMPILER=clang-8.0.0 (clang-800.2.34)", "ENABLE_API_ARMOR", "ENABLE_FTS3", "ENABLE_FTS3_PARENTHESIS", "ENABLE_JSON1", "ENABLE_LOCKING_STYLE=1", "ENABLE_RTREE", "ENABLE_UPDATE_DELETE_LIMIT", "HAS_CODEC", "HAVE_ISNAN", "MAX_MMAP_SIZE=20971520", "OMIT_AUTORESET", "OMIT_BUILTIN_TEST", "OMIT_LOAD_EXTENSION", "SYSTEM_MALLOC", "THREADSAFE=2" ) – Scott Corscadden Apr 13 '17 at 14:17