Hacker News new | ask | show | jobs
by seanharr11 3219 days ago
I'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?