News for hackers. Stuff that matters.
Re:Dammit, MySQL by tomjen3 on Thursday July 22, 2010 @07:06PM (#1539834)
I made the same argument to my database teacher. He pointed out that isn't going to do you much good when you have more than one application talking to your database, since you would then have to write the code to validate it in each application.
Re:Dammit, MySQL by ryanpetrich on Thursday July 22, 2010 @07:46PM (#1539922)
Better yet, require that all applications call through some common API (such as a library or web service) to access the data.
Re:Dammit, MySQL by electrum on Friday July 23, 2010 @02:16AM (#1540508)
Why not put that API inside the database (i.e. stored procedures and views)?
Re:Dammit, MySQL by ora600 on Thursday July 22, 2010 @08:00PM (#1539958)
You can require this, but its tricky to enforce. Especially on DBAs.