Mark Atwood (fallenpegasus) wrote,
Mark Atwood

The current gig, SQL stored procedures, and XPath

The client wants me to grind out a couple of hundred SQL stored procedures over the next handful of weeks. The app developers have given me a list of sprocs that they want, with parem and return values. The database designer has given me graphics of the schema he is designing. The idea is so the PHP app developers never have to know the schema or even how to do a SELECT, but they dont want to use any of the existing PHP ORMs, or to write an interface layer in PHP or Perl. This seems like a good idea at first glance, and a terrible idea on closer look. SQL stored procedures are not happy things to work with, and MySQL's implementation is, as they say, amusing. At least I talked the app developers out of handing me the params as XML strings, since as amusing as our sproc implementation is, our XPath implementation is even more so.

  • Post a new comment


    Comments allowed for friends only

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded