News for hackers. Stuff that matters.
Re:The growing irrelevance of MongoDB by Kiro on Wednesday January 14, 2015 @04:22AM (#8885165)
I just like being able to insert a random JSON into a collection and query it by any of its properties. Not sure how I would do that with a relational database.
Re:The growing irrelevance of MongoDB by adamors on Wednesday January 14, 2015 @04:37AM (#8885227)
PostgreSQL has full support for JSON [1]. So, quite easily in fact.

[1]: http://www.postgresql.org/docs/9.4/static/datatype-json.html

Re:The growing irrelevance of MongoDB by Kiro on Wednesday January 14, 2015 @05:13AM (#8885371)
Thanks, I didn't know that. What's the benefit of using PostgreSQL though if the functionality is the same?
Re:The growing irrelevance of MongoDB by jerven on Wednesday January 14, 2015 @06:18AM (#8885569)
The reliability and speed advantages of PostgreSQL over MongoDB. Plus the fact that sometimes KV/document is better and sometimes normalized relational. Is nice if one tool solves both.
Re:The growing irrelevance of MongoDB by mateuszf on Wednesday January 14, 2015 @06:21AM (#8885580)
Full ACID transactions, reliability, access to trained DBA-s.
Re:The growing irrelevance of MongoDB by thorin on Wednesday January 14, 2015 @04:38AM (#8885234)
You can do this in Oracle 12 and I think in Postgres. You might want to think about why you need to store unstructured data as part of your application though and query it. If it's expected to live a long time and be queried it should probably be structured. If not you could store it (a serialized object) as a blob if you are just caching some state.

https://docs.oracle.com/database/121/ADXDB/json.htm#ADXDB624...