Are you sure you need a database? Maybe "none" is the right answer.

If it isn't, then maybe SQLite, PostgreSQL, or MySQL. At least, that's the order of preference for me, but I avoid databases when possible.

Google uses MySQL heavily, so it obviously scales (but I'm given to understand they had to work hard to do it).