What’s Going on With My Listing Script / Database

Posted by John Lockwood on May 3rd, 2007

I’ve made some progress with my database and listing script early this morning. 

I started supporting updates, which of course is necessary if the script is going to be useful for longer than about two weeks.  This also means that the software now supports listings going pending, sold, off the market, etc.  (I suspect there’s still a bug when they come back on the market, but that’s not a rocket science fix).

I fixed the format of the dates, which (Murphy is great, long live Murphy) had an impedance mismatch between what MLS cooked and MYSQL ate.  Also not rocket science.

I love saying “impedance mismatch”.  But you’re not truly a pedant until you say orthogonal.

Orthogonal.  There, it’s out of the way.

I went back about two months on the sold data, so it’s in there and ready to display.  I just need to add a display function or two.  It can’t link to the IDX system because the IDX system doesn’t care about solds.  So I’ve got a couple of hours (mythical man hours, not calendar hours) before I’ll be able to surface a working prototype or two.

I’m probably a couple of months away from building anything really cool with the pieces I’ve been assembling, but meantime I’m enjoying the opportunity to play with my mental blocks.