Models for hierarchical dataThe document discusses various models for storing and querying hierarchical data using SQL and PHP, highlighting the challenges associated with managing comments in threaded discussions. It details solutions like adjacency lists, path enumeration, nested sets, and closure tables, providing examples of their implementation. Each method has its own strengths and limitations when handling hierarchica
SQLアンチパターン - ナイーブツリー
