Re:Dynamic Typing in SQL
by DLA on Friday November 02, 2018 @06:44PM
(#18367340)
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/
[ Parent
| on HN ]
I 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.