OOT: Postgre vs MySQL

Derek Broughton news at pointerstop.ca
Fri Oct 26 13:26:52 UTC 2007


Anthony Yarusso wrote:

> Gunawan wrote:
>> Hi All,
>> OOT little bit.
>> Which one better postgre or MySQL?
>>
> Depends how you define "better".

Doesn't it always :-)

> PostgreSQL is usually considered 
> lighter weight and faster,

And, afaict, more full-featured, but perhaps there are features in MySQL I
just haven't needed.

> but MySQL is often more widely supported.

Yes.
 
> Ultimately, it depends on what you're using it for.  If you're
> building your own system and speed is a concern, PG may be a good
> choice.  If you're using a CMS like WordPress, only MySQL is
> supported. 

If you want GIS (geographic) support - PostGre.

I run both, and mostly it's a toss-up which I use - except for the GIS
support :-)
-- 
derek





More information about the ubuntu-users mailing list