Postgres data types you should consider using

Re:Postgres data types you should consider using by Sharlin on Wednesday August 29, 2018 @05:29PM (#17872234)

A nifty thing we use in our current project is the ltree extension[1]. It allows representing hierarchical relations and making hierarchical queries in a regular flat table structure.

[1] https://www.postgresql.org/docs/10/static/ltree.html

[ Parent | on HN ]

Re:Postgres data types you should consider using by chrstphrhrt on Wednesday August 29, 2018 @06:33PM (#17872664)

Love LTREE! Used it for domain label hierarchies (multiple roots - an "ontology") for a data science team to be able to train many different models with shared/overlapping label sets (an ensemble of models for various domains). It makes queries to get training data powerful since you can ask for "all descendants of X" or "ancestors of Y where Z".

[ Parent | on HN ]

Re:Postgres data types you should consider using by kqr on Thursday August 30, 2018 @12:08AM (#17874026)

Nifty indeed -- that may very well invalidate some old knowledge I have about manually representing trees in relational DBs, supported by recursive CTEs...

[ Parent | on HN ]

Re:Postgres data types you should consider using by fcolas on Wednesday August 29, 2018 @05:36PM (#17872287)

Didn't know that one. Powerful. Thanks!

[ Parent | on HN ]

Re:Postgres data types you should consider using by sv12l on Wednesday August 29, 2018 @07:54PM (#17873075)

Never heard of that, thanks.

[ Parent | on HN ]