Company
Date Published
Author
Cihan Biyikoglu, Director of Product Management, Couchbase
Word count
271
Language
English
Hacker News points
None

Summary

Dzone.com features articles discussing the integration of JSON with SQL, highlighting how SQL extensions are adapting to the flexibility of JSON. Various databases, including operational document databases like Couchbase, MongoDB, and DocumentDB, natively support JSON, allowing fast data access and SQL-based querying, except for MongoDB which uses a find() method. Relational databases such as SQL Server, Oracle, MySQL, and Postgres retrofit JSON using a data type similar to XML, translating JSON into tables, columns, and rows. Columnar and key-value databases like Cassandra and Riak are also incorporating JSON by extending their native models. Additionally, SQL-based analytics languages like Drill, Hive, and Spark have extended their capabilities to process JSON, reflecting its popularity as a serialization format.