Step 0: Add an env variable to the shell so that the compiler is forced to compile correctly for Tiger. If this is not done, a lot of errors to do with -flat_namespace will plague you.
computer:~/Projects/sqlite me$ export MACOSX_DEPLOYMENT_TARGET=10.3
Step 1. Download the source and create the directories. I have created a folder called sqlite under a Projects directory. I will compile SQLite in this folder.
computer:~/Projects/sqlite me$ tar xvzf sqlite-3.5.2.tar.gz computer:~/Projects/sqlite me$ cd sqlite-3.5.2 computer:~/Projects/sqlite/sqlite-3.5.2 me$ cp Makefile.in Makefile.bak
Step 2. Edit Makefile.in We are going to do three things. (1) We will comment a switch that takes away the ability to load extensions; this is on line 119 in my Makefile.in. After my edit, that line looks like
117: # You should not have to change anything below this line 118: ############################################################################### 119: #TCC += -DSQLITE_OMIT_LOAD_EXTENSION=1
(2) We will add two switches to enable SQLITE_CORE and FTS3. Note that fts1 and fts2 are NOT compatible with SQLite 3.5.x. In my Makefile.in I add these switches right after the OMIT_EXTENSION switch
120: TCC += -DSQLITE_CORE=1 121: TCC += -DSQLITE_ENABLE_FTS3=1
(3) This is the most complicated step. We will add information about the fts3.c and fts3.h files to the Makefile.in and requires several edits/additions. I have given the line numbers in my Makefile.in
137: # FTS3 (optional)
138: LIBOBJ += fts3.lo fts3_hash.lo fts3_porter.lo fts3_tokenizer.lo fts3_tokenizer1.lo
..
206: # Source code for extensions
207: #
208: SRC += \
209: $(TOP)/ext/fts3/fts3.c \
210: $(TOP)/ext/fts3/fts3.h \
211: $(TOP)/ext/fts3/fts3_hash.c \
212: $(TOP)/ext/fts3/fts3_hash.h \
213: $(TOP)/ext/fts3/fts3_icu.c \
214: $(TOP)/ext/fts3/fts3_porter.c \
215: $(TOP)/ext/fts3/fts3_tokenizer.c \
216: $(TOP)/ext/fts3/fts3_tokenizer.h \
217: $(TOP)/ext/fts3/fts3_tokenizer1.c
..
287: # Header files used by extensions
288: #
289: HDR += \
290: $(TOP)/ext/fts3/fts3.h \
291: $(TOP)/ext/fts3/fts3_hash.h \
292: $(TOP)/ext/fts3/fts3_tokenizer.h
..
542: fts3.lo: $(TOP)/ext/fts3/fts3.c $(HDR)
543: $(LTCOMPILE) -c $(TOP)/ext/fts3/fts3.c
544:
545: fts3_hash.lo: $(TOP)/ext/fts3/fts3_hash.c $(HDR)
546: $(LTCOMPILE) -c $(TOP)/ext/fts3/fts3_hash.c
547:
548: fts3_porter.lo: $(TOP)/ext/fts3/fts3_porter.c $(HDR)
549: $(LTCOMPILE) -c $(TOP)/ext/fts3/fts3_porter.c
550:
551: fts3_tokenizer.lo: $(TOP)/ext/fts3/fts3_tokenizer.c $(HDR)
552: $(LTCOMPILE) -c $(TOP)/ext/fts3/fts3_tokenizer.c
553:
554: fts3_tokenizer1.lo: $(TOP)/ext/fts3/fts3_tokenizer1.c $(HDR)
555: $(LTCOMPILE) -c $(TOP)/ext/fts3/fts3_tokenizer1.c
Step 3. Build the program. I will create a separate build folder so the source code folder is not messed up with built files.
computer:~/Projects/sqlite/sqlite-3.5.2 me$ cd .. computer:~/Projects/sqlite me$ mkdir sqlite-3.5.2-build computer:~/Projects/sqlite me$ cd sqlite-3.5.2-build computer:~/Projects/sqlite/sqlite-3.5.2 me$ ../sqlite-3.5.2/configure computer:~/Projects/sqlite/sqlite-3.5.2 me$ make computer:~/Projects/sqlite/sqlite-3.5.2 me$ sudo make install
That's it. You are done. Now go back to the fts documentation and create your virtual tables to start searching.