3 ms·
And a comparison to CockroachDB which also has excellent JSON support along with all the benefits of SQL. See: https://www.cockroachlabs.com/blog/json-coming-to
by DLA 8y ago
And a comparison to CockroachDB which also has excellent JSON support along with all the benefits of SQL.
See: https://www.cockroachlabs.com/blog/json-coming-to-cockroach/ https://www.cockroachlabs.com/blog/json-coming-to-cockroach/
- tudorb 8y agoI think the main difference between our flavor of SQL and CockroachDB's (or PostgreSQL's) is that we don't have a specific "json" data type, but rather: 1. We don't need you to specify the types of any fields, indeed, we don't even need to know upfront which top-level fields ("columns") may exist in the document. 2. You don't need to use special operators / functions to deal with JSON-typed values.