How can I know whether MySQL, SQLite, PostgreSQL, etc. are installed on Mac OS X 10.7?

Question

I'm running Mac OS X 10.7. How can I know whether MySQL, SQLite, PostgreSQL, etc. are installed on the system?

Answer 1

Try the Terminal command mdfind (string) | grep include

For example:

$ mdfind postgres | grep include
/usr/include/postgresql/server/postgres_fe.h
/usr/include/postgresql/server/postgres_ext.h
/usr/include/postgresql/server/postgres.h
/usr/include/postgresql/internal/postgres_fe.h
/usr/include/postgres_ext.h
...

$ mdfind sqlite | grep include
/usr/include/sqlite3ext.h
/usr/include/sqlite3.h
/usr/include/php/ext/sqlite3/libsqlite/sqlite3.h
/usr/include/php/ext/sqlite/libsqlite/src/sqlite.h
...

This is a good way to determine if there are header files installed for the respective database libraries you ask about.

Answer 2

You can consult the list of open source products that ship as part of Lion and Lion Server.

Also a mdfind command can list all the executable files that have been indexed and you can grep for specific file names to filter out the excess results. This will show any files installed not from Apple's original payload with Lion.

mdfind "kMDItemKind == 'Unix Executable File'" | grep -w sqlite3