SCOUG-HELP Mailing List Archives

Date:	Sat, 3 Nov 2001 09:31:47 PDT
From:	"Steven Levine" <steve53@earthlink.net >
Reply-To:	scoug-help@scoug.com
To:	"SCOUG Help" <scoug-help@scoug.com >
Subject:	SCOUG-Help: Databases (was SCOUG-BOD: Nov topic)

=====================================================
If you are responding to someone asking for help who
may not be a member of this list, be sure to use the
REPLY TO ALL feature of your email program.
=====================================================

In <3BE3912A.3AFC@peterskye.com>, on 11/02/01
at 10:40 PM, Peter Skye said:

>Probably wrong list for the following question (bounce it over to Help if
>you want), but: What do you find lacking in PostGres and MySQL? (I'm
>told MySQL doesn't have rollback.)

The basics are there in both. As you say, mySQL is missing transaction
support, which in my book is a core part of what makes a datebase as
database, rather than a file manager. I consider anything that uses .dbf
files as a core a file manager.

Neither appears to be fully SQL standards compliant yet. They are missing
things likes nested selects etc.

That said, they are fine tools if your query needs are simple and you can
affort the lack of error recovery.

Steven

--
----------------------------------------------------------------
"Steven Levine" MR2/ICE 2.29g #10183 Warp4/FP11.5
www.scoug.com irc.webbnet.org #scoug (Wed 7pm PST)
----------------------------------------------------------------

=====================================================

To unsubscribe from this list, send an email message
to "steward@scoug.com". In the body of the message,
put the command "unsubscribe scoug-help".

For problems, contact the list owner at
"rollin@scoug.com".

=====================================================

Return to [ 03 | November | 2001 ]

SCOUG, Warp Expo West, and Warpfest are trademarks of the Southern California OS/2 User Group. OS/2, Workplace Shell, and IBM are registered trademarks of International Business Machines Corporation. All other trademarks remain the property of their respective owners.