Article about closure_tree

[bodrovis]

Hello!

Recently I've written an article for Sitepoint http://www.sitepoint.com/nested-comments-rails/ about closure_tree gem and, specifically, how to create nested comments system with it. You might want to give a link to it somewhere in the Readme. And thanks for this cool gem :)

[seuros]

README is not a place for such things.

btw you should rename your indexes and correct your comments

   add_index :comment_hierarchies, [:ancestor_id, :descendant_id, :generations],
              :unique => true, :name => "tag_anc_desc_udx"  #<< you have comments not tags

[bodrovis]

Cool, thanks!

[mceachen]

I just read your article—it was very straightforward and ready to follow,
nice work!

I'll add a link to your article. I think it might help others use this gem.

[mceachen]

@bodrovis the biggest issue with ancestry isn't the project activity—it's that he's using a "materialized path". He's using a concatenated set of IDs in a string for tree management.

This approach is fine when you only have several hundred records, and your query can do table scans. It breaks down at higher scale, though.

The other approach is using a "nested set"—but that requires every tree update to touch half of the other rows in your tree table (worst case).

I think it might be interesting to add a benchmark in your article contrasting the performance of the three approaches.

[bodrovis]

@mceachen Oh, okay, I will try do some research :)

[seuros]

@bodrovis : https://github.com/mceachen/closure_tree/wiki look at the last link.

[mceachen]

@bodrovis I added the link in the FAQ section. Thanks again for writing that tutorial!

[bodrovis]

The pleasure was all mine :)