[Gllug] Introductions to Databases

[Sean Burlington]

Richard Huxton wrote:
> More up to date, but from PG's point of view of course:
> 
> http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL_2009
> 
> 

Nice document :-)


"The position of this paper is that when the two are compared using the 
high level of data integrity demanded by a serious transactional 
database application, the current generation PostgreSQL performs better 
than MySQL (particularly under heavy user loads and with complex queries)"

That sounds about right to me.

Postgres is what you want if you are using those features

But if you're using the database as a simple object storage system - 
mysql can be a lot faster

I've also found that many web developers have only ever used MySQL and 
they just aren't aware of what's odd about it - if you were to put them 
on another database they would carry on wring SQL as before ...


-- 

Sean Burlington

www.practicalweb.co.uk
company number 06427950
vat number 928 0444 24

0791 236 9476

-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug