[clue-tech] Re: foreign keys in phpmyadmin

[Nate Duehr]

Greg Knaddison wrote:
> On 1/25/06, Jack Parker <jack.parker4 at verizon.net> wrote:
>> Must have ignored this discussion.  But as a database wonk, I should chime
>> in.
> 
> I think you've got a typo there - you said "wonk" but I think you
> really mean "troll".

Only if you don't like his choice.  ;-)

> There are lots of databases.  They are complex.  Making claims like
> "no way to tune performance" based upon limited or no interaction is
> not really helpful when researched claims on the engines have already
> been made.

References please.  What you so upset about?

> I agree with your list of databases worth investigating - but only
> depending on the goals of the project.  E.g. why mess with Netezza if
> you only need a couple million rows?

Why use a DB at all?  :-)

That's an app design question.

It wasn't a posting about design, it was a posting from a completely 
sysadmin standpoint.

I appreciated his candor even if it was hasty.  You really didn't need 
to attack him for it.  Just read between the lines.

When someone posts a "quickie" like that, it usually really means 
"performance tuning on this particular DB looked like it was a giant 
pain in the ass, so instead of wasting time with it, or studying it for 
six months, I used this other one which was much more sane/intuitive."

DBA's are lovers of minutia, but this was just a posting with a "general 
feel" for how well someone could "get something done" in different 
databases out there.  Many not mentioned often in Linux circles...

(As I'd mentioned, I'd forgotten that there was an Informix version for 
Linux.  His post was a good reminder.)

There's also something to be said for a DB that's so intuitive that 
someone in a hurry (like the poster seemed to be), can just "get stuff 
done" on it while still having lots of "big DB" features.  Informix 
tends to fall into that realm.

Good quality, good performance, sane tools... unlike certain DB's that 
start with O that will require someone pulling down some serious money 
and with a very large brain to tweak and tune and make it sing and 
dance.  Big O being made up of "bolt-ons"?... absolutely.

What bothered you about his posting -- that he didn't do a complete 
application design process in a five minute e-mail?  'Cause I'm confused 
about what the problem was.

Nate
_______________________________________________
CLUE-tech mailing list
CLUE-tech at cluedenver.org
http://cluedenver.org/mailman/listinfo/clue-tech