Re: Help, my developers are killing me with varchar2(4000)

From: <>
Date: Tue, 29 Jul 2008 06:17:18 -0700 (PDT)
Message-ID: <>

> OMG - are som eof our developers working for you as well?


> I think part of the problem here is that many, particularly young and
> often web oriented developers just use the database as a 'bit
> bucket'.

> I think essentially, it is a combination of laziness (can't be bothered
> actually doing any formal analysis and data modeling) and ignorance
> (don't even understand when I try to explain why its bad design).

Often it is laziness. Sometimes ingnorance, and when I explain, they are usually happy to go by any recommendations that I made. However, I think in this case, the developers are under a deadline and they don't want to take the time to get the correct specs, or are afraid to pester the customer/end user with questions. They said "these were the design requirements provided." Like I am sure the administrators said "make every field varchar2(4000)." They don't even know what a datatype is.

> A big part of the problem is lack of experience.

True, we usually hire beginners because they are the only ones that accept the salary that is offered.

> All I can suggest is to keep pushing your case and don't get too
> frustrated when you can't get any support for your arguments. If your
> really really into frustration and pain, start talking about the
> benefits of developers using things like dbms_application_info and
> providing some help to the DBAs who keep getting hassled to solve
> performance problems etc. I'm not a DBA BTW.
> Tim
> --
> tcross (at) rapttech dot com dot au
Received on Tue Jul 29 2008 - 08:17:18 CDT

Original text of this message