hstore is basically the flat precursor to JSONB, and IMO it's as good as obsolet... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		cryptonector on July 8, 2024 \| parent \| context \| favorite \| on: Mongo but on Postgres and with strong consistency ... hstore is basically the flat precursor to JSONB, and IMO it's as good as obsolete. I wouldn't use hstore in a new project, just JSONB.

marcus_holmes on July 9, 2024 [–]

I get that, but I think the temptation to add too much structure to the JSONB would be too great; this is just a temporary or prototype field, so it just needs a name and a value. Hstore works great for this.

cryptonector on July 9, 2024 | [–]

And I get that, but also hstore is ugly. Just be disciplined :)

Consider applying for YC's Summer 2026 batch! Applications are open till May 4
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact