[NTLUG:Discuss] MYSql vs. postgresql

[Bug Hunter]

  I got mysql up and running immediately.  I did queries immediately.  
Their manual is very good.  (I've had experience with Microsoft SQL, 
Informix (unix), Foxpro, btrieve, etc.)

  When I tried to get postgresql up and running, it was a total flop.  I 
was too stupid to be able to do a single query.  I spent several hours 
reading manual pages and trying to use the database.  I gave up.  This was 
on Mandrake, with the installed one that came with the distro.

  We use MySQL in our maildeflector project, and average about 50 queries 
per second, for months at a time.  No issues there.  About 1/3 of those 
queries are writes.

  Transactions are now part of MySQL, but we don't use them in our 
situation.

bug

On 17 Feb 2003, Wayne Dahl wrote:

> Hi guys.  My wife and I are considering starting a business and will
> need a database.  Any recommendations in the Linux realm?  What are the
> pros and cons of both MYSql and postgresql?  How hard are they to
> migrate to a different machine when hardware needs upgrading?  What
> about front end clients for each?  Since both are included in my distro
> (RH8.0), I would like your input before we begin setting things up.
> 
> Also, do you have any recommendations for companies that do web
> site/domain hosting and why (why this company as opposed to that
> company)?
> 
> Thanks again,
> 
> Wayne

-- 
---------------------------------
Sick and tired of spam?
Ask me about Mail Deflector!
http://www.maildeflector.com
---------------------------------