Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #6991

Re: JSON

From "Johan Nel" <johan.nel@xsinet.co.za>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: JSON
Date 2014-06-20 13:40 +0200
Organization A noiseless patient Spider
Message-ID <lo16kb$atm$1@dont-email.me> (permalink)
References <lna17p$3lh$1@dont-email.me> <lnbjsc$u3j$1@dont-email.me> <53a39f33$0$3788$6d5eeec5@news.sunnyusenet.com>

Show all headers | View raw


Hi Marc,

Add on top of that, PostgreSQL now have JSON as a native column type and a 
JSONB in the beta release.  You can therefore store JSON in native format in 
the database and the database validate that it is a valid JSON during 
UPDATE/INSERT.  Some nice features going with it, is that there are 
functions to JsonToRow(<json>) and RowToJson(<row>) that allow for the 
front-end to not even have to know it is interfacing to a JSON type.

Regards,

Johan Nel
Vulcan VIP
Durban, South Africa.

"Marc Verkade [MITCon]" <marc@mitNOSPAMconDELETE.nl> wrote in message 
news:53a39f33$0$3788$6d5eeec5@news.sunnyusenet.com...
> Hai Dirk,
>
> Basically JSON communication means that the receiver 'knows' how the file 
> will look like so all fieldname and properties as send by XML are stripped 
> from JSON.
> This makes the size of JSON return data much smaller when compared with 
> sending the same data with XML making webservices much more responsive.
> I use it for all my webservice communication between our backoffice and 
> Android / iPhone apps
> To me that is more or less all that is different and the big advantage!
> Regards, Marc
>
>
> "Dirk (Belgium)"  schreef in bericht news:lnbjsc$u3j$1@dont-email.me...
>
> Hi Arne,
>
> Can you explain the basics of JSON?
> Perhalps it can be good for me?
>
> Thanks a lot.
>
> Dirk (Belgium)
>
> ==================
>
> Arne Ortlinghaus wrote:
>
>> I had to make a communication with another program and we decided to
>> use JSON and transfer the data via Windows messages.
>>
>> It is a nice solution using this protocol. It is better suited for
>> direct programming usage and shorter than XML. For example being able
>> to distinguish between strings and numbers.
>>
>> I used the JSON parser from Phil McGuiness. It worked fine.
>>
>> Arne Ortlinghaus
>> ACS Data Systems
>
>
>
> -- 



---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Find similar | Unroll thread


Thread

JSON "Arne Ortlinghaus" <Arne.Ortlinghaus@acs.it> - 2014-06-11 18:47 +0200
  Re: JSON "Dirk (Belgium)" <dirk.dot.herijgers@pbprojects.dot.be> - 2014-06-12 07:12 +0000
    Re: JSON "Arne Ortlinghaus" <Arne.Ortlinghaus@acs.it> - 2014-06-12 13:08 +0200
    Re: JSON "Marc Verkade [MITCon]" <marc@mitNOSPAMconDELETE.nl> - 2014-06-20 04:39 +0200
      Re: JSON "Johan Nel" <johan.nel@xsinet.co.za> - 2014-06-20 13:40 +0200

csiph-web