January 14th, 2004


brilliance in database design

"Rent maximum: 500"

And, among a bunch of houses that are 450-500, it returns several houses with a rent of 200 . . . well, that's pretty good, right?

Nope. Because those are referring to *weekly* rent, not *monthly*. In fact they've even got a field labeled "rent type", which is either "monthly" or "weekly" (usually . . . there's a "4 week" also).

Sorta makes the search not quite as useful, though, doesn't it?