Re: 0.99999998 (was: Unknown SQL)

Roedy Green <roedy_at_mindprod.com> wrote in <f25ohto400jrqk6a6dnmgii10mh4ift01q_at_4ax.com>:

>I think the other thing that comes with ripe old age is realising the
>importance of validating the hell out of your data BEFORE letting it
>into the database. Cleaning it up later is much much harder. Not
>cleaning it up and standardising it to the max from the getgo is just
>begging for headaches down the line.
>
>Roedy Green, Canadian Mind Products
>Custom computer programming since 1963. Ready to take on new work.

IMHO, the thing to remember here is to centralize the validating of the data to the DBMS using domains, check clauses, foreign keys, and maybe stored procedures and triggers, etc. Unexperienced programmers that do this in the applications will find that a few versions later, one (or several) of the different applications will differ in their validation logic (or maybe one user forgot to upgrade), leading to maintenance headaches.

Programmers inexperienced with RDBMS often fail to do this.

-- 
/Per Schröder
http://developer.mimer.com