Re: [cobalt-users] PostgreSQL InterBase MySQL

["Steve Werby" <steve-lists@xxxxxxxxxxxx>]

"Zhang Shiping" <zhangshiping@xxxxxxxxx> wrote:
> It looks like MySQL is more popular than PostgreSQL
> and InterBase.

That depends who you ask.  I don't use InterBase, but I use both MySQL and
PostgreSQL pretty heavily.  My rule of thumb is to use MySQL unless the
project has needs that are better served by using PostgreSQL.  PostgreSQL
has some functionality that MySQL doesn't have like subselects and stored
procedures, but IMO it's more difficult to administer a PostgreSQL server,
the learning curve for clients and other developers is steeper and there is
less open source software designed to work with PostgreSQL and fewer skilled
developers who work with it.

> Then why RaQ4 and RaQ550 are only
> bundled with PostgreSQL and InterBase. MySQL users
> have to install seperately?

I thought the spec sheet showed it had MySQL pre-installed.  I don't have
access to a 550.  If you have access to a 550 please verify whether MySQL is
installed.  rpm -qa | grep -i mysql, locate mysql, and ps aux mysql will
probably point you in the right direction.

> I want to start using database. Which of the three
> database is a better choice?

Describe the project and your experience with databases and I'll give you my
opinion.  If you're new to databases I'd say MySQL, but my true answer will
depend on the details you share.

--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/