3 ms·
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
by tmaly 9y ago
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.
- seanharr11 9y agoI'm trying to give some consult to a company who is looking to store JSON data in MySQL, and they have a Rails app. Given a Rails web app (i.e. ActiveRecord models), what is the best choice if the JSON column type is essential? Initial research shows that PostgreSQL stores JSONB more efficiently, and provides faster query performance with indexes, while MySQL exposes and JSON query interface w/o much optimization. Thoughts?