Want better links on DZone? We do, too! Login and vote now.
By skoop
via akbkhome.com
Submitted: Jul 03 2009 / 09:34
Storing tree data in Mysql databases, is relatively common, however, all the existing documentation about doing this, makes the whole process rather complex.
If you google it, you will probably find the quite definitive answer at mysql.com, describing the classic parent_id method, and the left/right numbering process. Both of these methods involve rather complex SQL to fetch and update the tree.
In seeking a better solutions for a tree that was infrequently updated, but frequently queried, I thought I'd try seeing if I could write a few stored procedures to simplify the process.
-
Open source celebrates the freedom to leave
-
Mojito - Yahoo's NodeJS based Multi Device Application Framework
-
Tech guns for hire: 5 places to find skilled IT contractors
-
Yet Another Podcast #65 with Michael Crump
-
Start With ForkJoinPool :: Java's Map Reduce
-
Ajax AutoCompleteExtender TextBox In Master Page
Add your comment
