MySQL v PostgreSQL

[stek]

Just to throw a spanner in the works and not really relevant - but my Oracle DBA pals ridicule DB2 summert raw, how does DB2 fit in the Proper Oracle, MySQL, Postgres scheme of things? Separate topic if admin wants to split off...

 

[NickFitz]

What MySQL GUI? I command line when I have to but over the last couple of years have been using SQLyog - can't live without it now.

MySQL Workbench. It's not too bad once you get used to it - much more stable than the old MySQL Administrator/MySQL Query Browser two-app combination.

 

[d000hg]

Nick (or anyone) is Visual Studio - including the free DB Express version - any good for MySQL?

 

[NickFitz]

Nick (or anyone) is Visual Studio - including the free DB Express version - any good for MySQL?

Never tried it myself - I only ever run VS (or indeed Windows) for brief sessions testing stuff in IE.

Anyone?

 

[darmstadt]

Just to throw a spanner in the works and not really relevant - but my Oracle DBA pals ridicule DB2 summert raw, how does DB2 fit in the Proper Oracle, MySQL, Postgres scheme of things? Separate topic if admin wants to split off...

Ah but if you're talking really big computers then you'll find most of them are either running DB2 or Adabas, Oracle are nowadays just a bit player (I've used on them) and either too damn expensive or non-existent support.

 

[d000hg]

I don't know Oracle would want to be discussed as competitors to MySQL... I thought Oracle and MSSQL were competing at the medium-high level with DB2 above them. However I've never actually come across a project using DB2 so who knows.

Not a dig at MySQL though - merely commenting that "medium high" in DB terms is pretty gigantic these days.