News for hackers. Stuff that matters.
Re:Mongo but on Postgres and with strong consistency benefits by cryptonector on Monday July 08, 2024 @12:39PM (#40906910)
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.
Re:Mongo but on Postgres and with strong consistency benefits by marcus_holmes on Monday July 08, 2024 @08:45PM (#40911443)
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.
Re:Mongo but on Postgres and with strong consistency benefits by cryptonector on Tuesday July 09, 2024 @11:53AM (#40917544)
And I get that, but also hstore is ugly. Just be disciplined :)