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.
Most of the time a DBMS is nothing more than a fast way to store large numbers of records and sort/search them quickly.
Many stock webservers from hosting providers come with nothing else than MySQL these days so you'd be screwed integrity-wise. I for one do not trust user input one bit and intend to validate and check it on as many occasions as reasonably possible. The integrity of the stored data is my own responsibility, so my own code is going to do the checking.
The DBMS can be a very good final line of defense against malformed input but ignoring the possibilities of javascript (extremely fast client side form validation) and server scripts (extremely flexible, able to correct many input errors) would seem to me a missed opportunity.
Most of the time a DBMS is nothing more than a fast way to store large numbers of records and sort/search them quickly.
Many stock webservers from hosting providers come with nothing else than MySQL these days so you'd be screwed integrity-wise. I for one do not trust user input one bit and intend to validate and check it on as many occasions as reasonably possible. The integrity of the stored data is my own responsibility, so my own code is going to do the checking.
The DBMS can be a very good final line of defense against malformed input but ignoring the possibilities of javascript (extremely fast client side form validation) and server scripts (extremely flexible, able to correct many input errors) would seem to me a missed opportunity.