on Database Trees

This is more a note to myself, but it looks like the best tree option in a database is Recursive Query, at least in Postgres, which supports the WITH clause.

Closure Table is the next best option.