Hierarchical Structures in PostgreSQL

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

Our great sponsors
  • Scout APM - Truly a developer’s best friend
  • SonarLint - Clean code begins in your IDE with SonarLint
  • talent.io - Download talent.io’s Tech Salary Report
  • comment-castles

    Experimental internet forum

  • Closure Tree

    Easily and efficiently make your ActiveRecord models support hierarchies

    I'm actually using materialized views and CTE with PhotoStructure (where hierarchies are arguably the cornerstone of the product).

    It's pretty funny that I landed on this implementation, given that I spent a couple years building https://github.com/ClosureTree/closure_tree (one of the most popular acts-as-hierarchy ActiveRecord gems), as it (unsurprisingly) uses closure trees.

    When CTE isn't available, closure trees are nice, but boy howdy, does that closure tree table get gigantic with deeper graphs.

    If CTE is available, closure trees don't even come close in performance and simplicity.

    (Hint: materialized paths should use a unique separator: ASCII 0x1F is applicable: https://en.wikipedia.org/wiki/C0_and_C1_control_codes#Field_...)

  • Scout APM

    Truly a developer’s best friend. Scout APM is great for developers who want to find and fix performance issues in their applications. With Scout, we'll take care of the bugs so you can focus on building great things 🚀.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts