John Napiorkowski wrote:
----- Original Message ----
From: Ian <[email protected]>
To: Class user and developer list <[email protected]>
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/[email protected]
_______________________________________________
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/[email protected]
_______________________________________________
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/[email protected]
