[Leaplist] curious about mysql vs postgres...

[Damien McKenna]

On Oct 1, 2008, at 9:13 PM, Fred Moore wrote:
>> MySQL Is easier to learn, but PostgreSQL is more powerful.
>>
> under what versions of MySQL, va Postgres and how is it more
> powerful?..

PostgreSQL has custom data types, a GIS plugin, and has had ACID  
compliance, triggers and procedural programming (using a variety of  
different embeddable languages) for a lot longer than MySQL.

MySQL's syntax has always seemed a little simpler, primarily when  
dealing with strings.

> I mostly thought standard SQL would work on either one..

Mostly.  PostgreSQL seems to need some extra work with strings, BICBW,  
I haven't used it as extensively as MySQL.

-- 
Damien McKenna - Husband, father, geek.
damien at mc-kenna.com - http://www.mc-kenna.com/


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.