Hierarchical Data in MySQL

Managing a site structure, or any other structure, in a database often gets overlooked. It’s pretty simple and a common standard to use what’s called the Adjacency List Model without sitting down and thinking about other possible solutions. In this post I’ll talk about a different method of storing hierarchical data in a relational database.