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.
[ Parent
| on HN ]
PostgreSQL has full support for JSON [1]. So, quite easily in fact.
[1]: http://www.postgresql.org/docs/9.4/static/datatype-json.html
Thanks, I didn't know that. What's the benefit of using PostgreSQL though if the functionality is the same?
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.
Full ACID transactions, reliability, access to trained DBA-s.
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...