SQLite is great for small things and learning. It's very powerful, yet light. I don't think they have a mac support, but they do offer source code. Maybe you can compile it from source.
But if you want "The Real Thing"(tm), then get MySQL for sure. I like phpMyAdmin as the front end interface, but it requires a web server as well.