[NTLUG:Discuss] MYSql vs. postgresql

[Jack Snodgrass]

On Mon, 2003-02-17 at 13:35, 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

MySQL -vs- postgres is a religious debate. Like FreeBSD -vs- Linux. 

I use MySQL and haven't had any problems with it. I did have a logic 
error in something I was doing and discovered that I had 1,000,000 
records in one of my tables. MySQL worked fine with that setup. 
The backup seemed to take longer than I expected and that's how I 
noticed that I hosed up something. 

I use MySQL on Linux. I use php to access it and I use VB on a 
windows box and a MySQL ODBC connection to do some stuff
from Windows. 

If SQL is involved, 99% of the freshmeat and sourceforge projects use
MySQL. I've seen very little that used postgres only. 

jack



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://ntlug.org/pipermail/discuss/attachments/20030217/00b96c72/attachment.html