Software system supporting XML and JSON

In previous post, we saw why JSON is trending in town when we need to choose between JSON and XML as data interchange format. However, XML is preferred when document presentation and mixed data representation become priority. Here we will list down software system /web architecture- API's which are using XML and JSON.

Type	Software system/API's
Desktop software uses XML only	Microsoft Word Apache OpenOffice LibreOffice. Notes: XML is obvious choice here because it has support of storing mixed content naturally and the major task associated with these software are creating document, editing and styling at same time. An user can edit and style both same time and such information can be stored in xml naturally.
Databases supporting XML	IBM DB2 Microsoft SQL Server Oracle Database PostgresSQL BaseX eXistDB MarkLogic MySQL
Databases supporting XML	MongoDB CouchDB eXistDB Elastisearch BaseX OrientDB MarkLogic PostgresSQL Riak Oracle Database Notes: JSON is obvious choice of NoSQL database like MongoDB, CouchDB because they store data in JSON format. However, relational database like Oracle, PostgresSQL are also supporting JSON. Like JSON is future as data exchange format, NoSQL is future too in database technologies.
Major public APIs uses JSON only	Facebook Graph API Google Maps API Twitter API AccuWeather API Pinterest API Reddit API Foursquare API Notes: Facebook and Google Map is dealing with high volume of data in range of GB or PetaBytes, so JSON will be most efficient data transmission format.
Major public APIs uses XML only	Amazon Product Advertising API.
Major public APIs uses JSON and XML both	Google Cloud Storage Linkedin API Flickr API

Volume of data is high : JSON preferred
Focus on presentation/document   : XML is preferred. 
  
Read also : Why JSON is future of web centric development?


Reference : XML vs  JSON