Citus Data Blog company blog

Unstructured Datatypes in Postgres – Hstore vs. JSON vs. JSONB

All about when to use unstructured data types in Postgres, such as Hstore, JSON, and JSONB. The tl;dr is that the right data type depends on your use case. Here we dig deep into the benefits, and why JSONB became so popular since it first got real and proper support in Postgres 9.4. The B in JSONB stands for better.
Points
157
HN comments
43
Submissions
1
Cited by
0 commenters

Databases & DataSoftware Engineering2016

On Hacker News

SubmittedTitle on HNPointsComments
Jul 20, 2016Unstructured Datatypes in Postgres – Hstore vs. JSON vs. JSONB by craigkerstiens15743

More from Citus Data Blog

All 44 posts →

Related posts from the same era