Boolean Soup Work (Frimkron's Worklog)
Frimkron's rant 
File update manager
I've finally finished the module I was working on - the one for recording who's working on what website files. I know it sounds pointlessly time consuming, but it really was needed. We were mixing up file versions all over the place and re-introducing bugs we'd already fixed and stuff. But not any more!
It was interesting to write. I decided to explore the joys of the nested set model (link 1, link 2) for storing the file tree in the database. Its a cool way of doing things in terms of optimising your page queries, especially for things like obtaining a breadcrumb trail through your category tree (one query). But I'd say its main disadvantage compared to the adjacency list model is the way its so awkward to maintain its integrity and its easily corruptable if you start adding or removing table rows by hand.
Anyway. Onto the next job...
It was interesting to write. I decided to explore the joys of the nested set model (link 1, link 2) for storing the file tree in the database. Its a cool way of doing things in terms of optimising your page queries, especially for things like obtaining a breadcrumb trail through your category tree (one query). But I'd say its main disadvantage compared to the adjacency list model is the way its so awkward to maintain its integrity and its easily corruptable if you start adding or removing table rows by hand.
Anyway. Onto the next job...
(Posted on March, 24th 2006, 22:44)