Hierarchical Structures in PostgreSQL (2020)

Re:Hierarchical Structures in PostgreSQL (2020) by jitl on Friday June 25, 2021 @12:29PM (#27632937)

I spent some time looking for this specifically to translate Datalog or Prolog to SQL. There’s theoretical work out there but I didn’t find anything plug and play.

[ Parent | on HN ]

Re:Hierarchical Structures in PostgreSQL (2020) by refset on Friday June 25, 2021 @12:40PM (#27633133)

Not exactly plug and play, but for BigQuery there's now Logica https://opensource.googleblog.com/2021/04/logica-organizing-...

[ Parent | on HN ]

Re:Hierarchical Structures in PostgreSQL (2020) by jitl on Friday June 25, 2021 @10:13PM (#27638437)

Thanks, this is great — and it claims experimental support for SQLite which is where I want it the most.

[ Parent | on HN ]