Webinar: Models for Hierarchical Data in SQL and PHP

Tree-like data relationships are common, but working with trees in SQL usually requires awkward recursive queries. This talk describes alternative solutions for modeling hierarchical data that work for MySQL, including:

• Adjacency List
• Path Enumeration
• Nested Sets
• Closure Table

Code examples will demonstrate using the Closure Table in PHP, and offer guidelines for choosing one design over another.

WHEN: Feb 28 @ 9:00 AM PST

WATCH: Recorded webinar

PRESENTER: Bill Karwin