Lockwood Real Estate

  • Search
  • Home Value
  • Foreclosures
  • Email Listings
  • Advice
  • About
  • Contact Us

Blog

03 May

What’s Going on With My Listing Script / Database

Posted May 3rd, 2007 | View Comments

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.

blog comments powered by Disqus
Search Sacramento Area MLS

Keep Up To Date

  • Subscribe via RSS Free updates via a Reader
  • Subscribe via Email Free updates via Email
  • Twitter Updates Follow me on Twitter
  • Facebook Page Become a Fan

Recent Posts

  • Actualización de mercado Bienes Raíces sacramento – Perdición, Melancolía y Adquisición de Vivienda
    August 15th, 2011

  • Google+ Comes to Sacramento Real Estate Site (Watch for my Mug on Google)
    August 8th, 2011

  • Sacramento Real Estate Market Update – Doom, Gloom, and Housing Affordability
    July 27th, 2011

Popular Posts

  • Sacramento Home Prices Rose Again in February
    March 8th, 2006

  • CONTEST — Pick The Best Sign
    February 28th, 2007

  • Are Short Sales Fake Listings? Part 1
    May 14th, 2008

Browse local areas: Sacramento County | El Dorado County | Placer County

Visit us on Google+

John Lockwood Associates. DRE License #01768758. Information in this web site comes from multiple sources and is believed accurate but has not been verified.

Copyright © 2012 John Lockwood Associates. All rights reserved.