Tag Archives: MySQL

Displaying N-Deep Trees (Remember Your Algorithms Course?)

Often times when doing web development one has the need to categorize things. And not only basic categorization, n-deep hierarchical categorization. I’ve already discussed storage and retrieval of such data, but there comes a time when one needs to display this information.
Sometimes people build systems to only account for their current requirements. If the software [...]

Hierarchical Data With PHP and MySQL

I recently had fun with an all-to-common issue with SQL driven websites: hierarchical data. For those who don’t like big words, think trees. Other people have already discussed storage methods, and I would actually highly suggest you read the writeup if you haven’t already.
While it is fairly straightforward to deal with, in our case we [...]

Database Normalization and Design: Part II

(This is the sequal to my previous post, Database Normalization And Design: A Primer)

Database Normalization And Design: A Primer

I am by no means a database expert, such titles are best left to people like Peter Zaitsev and Vadim Tkachenko, however one of my co workers has been asking me for some help on how I come about my database designs, particularly issues concerning normal form.
Whlie I could spend several posts going over the [...]

MySQL Workbench 5 Beta (Or: WTF?)

So I’m setting up my windows PC at home (hooray compsci classes being an all Microsoft setup, requiring Visual Studio 2005), downloading the MySQL GUI tools, launching them to test when I notice that MySQL Workbench went through a HUGE overhaul. When I say huge I mean “It Actually Works Now And Looks Completely Different” [...]