Hacker News Reader

What do you mean by PG's column mode?

Postgres has had hstore for schema-less data since 2003.

This is a very blunt statement and overvalues hstore. Keys AND values in hstore are and can only be text strings.

With arrays and composite type the potential for semi-structured schema was there for decades. The concept just got more mainstream with NoSQL, more easy to maintain and more efficient with indexables type such as JSONB.

Yes hstore is limited but since you can represent numbers and even hstore itself as text, all you really have to do is cast to and from text and then you have a nested structure with almost anything in it...

jsonb is much better obviously but hstore was really nice and kind of under appreciated.

Why EAV is plague? Isn't JSON type a wrapper of EAV?

JSON type is JSON type, EAV isn't a data type, it's a data modelling pattern.

You can see what they were referring to here: https://en.m.wikipedia.org/wiki/Entity–attribute–value_model