« What A Fabulously Odd Day | Main | Notes for the future -- Installing cvs2svn on a Mac »

Database News

Looks like the Shakespeare database is coming to fruition.

The sections are in place, in their own table. The hierarchy is good and simple, maintained with the sections table. I think that might change, dealing with hierarchical data in SQL is never easy. The links are all there, in the correct section. Getting here wasn't easy.

The previous database is a perfect example of the need for normalization. The section names had varying degrees capitalization (Gateways and gateways), even though they are the same section. On a first run through, there were two sections created: a bad thing!

I've put up a test page, to view the database structure and information in it. PHP seems to handle simple recursion quite well, which makes dealing with trees a lot easier. The test page even has some fancy-schmancy javascript to make browsing easier. It can show and hide sections of the page to make navigating down the tree much easier.

All things considered, I'm surprised by how easy it has been to put this database together thus far. KNOCK ON WOOD and all that. I might have to rethink my eternal hatred of PHP, and dislike of javascript.

About

This page contains a single entry from the blog posted on May 3, 2005 4:07 PM.

The previous post in this blog was What A Fabulously Odd Day.

The next post in this blog is Notes for the future -- Installing cvs2svn on a Mac.

Many more can be found on the main index page or by looking through the archives.

Powered by
Movable Type 3.33