PostgreSQL is our preferred database for most situations. It's very reliable and feature-rich. Some of its key features:
Mac OS X 10.8 (Mountain Lion) came with PostgreSQL 9.1.4; be sure $PATH has /usr/local/bin before /usr/bin, or else you'll get the wrong version. Mac OS X 10.9 (Mavericks) does not come with PostgreSQL.
brew install postgresql
To have launchd start Postgres at login:
ln -sfv /usr/local/opt/postgresql/*.plist ~/Library/LaunchAgents
Then to load postgresql now:
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
Or, if you don't want/need launchctl, you can just manually run:
pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start