From: Richard Huxton <dev@archonet.com>
To: Mirco D'Angelo <dangelo@isic.org>
To: pgsql-sql@postgresql.org
Subject: Re: newbie question
Date: Mon, 8 Jul 2002 17:49:48 +0100
Message-ID: <200207081749.48030.dev@archonet.com> (raw)
In-Reply-To: <3d28b996$1@news.swissonline.ch>
References: <3d28b996$1@news.swissonline.ch>
On Sunday 07 Jul 2002 10:59 pm, Mirco D'Angelo wrote:
> Hi
>
> I am going to learn MySql 'cause I have to, but would it be better, or
> let's say, more interesting, to learn postgressql? Is it newer, more
> common, etc.?
Mysql is more common on web-hosting platforms, but you can find PostgreSQL if
you look. PostgreSQL's ancestors go back further than MySQL - both get
updated regularly, so "newer" doesn't mean much.
Mysql is easier to setup initially, but both systems require knowledge to tune
properly. Both have a lot of online documentation - I'm not sure that one is
better than the other. The mailing lists for PostgreSQL are very helpful and
contain some very experienced people.
PostgreSQL offers some more advanced features. Once you are used to these
features it is irritating to find them missing in MySql. For some
applications they are pretty much mandatory. PostgreSQL also tends to fit
standards more than MySQL. Where I use MySQL behind a website I tend to use
PostgreSQL to manage the data here during development.
I'd recommend installing both if you can. Try to make sure anything you write
works on both and check the documentation for where both diverge from
standards.
- Richard Huxton
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, dangelo@isic.org
Subject: Re: newbie question
In-Reply-To: <200207081749.48030.dev@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox