Linked by David Adams on Thu 6th Jan 2005 06:09 UTC, submitted by Rahul Sundaram
Databases MySQL, at the end of January, is expected to release a beta version of its MySQL 5.0 open source database, which is to feature enterprise-level functionality such as stored procedures and triggers, according to a company representative.
Order by: Score:
PostgreSQL 8.0.0 Release Candidate 3
by Martin Langsjoen on Thu 6th Jan 2005 08:39 UTC

http://archives.postgresql.org/pgsql-announce/2005-01/msg00000.php

As was anticipated, time between Release Candidate 2 and 3 was nice and short, with more changes being made now to Documentation vs Code.

A current list of *known* supported platforms can be found at: http://developer.postgresql.org/supported-platforms.html

We're always looking to improve that list, so we encourage anyone that is running a platform not listed to please report on any success or failures with Release Candidate 3.

Baring *any* coding changes (documentation != code) over the next week or so, we *hope* that this will the final Release Candidate before Full Release, with that being aimed for the 15th (or earlier).

Foreign key
by TraxTech on Thu 6th Jan 2005 08:51 UTC

Then we could really use FOREIGN KEY ?

RE: Foreign Key
by pojo on Thu 6th Jan 2005 09:13 UTC

Yep! I've actually been using MySQL 5.0.0 alpha for a while now in Windows and I haven't experienced any instability (However, on Solaris I got some severe crashes when running some queries).

Unfortunately, I've not had much use for triggers or stored procedures, as the databases that I work on aren't nearly large enough to warrant their use.

@pojo
by AndrewG on Thu 6th Jan 2005 10:14 UTC

Are views in 5.0 or is that a 5.1 thing?

Thanks.

how about better SQL standards conformance??
by ceaser on Thu 6th Jan 2005 13:01 UTC

so what version can we expect proper SQL92 conformance? v8?

Enterprise-level????
by rycamor on Thu 6th Jan 2005 14:39 UTC

...enterprise-level functionality such as stored procedures and triggers

"Enterprise level" my eye. These are only a couple of the most basic features that any DBMS should have. Still missing, I'm sure, are such things as CHECK constraints, DOMAINs, schemas, transaction savepoints, point-in-time recovery, and user-defined datatypes. And this still ignores MySQL's most central problem--an inconsistent approach to its own fundamental datatypes).

Maybe MySQL will move into the enterprise domain with MaxDB (SAP DB), but it sure won't with MySQL 5.0. IMHO if MySQL really wants the 'enterprise', it should leave its basic MySQL DBMS as a 'lite' system, and concentrate on MaxDB, which at least was build from the ground up on serious DBMS concepts.

@AndrewG
by rycamor on Thu 6th Jan 2005 14:52 UTC

Yes, views are in 5.0 (http://dev.mysql.com/doc/mysql/en/CREATE_VIEW.html), but they are limited:

A view definition is subject to the following constraints:

* The SELECT statement cannot contain a subquery in the FROM clause.

...

* You cannot associate a trigger with a view.


Subqueries in the FROM clause are perhaps the most useful form of subquery (essentially they are anonymous relations). And the fact that you can't associate a trigger with a view severely limits the business logic you can express with a view.

@rycamor
by AndrewG on Thu 6th Jan 2005 17:53 UTC

Thanks.