News for hackers. Stuff that matters.

A comment on Type Constraints in 65 lines of SQL. Parent comment

Re:Type Constraints in 65 lines of SQL by nextaccountic on Friday February 17, 2023 @02:28PM (#34839158)
What's your opinion between jsonb vs hstore columns? https://www.postgresql.org/docs/15/hstore.html
[ Parent | on HN ]
Re:Type Constraints in 65 lines of SQL by oliverrice on Friday February 17, 2023 @07:06PM (#34842353)
IIRC, hstore pre-dated jsonb. I'm not aware of any performance differences for the object type but it would be worth checking if you have a heavy workload. jsonb will tend to have better ORM support (if thats something you care about) and it also isn't behind an extension which is a (small) perk
[ Parent | on HN ]