Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #6991
| 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> |
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
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