[ale] MySQL training?

[Greg Sabino Mullane]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
 
 
> And, to be honest, most of the stuff we need doesn't especially need
> the likes of triggers, views, etc... and besides, I'm not too much of
> a fan of such things since my impression has been that the performance
> gains that they bring often come at the expensive of transparency and
> ease of deployment/porting/etc.  It may be ignorance on my part but I
> have a feeling that a lot of the pro-postgres/anti-mysql sentiment
> stems from a lack of understanding of mysql's new features (particularly
> in non-myisam databases) and from a general snobbishness about these
> things (which is the same snobbishness as tends to scorn PHP, etc.) .. :)
 
What happens when you grow and start to need some of those (I would argue
basic) features such as views and triggers? One of the major complaints
about MySQL is that they don't follow recognized standards and make a lot
of their own proprietary extensions to their products. Disliking that and
the lack of features is not snobbery, it's expecting a product calling
itself a RDBMS to act like a RDBMS.
 
You should also realize that MySQL is now only "free" for certain defined
circumstances. It is run by a single company, which (naturally) wants to
make money. As opposed to PostgreSQL, which is still (and should always be)
a completely volunteer effort, BSD-licensed and open-source.
 
> At any rate, in my environment I would say that MySQL was a pretty decent
> fit: there're more people here who understand it, and there's a greater
> potential base of people to come and hack away on it.
  
> I'm not in any way trying to incite any argument here; just noting that
> mysql is generally fine for the tasks I'm working on.. and I think it's
> generally better from a development standpoint to work with something you
> broadly understand rather than learning something else because it's
> "better".
  
Kind of like Windows and Linux, huh? <grin>
 
- --
Greg Sabino Mullane greg at turnstep.com
PGP Key: 0x14964AC8 200406151947
 
-----BEGIN PGP SIGNATURE-----
 
iD8DBQFAz4rrvJuQZxSWSsgRAjaZAJwOhc10rKfDZPpBM2Z/fyS2lOMzywCeLIfj
V0KBL937108PGxpxVGsolKE=
=CPdj
-----END PGP SIGNATURE-----