[ale] RedHat Dabase 2.0

[Mike Millson]

Ben,

Since we're on the subject, I have a couple of questions about Postgres:
1) Can you do regular expression pattern matches like you can in MySQL?
2) Does it have any SQL extensions to handle hierarchical queries like
Oracle has?

Thank you,
Mike

-----Original Message-----
From: Benjamin Scherrey [mailto:scherrey at proteus-tech.com]
To: ale at ale.org
Sent: Wednesday, October 30, 2002 3:29 PM
To: ale at ale.org
Cc: John Wells; terry at esc1.com
Subject: Re: [ale] RedHat Dabase 2.0


MySQL is not really an RDBMS. That said - recent versions have had all kinds
of things added to it
to provide better transaction handling and such but they aren't integral
with the architecture.
MySQL is a fine product for fast-loading, read-mostly databases (typical of
many web-based apps
which it often appears). If you're updating data very much then you start
working around the
product instead of within it - not a situation you wanna be in if you can
avoid it. Multi-user and highly
transactional apps are still best avoided with MySQL in my experience.
FWIW - Postgres is just as
simple to setup and will scale better for these applications. It also
integrates cleaner with other
tools/languages including C++, java, and python.

	best regards,

		Ben Scherrey

10/30/2002 3:14:16 PM, "John Wells" <jb at sourceillustrated.com> wrote:

>How does Postgres compare with MySql?  I believe it support stored
>procedures, but other than that I'm unaware of what features it may have
>the make a good choice.
>
>Thanks,
>
>John





---
This message has been sent through the ALE general discussion list.
See http://www.ale.org/mailing-lists.shtml for more info. Problems should be
sent to listmaster at ale dot org.



---
This message has been sent through the ALE general discussion list.
See http://www.ale.org/mailing-lists.shtml for more info. Problems should be 
sent to listmaster at ale dot org.