On Aug 26, 2009, at 7:03 AM, Simon Slavin wrote: > > On 26 Aug 2009, at 1:27pm, P Kishor wrote: > >> However, on a Mac you don't really want this. Just download the >> source >> code at http://www.sqlite.org/sqlite-amalgamation-3.6.17.tar.gz, >> gunzip it, run make, make install, and it will install all the bits >> and bobs for you in the right place. > > Actually, on a Mac you might not need that either. You will find > sqlite already installed in various places including > > /usr/include/sqlite3.h > /usr/include/sqlite3ext.h > /usr/lib/libsqlite3.0.8.6.dylib > /usr/lib/libsqlite3.0.dylib > /usr/lib/libsqlite3.dylib > /usr/lib/sqlite3 > /usr/lib/sqlite3/libtclsqlite3.dylib > /usr/lib/sqlite3/pkgIndex.tcl > /usr/share/man/man1/sqlite3.1.gz > > unless you specifically need a later version than 3.0.8.6 . If you > do, make sure your own installation does not overwrite the existing > one since this may upset the various system components that use it. > Point of clarification - the sqlite shared library that comes preinstalled on a mac has 2 oddly _named_ variants: libsqlite3.0.8.6.dylib (a symlink) and libsqlite3.0.dylib (the actual library). This is due to the way the sqlite autoconf/Makefile build resources are configured to name the library. The actual version of the sqlite library installed on Mac OS X 10.5 (Leopard) is 3.4.0
If you don't _need_ access to newer features of sqlite for your application it is highly recommended that you use the pre-installed shared library since it has been qualified to work well with the hardware, file systems and operating systems supported by the mac. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
