What's the best database option for production?

There are so many options — PostgreSQL, MySQL, MongoDB, etc. — and everyone seems to have a different opinion depending on their use case.

So I wanted to ask people with real experience:

• What database do you use in production, and why?
• What made you choose it over others?
• Any regrets or things you’d do differently?
• How does it hold up when scaling?