From: Conor Daly (conor.daly at domain oceanfree.net)
Date: Fri 13 Sep 2002 - 15:00:02 IST
On Fri, Sep 13, 2002 at 12:25:55PM +0100 or so it is rumoured hereabouts,
kevin lyda thought:
> otoh if you have hardcore db programmers they'll be annoyed that mysql is
> missing all the things they drool over - stored procedures and all that.
> mysql does offer table types that are acid (another one of those db
> programmer things).
We have tried very hard over the years to keep away from the "extensions"
that might change from DBMS to DBMS. Our scripting is exclusively C
shell, our procrams are strictly ANSI C (plus the embedded SQL libs), we
*don't* do stored procedures. All in the interest of being able to
migrate (more) easily... As for the programmers, There are about 5 of us
and we won't cry over stuff like that. The DB is essentially a big
repository of data that we use SQL on and that's about it.
> as for oracle, well. kate said it all. i think a person buying oracle
> in a world where mysql and postgres exist is pretty much criminally
> negligent. some companies or applications require it so it just has
> to be done, but the fact is that it's total crap. i don't think i can
> stress that enough.
I'm not experienced enough (yet) to force a move to an Open Source DBMS
*unless* we can buy a support contract for it. They *will not* run a
system without a support contract and, for onc, I agree. We are a small
enough organisation that we cannot spare the resources to fix something if
it fails, we must be able to pick up the phone and say "fix it".
Mind you, it looks like we'll have to sign up for 3 more years with ingres
so there might be time to work out something good with postgresql or mysql
yet. As Niall mentioned, it's a bit late to move when the gougers are
knocking on the door...
-- Conor Daly <conor.daly at domain oceanfree.net> Domestic Sysadmin :-) --------------------- Faenor.cod.ie 2:48pm up 13 days, 19:16, 0 users, load average: 0.08, 0.02, 0.01 Hobbiton.cod.ie 2:47pm up 13 days, 18:56, 1 user, load average: 0.24, 0.18, 0.12
This archive was generated by hypermail 2.1.6 : Thu 06 Feb 2003 - 13:18:50 GMT