News for hackers. Stuff that matters.

A comment on Why MongoDB is a bad choice for storing our scraped data. Parent comment

Re:Why MongoDB is a bad choice for storing our scraped data by lmm on Tuesday May 14, 2013 @11:28AM (#5705527)
It is not nice to have to manipulate JSON as a plain string (you miss out on validation, have to manually construct like expressions for queries, and I don't even want to think about what you'd have to do to update part of a document), at least using "plain old SQL". (PostgreSQL's native JSON support would make it quite easy, but that supports my point)
[ Parent | on HN ]
Re:Why MongoDB is a bad choice for storing our scraped data by snaky on Tuesday May 14, 2013 @12:28PM (#5705990)
If you need to query JSON content, why to store it like plain string, to begin with? Parse it at application level (or even in stored procedure) and store like ordinary fields. Or use hstore.
[ Parent | on HN ]
Re:Why MongoDB is a bad choice for storing our scraped data by kanja on Tuesday May 14, 2013 @02:58PM (#5707201)
Postgres additionally has a json field type.
[ Parent | on HN ]
Re:Why MongoDB is a bad choice for storing our scraped data by snaky on Tuesday May 14, 2013 @05:08PM (#5708171)
That is for now, until PostgreSQL 9.3 released, have only one useful feature comparing to plain string - validation. That's not much help, and that original lmm's point was about.
[ Parent | on HN ]