I migrated from a custom database to postgresql. I have to say I am much happier in terms of being able to generate complex reports.
The types and jsonb are also very nice.
I have used mysql early in my career, and I still use it for certain existing projects. I liked the simplicity of its command line, but postgresql has caught up, and they continue to add amazing features.