Create an Account
username: password:
 
  MemeStreams Logo

Implementing An N-Level Nested Tree In PHP And PostgreSQL, Part 1 - PHP articles and PHP tutorials - PHP 5, MySQL, PostgreSQL, AJAX, Web 2.0

search

Lost
Picture of Lost
My Blog
My Profile
My Audience
My Sources
Send Me a Message

sponsored links

Lost's topics
Arts
Business
Games
Health and Wellness
Home and Garden
Miscellaneous
Current Events
Recreation
Local Information
Science
Society
Sports
Technology

support us

Get MemeStreams Stuff!


 
Implementing An N-Level Nested Tree In PHP And PostgreSQL, Part 1 - PHP articles and PHP tutorials - PHP 5, MySQL, PostgreSQL, AJAX, Web 2.0
Topic: Technology 3:02 pm EDT, Aug 28, 2008

Introduction

This series of articles is about implementing a nested tree using PHP and PostgreSQL. The theory and code in these articles also applies to MySQL, not just PostgreSQL.

An N-Level nested tree is a way to represent hierarchical data, such as a list of directories and files in your operating system, or the listings in a directory such as the Open Directory Project. There can be any number of levels and any number of elements within each level.

The goal is to be able lookup data in the tree as quickly as possible with minimal strain on resources. We will be implementing this using the nested tree model by Joe Celko.

Implementing An N-Level Nested Tree In PHP And PostgreSQL, Part 1 - PHP articles and PHP tutorials - PHP 5, MySQL, PostgreSQL, AJAX, Web 2.0



 
 
Powered By Industrial Memetics
RSS2.0