[NTLUG:Discuss] MYSql vs. postgresql

[greg@turnstep.com]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> It appears to me that the primary advantage of Mysql is performance;
> it's faster for some types of operations, typically reads, and most
> DB's do a lot more reads than writes.

I would even argue this point. At one time, Postgres was indeed fairly 
slow, but it has come a long way in the last few years, and I doubt 
that there is any serious speed differences at this point - as long 
as you are measuring the same things. MySQL is much faster, but only 
when you use their "in-memory" tables without transactions. And 
if you are not going to use transactions, you are probably better 
off just using Berkeley DB or flat files.

MySQL is great for very simple projects, but you will probably outgrow it 
the moment you need to do some serious database work (transactions, 
table locking, subselects, stored procedures, triggers, etc.).


- --
Greg Sabino Mullane greg at turnstep.com
PGP Key: 0x14964AC8 200302211140

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE+Vlb3vJuQZxSWSsgRAgA3AJ9rbyN4D6AXyPWp2Cu+eV5w5rH2KQCgriwk
pH/J1+yWSUbSCMD3HJXR2H4=
=F2yW
-----END PGP SIGNATURE-----