Linked by Eugenia Loli-Queru on Thu 17th Jun 2004 21:11 UTC
Original OSNews Interviews Today we features a mini-Q&A with Alex Roedling, MySQL's Senior Product Manager, about all things MySQL, the competition, technology, licensing and more.
Permalink for comment
To read all comments associated with this story, please click here.
RE: MySQL Gotchas
by Bas on Fri 18th Jun 2004 14:41 UTC

In response to Steven Haryanto: the examples you give can be caught in application code. One thing I have learned through experience is to never trust a backend product to cleanly enforce its limits. Storing bad data (as you say MySQL does) is worse than storing nothing at all while returning an error, so in my view MySQL must change but not for the reasons you state.

It is the responsibility of the developer who creates an application that makes use of MySQL to properly handle errors and validate inputs before they go into any sort of storage. It's not that much extra work to do proper range checking in languages like PHP.