1.7.6 MySQL 4.1, следующая ветка в разработке

MySQL 4.0 готовит базу для реализации новых возможностей в сервере MySQL 4.1 и более новых версиях. Имеются в виду такие возможности, как вложенные подзапросы (nested subqueries) (4.1), хранимые процедуры (5.0) и правила целостности ссылок (foreign key integrity rules) для MyISAM-таблиц (5.0).

Эти возможности возглавляют список наиболее востребованных нашими потребителями функций.

После реализации этих изменений критикам СУБД MySQL придется проявить больше изобретательности и придумать более убедительные аргументы, чем просто указание на недостающие функциональные возможности. Будучи давно известной как быстродействующая, надежная и легкая в использовании, СУБД MySQL теперь станет соответствовать ожиданиям самых требовательных потребителей.

User Comments

I am hoping that in addition to stored procedures, 5.0 will also implement views. Why? Because you cannot easily join the result sets of stored procedures, whereas it's trivial to join several views together and obtain meaningful multi-table joins.

Further, this approach facilitates the creation of what I call "molecular" queries -- queries built from "atomic" (i.e. one table) queries. Setting things up this way enables you to create one or two queries per table and then combine them into increasingly complex queries. Change one of the atomic queries and all dependent molecular queries "inherit" the change.

Just my $.02....
Arthur

At last...
I've been waiting for the nested queries...
Now MySQL in my point of view is just lacking Stored Procs.

My customers will soon be trilled as I now can finish migrating my system from M$SQL to MySQL...

Keep up the good work and don't make us wait too long for Stored Procs in 5.0 plz

Great show keep up the good work,

I hope some day you will be able to extend stored procedures with PHP or Java(tm). Or even make deamon like plugins for the server (kinda-like embedded, but the other way around!).

Wow . No other expression could describe my feelings.
IMHO, mySQL is really on the way to be THE alternativ also from the point of view from "decision makers". Every month, another argument to pay expensive licenses for M$SQL or Orcale and have anoying maintenance costs falls.
you're on the right way ! keep on !

Will be looking for DBSPACES similar to Informix DBSPACES or FILEGROUPS similar to SQL-Server2000. This would be useful in splitting up the data in to smaller, more manageable units, especially for large databases.

Yes - views would be at least as important as Stored Procedures, for the reasons alluded to by the previous poster.

One of the outstanding advantages of views is that they move the logic for data presentation from the compiled code into the database, making it cross-platform development and data evolution both much easier to manage. No need to hunt down and hack complex joins all over the code.

What's the max records can mysql include?

Inquiring Windows users want to know where are the 4.1 alpha binaries?!!Lets get the show on the road already:)

MySQL is doing great job. Feature of foreign key scheduled for ver 5.0 should be first priority and part of earlier versions.

Manu

Windows user:

It has been three weeks now I am constantly checking your site all I see is "Binaries will soon be available", how soon is soon?

Thank you MySQL !!!

About views and replication ...
something nice could be to have master views replicated as tables on slaves !!

That's definitly great new!
However for modern deployment, Unicode support is definitly required, views are very importants, stored procedures too, trigger would be nice.
Without Unicode and views, Postgres has still the upper hand, but MySQL is to be congratulated in their endeavor to distance MSSQL Server.
Nice job, continue your effort to become a relational database!

Unicode and replication are the things that are needed for the companies I work for to move from MS SQL Server.
The most of other things can be worked around with some programming.

Bring it oooon! When will 4.1 be production? I've been waiting soo long, my code is ready, but RedHat are advising against any upgrades until it becomes production. Pleeeeease tell us something :)

Zbynek ZDRAZIL
As to the comment from Mikio Okawa on Friday February 28 2003, @5:41pm, I expected the triger to be already inmplemented with version 4.0. Well, we've got to wait and keep up with an application level workaround. Hopefuly, this feature will come soon.

Add your own comment.