It seems like some databases have implement a Record/Struct
type and others have implemented a Json/Jsonb
type to handle nested data structures. A few examples being:
Why do some databases use a json
field to support a complex type and others use a struct
field? For example, if the json
field is essentially a string field with many helper methods (to validate, to extract a value, etc.), why don't those databases also incorporate a struct
type? Is the struct
type much more difficult and complex to implement, or what are the differences in why some dbs have it and others do not?