3 ms·
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.
by Kiro 12y ago
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.
- adamors 12y agoPostgreSQL has full support for JSON [1]. So, quite easily in fact. [1]: http://www.postgresql.org/docs/9.4/static/datatype-json.html http://www.postgresql.org/docs/9.4/static/datatype-json.html
- Kiro 12y agoThanks, I didn't know that. What's the benefit of using PostgreSQL though if the functionality is the same?
- thorin 12y agoYou 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#ADXDB6246 https://docs.oracle.com/database/121/ADXDB/json.htm#ADXDB624...