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

Ian dbix-class at iandocherty.com
Mon Aug 3 18:32:08 GMT 2009


John Napiorkowski wrote:
> 
> 
> 
> ----- 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.
> 
Yes I think this is part of the problem

> 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.
>
Control is the word here I think.

> Is your DBA under fire?  The economy is not so good and people are looking to
> make sure they have work to do...
No, I just think from talking to others that he is a difficult person to 
work with!
> 
>> 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
> 
> 
> 
>       
> 
> _______________________________________________
> 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
> 
> 




More information about the DBIx-Class mailing list