On Mon, Nov 14, 2022 at 10:03:02PM +0100, Laurenz Albe wrote:
> On Mon, 2022-11-14 at 15:50 +0100, Bzzzz wrote:
> > I'd like to store specs, as they vary a lot from one item to another,
> > hstore or jsonb look like the best solution.
> >
> > Specs can have 2 levels at most.
> > ie: "color": ["white", "black", "blue"]).
> >
> > The indexation is mandatory for fulltext accurate researches in
> > (almost) natural language.
> >
> > So, as the processing is almost the same (maps I/O in Erlang), which one
> > would be the best for my needs, hstore or jsonb ?
>
> "hstore" is obsolete; don't use it.
Do you have any support for this claim?
Best regards,
depesz