Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is JSON and is it better than xml etc
Message
From
22/01/2019 21:53:25
 
 
To
22/01/2019 14:42:25
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012 R2
Network:
Windows Server 2012 R2
Database:
Visual FoxPro
Application:
Desktop
Virtual environment:
VMWare
Miscellaneous
Thread ID:
01665642
Message ID:
01665655
Views:
97
Dragan pretty much answered from my POV.
There is only one aspect where XML has benefits over JSON, that is in wrapping text fields with delimiters / not forcing any encoding to the string or memo field.

XML got worse when interlocking schema definitions came with SOAP, but there are also some different flavors of JSON - but those most of the time present no or small parsing problems.

To honor https://xkcd.com/927/ I often wonder if text/memo fields in JSON should be wrapped in <txt></txt> instead of ["], as then chars inside the delimiters could be left alone.

>Hi all,
>
>In discussion with another developer about re-doing a system. This system interacted with a document database and the integration with the VFP app was done with calls that always returned an xml string. The other developer had mentioned using json to return back data from the server.
>
>I have done the wikipedia lookup and have an idea what json data looks like but have some questions:
>
>1) are their json parsers out there for VFP or would I have to write my own; with xml, there were the built in xml functions which I used
>
>2) does json have any advantages over xml?
>
>3) any "gotchas" to watch out for?
>
>Albert
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform