Posts tagged “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 [...]
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 [...]
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 [...]
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” [...]