[Leaplist] curious about mysql vs postgres...

[Jason Boxman]

Aaron Morrison wrote:
> 
<snip>
> 
> Inflict yourself with learning the SQL language itself and database 
> design.  No features of a SQL server will overcome a poorly designed 
> database. That is where you'll be spending most of your time anyway.

Yep.  SQL is one of those areas where Google is seemingly worthless.  I 
am fairly certain you simply need to buy a book or two on relational 
database theory.  Google can hobble you by, but it's hard to find good 
examples of complex queries and why they behave the way they do on the Web.

> Either system will do.

MySQL has a dubious history of mangling data silently under some 
conditions.  I'd never trust it with my data.  Everyone values their 
data differently, though.


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