Episodes
Denis Bolomier PRO said over 1 year ago on PostgreSQL Hstore :
What is the differents between JSONB and HSTORE ?

David Kimura PRO said over 1 year ago on PostgreSQL Hstore :
JSONB is more powerful than Hstore in many ways, but if you're looking for simply key-value pairs, hstore still works great. 

Hstore - Released in 8.3
JSON - Released in 9.2
JSONB - Released in 9.4

Hstore and JSONB both support indexing which can make querying the data faster.

Login to Comment