News for hackers. Stuff that matters.

A comment on Don't use MongoDB. Parent comment

Re:Don't use MongoDB by goldmab on Sunday November 06, 2011 @07:27AM (#3202491)
Fair enough, but you can also have a schemaless store by using JSON fields in PostgreSQL or MySQL.
[ Parent | on HN ]
Re:Don't use MongoDB by angelbob on Sunday November 06, 2011 @09:37AM (#3202735)
Not indexably. But you can do a hideous many-tables-per-real-table thing where each field gets a tall thin table in PostGRES or MySQL, do a lot of joins to get your data, and index the fields in that.

It's not as awful as it sounds, performance-wise. It is as awful as it sounds in terms of maintainability, of course.

[ Parent | on HN ]
Re:Don't use MongoDB by joevandyk on Sunday November 06, 2011 @11:38AM (#3203063)
You can index hstore fields in PostgreSQL.
[ Parent | on HN ]
Re:Don't use MongoDB by deoxxa on Sunday November 06, 2011 @08:07AM (#3202558)
That's not an unfair comparison at all - indexing the data in a JSON blob is entirely possible and practical.
[ Parent | on HN ]
Re:Don't use MongoDB by einhverfr on Sunday November 06, 2011 @06:43PM (#3204298)
What you want to index regarding a large text file and what indexes you can create and use may be different.
[ Parent | on HN ]