tasty dogfood

part of my focus for the next couple of weeks will be on rolling out some improvements to the mysql bugs system. the first step in doing that was to upgrade from mysql 4.1 to the latest mysql 5.1 beta, which turned out to be entirely painless.

the next step is going to be some database normalization and code refactoring. but because there are some other people who have written ad-hoc tools against the existing schema, i’ll be hiding the schema changes behind some views.

the first big schema change will be moving the categories from a bunch of hard-coded strings in the source code (and a varchar(32) field) to a table organized using the nested set model. that’s something i’ve been wanting to do for years.

» mysql, work, bugs
« blame canadasummer 1990, dresden and prague »

comments

Yay!

better schema for bugs system would be great!

glad it's running on 5.1 too - can now do all sorts of cool things :)

» Stewart Smith (link) » june 21, 2006 8:34pm

Hi Jim,

Are you guys planning on contributing changes back upstream to bugs.php.net?

» Jacques Marneweck (link) » june 23, 2006 10:48am

not really. we’ve already diverged quite far from php.net’s system, and it is generally structured to fit our workflow, which is quite different from the php project’s.

but i will work on making our code available so people can bring over functionality they think would be useful.

» jim (link) » june 23, 2006 10:56am

this entry is closed to new comments.