OT: MySQL Databases

[Richard]

Instar said:
I haven't read your problem at all, but I gotta say just ditch MySQL and download something else... you can get Oracle 10g or 9i for free, I think... maybe some licensing issues I dunno.
The devs of MySQL used to think that foreign keys were not needed... !!!!!
Sorry to be a purist, but Im a hardcore dev person and stuff like that just makes me angry

You can get Oracle 9 or 10 for free? What about support? The other thing that sucks is the lack of cheap tools to work with Oracle, except for TOAD which I hate....

I probably wouldn't change anytime soon, since mysql has done well for us, but I know Oracle is more performant and supports HA.

[Instar]

Richard said:

You can get Oracle 9 or 10 for free? What about support? The other thing that sucks is the lack of cheap tools to work with Oracle, except for TOAD which I hate....

I probably wouldn't change anytime soon, since mysql has done well for us, but I know Oracle is more performant and supports HA.

Well, MySQL is a valid relational database, and they have added foreign keys. Its just not natural to have devs that stupid; to think foreign keys are not needed.
As for Oracle being a free download, lemme find it...
http://www.oracle.com/technology/sof...10g/index.html

You can get it there. Support is limited at best, I would guess. But you could say the same about MySQL, it is open source, so support is whatever you can google or msn search for, unless you're willing to pay for it.

I'm not a DBA, but I can still rant about it... heh

[Fyron]

Instar said:
it is open source, so support is whatever you can google or msn search for, unless you're willing to pay for it.

Or whatever you can ask on free support forums, mailing lists, and/or IRC channels.