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
| Submitted | Title on HN | Points | Comments |
|---|---|---|---|
| Jul 20, 2016 | Unstructured Datatypes in Postgres – Hstore vs. JSON vs. JSONB by craigkerstiens | 157 | 43 |