J
jmls
Guest
Postgresql uses a Jason datatype, which can be indexed and searched on which is really powerful. all the features of mongodb, but with transactional support... http://www.postgresql.org/docs/devel/static/functions-json.html On 15 Jun 2014 17:27, "Thomas Mercer-Hursh" bounce-tamhas@community.progress.com wrote: RE: json datatype Reply by Thomas Mercer-Hursh I understand the use case. The only piece I am unsure about ... and mind you, it is unsure, not active opposition ... is the need for a special JSON datatype vs stuffing the JSON in a CLOB. If one sends it over the wire, one is just sending character data ... it happens to be in a format which is useful to the destination without special parsing. Here, one is in the context of paying the price of a disk read, so a little ABL overhead is minor and can't one parse a longchar into a JSON object ready for use with one line of code? So, where is the advantage? Stop receiving emails on this subject. Flag this post as spam/abuse.
Continue reading...
Continue reading...