Log in

No account? Create an account
entries friends calendar profile My Website Previous Previous Next Next
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.
Leave a comment