This is a question I'm asked often and one that we weigh continually in our work. There are no simple answers. As is often the case when weighing technology solutions. But this is a pretty fair article that compares the two relational DB technologies.
The new ActiveStorage facilities are now baked in to Rails. This is a great instrutional video from GoRails on how to utilize it.