[Dbix-class] How I hate (some) DBAs

[John Napiorkowski]

----- Original Message ----
> From: Ian <dbix-class at iandocherty.com>
> To: Class user and developer list <dbix-class at lists.scsys.co.uk>
> Sent: Monday, August 3, 2009 1:49:03 AM
> Subject: [Dbix-class] How I hate (some) DBAs
> 
> Hi
> We are just coming to the end of our development with a (very) tight timescale 
> and pretty much on-time due to the use of DBIC and Catalyst.
> 
> Development was on MySQL but someone has now decided we have to run on Oracle. 
> OK, no problem we thought, it should migrate over with very few issues since we 
> are using DBIC.
> 
> However, the Oracle DBA has thrown his teddy out of the pram and refuses to 
> accept that DBIC can generate efficient code, or code that he can inspect, and 
> insists that we use an 'API' that he will show us how to create to use pl/sql 
> statements. From what I have seen of it, it will take me back about 10 years to 
> where I was trying to generate my own DB abstraction layer before I learned 
> about CDBI and DBIC. Argghh.

Is your application going to run in a shared Oracle cluster?  That could account for
the DBA being very touchy, since s/he might be worried about how the load of your
application will affect the other applications.  If so, try to demostrate load and
how you system impacts the site.

I can understand the whole "stored procedures are the API" thing.  It was a 
pretty normal way to introduce a layer between the database and the application
and would give the DBA more control.

Is your DBA under fire?  The economy is not so good and people are looking to
make sure they have work to do...

> 
> I have pointed out to the project manager that this will break everything we 
> have written so far. We will have to manually write all the code to do the heavy 
> lifting and shifting that DBIC does for us so easily. It is likely to take us at 
> least twice as long as it has already taken us to redevelop the whole 
> application to write the new database abstraction layer and modify our 
> application to use it.
> 
> Yes I can output the generated SQL from DBIC, but this does not satisfy our DBA.
> 
> How do other developers cope with these people? Are there any DBAs on here that 
> embrace DBIC that can give me any advice?
> 
> Regards
> Ian
> 
> 
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk