What is the meaning of json?

Question

What is json in the world of database?

JSON isn't related to databases, but rather a format to have structured data. There are others like XML and YAML. — Ismael Miguel, Jul 13 '15 at 16:02
possible duplicate of [What is JSON and why would I use it?](http://stackoverflow.com/questions/383692/what-is-json-and-why-would-i-use-it) — rolfl, Jul 13 '15 at 16:03

score 4 · Answer 1 · edited May 23 '17 at 11:51

JSON can be used by some relational databases as a native formats. Others databases can interpret JSON and insert data into tables.

Microsoft SQL (no native support, link is to parser that someone made)
MySQL (No native support yet, link to other SO answer with some ideas)
PostgreSQL (native support, link to manual)

The long and the short of it, a database is usually not the best tool to consume JSON. It is done much more easily with virtually every modern programming/scripting language ever.

score 0 · Answer 2 · answered Jul 13 '15 at 15:59

0

JSON, or JavaScript Object Notation, is a minimal, readable format for structuring data. It is used primarily to transmit data between a server and web application, as an alternative to XML.

Refer: What is JSON

JSON Wikipedia

answered Jul 13 '15 at 15:59

Rahul

76,197
13
71
125

Answers are allowed on such questions? – Asif Mushtaq Jul 13 '15 at 16:04
1

Well if such questions are allowed then why not answer? – Rahul Jul 13 '15 at 16:04
1

@Rahul Such questions aren't allowed. It just isn't closed fast enough IMHO. – Mast Jul 13 '15 at 16:43

What is the meaning of json?

2 Answers2