Re: [cobalt-users] PostgreSQL InterBase MySQL

["Joel Baker" <news@xxxxxxxxxxxxx>]

""Steve Werby"" <steve-lists@xxxxxxxxxxxx> wrote in message
news:<>...
|
 Phil and others, if you intend to use PostgreSQL, I recommend installing an
| additional copy and running it on a different port.  That way you do not
| interfere with the install used by the GUI.  Just like there are many good
| web scripting languages, there are many good databases.  I suggest that
| anyone who is unsure which to use post criteria so list members can
| recommend one that's appropriate and list the relevant pros/cons.
Otherwise
| this type of thread just morphs into a holy war.
|

I agree. On that note:

PostgreSQL has support for transactions, which is very nice and is ACID
compliant. (ACID basically means it has good data integrity). It also has
support for more complex object-orientated setups (I think SQL-99 standard,
though I'm not too sure - haven't used these features myself).

MySQL has a very nice full text search engine built in. PostgreSQL has full
text search addons that don't seem to be so integral or good.

Hope that helps,

Joel Baker.