lianhechx/laravel-nestedset

Nested Set Model for Laravel
34
Install
composer require lianhechx/laravel-nestedset
Latest Version:0.1.0
PHP:>=5.5.9
License:MIT
Last Updated:Jan 24, 2017
Links: GitHub  ·  Packagist
Maintainer: lianhechx

This is a Laravel package for working with trees in relational databases.

What are nested sets?

Nested sets or Nested Set Model is a way to effectively store hierarchical data in a relational table. From wikipedia:

The nested set model is to number the nodes according to a tree traversal, which visits each node twice, assigning numbers in the order of visiting, and at both visits. This leaves two numbers for each node, which are stored as two attributes. Querying becomes inexpensive: hierarchy membership can be tested by comparing these numbers. Updating requires renumbering and is therefore expensive.