sqlite on MacOS X

cormullion · Post by **cormullion** » Mon Dec 19, 2005 9:45 pm

Just wondering whether sqlite is correctly configured on MacOS X Tiger (10.4.2)?

sqlite.lsp says:

;; Mac OSX / Darwin
(= (& 0xF (last (sys-info))) 3) (set 'library "/usr/local/lib/libsqlite3.0.dylib")

but 'find' shows sqlite in the following locations:

/usr/bin/sqlite3
/usr/lib/libsqlite3.0.8.6.dylib
/usr/lib/libsqlite3.0.dylib
/usr/lib/libsqlite3.dylib
/usr/lib/php/DB/sqlite.php
/usr/lib/sqlite3
/usr/lib/sqlite3/libtclsqlite3.dylib
/usr/share/man/man1/sqlite3.1
/usr/share/newlisp/sqlite.lsp
/usr/share/newlisp/sqlite3.lsp

Error message is:

dlopen(/usr/local/lib/libsqlite.so, 9): image not found
problem loading library in function import : "/usr/local/lib/libsqlite.so"

Lutz · Post by **Lutz** » Tue Dec 20, 2005 12:49 am

Interesting, how did you installl SQLite3 ?

Lutz

cormullion · Post by **cormullion** » Tue Dec 20, 2005 9:11 am

Lutz wrote:Interesting, how did you installl SQLite3 ?

Lutz

I don't think I did... Isn't it part of MacOS 10.4 (Tiger)?

Lutz · Post by **Lutz** » Tue Dec 20, 2005 11:51 am

Thats probably why we see the difference. We will change to usr/lib then.

Lutz

cormullion · Post by **cormullion** » Tue Dec 20, 2005 8:34 pm

I read somewhere that 3rd party non-system tools should be installed in /usr/local rather than /usr/bin? Perhaps this is one of those issues that Unix gurus argue about... :-)

Dmi · Post by **Dmi** » Wed Dec 21, 2005 7:17 am

about /usr/local: Simply usefulness.
The tons of files under /usr on most systems are well-maintained by package manager.
If you will place there your files by "make install" or "cp", then sometimes you'll spent many time with maintaining your own files inside all the trash that sits in /usr :-)

In other hand, if you prepare/install a system package, then it's ok to place it in /usr (or everywhere you want ;-)