Why do we need to use SQL when we have JSON XML and all the others?

Question

I know SQL is databases

Answer 1

SQL is a query language -- you "describe" what kind of data (meeting what criteria exactly) you want to extract, update, add or delete to the database.

XML and JSON are simply popular formats in which the data are stored and distributed between machines (disregarding databases).

Answer 2

JSON and XML are common formats for exchanging data, these formats is a solution to bridge differences of proprietary formats previously used by common DBMSes, different database engines can exchange data (import/export) thanks to these standards.

SQL is a data definition and manipulation language, so its purpose is to define and manipulate data, not for exchanging/transporting data, this IMO is where the difference lies. JSON & XML carries data, but AFAIK neither JSON nor XML can instruct a database engine to do a task.

Hth, cmiiw

Answer 3

Thanks To All!!

Answer 4

Because db are optimized for data access (in very large dataset is very noticable), multi-access locking and some other things... in practice db allow you to store data and handle it in more powerful manner while jsob/xml allow you only to store data