Saturday, March 11, 2006

A little look ahead to MySQL 5.2

This topic seems to come quite early - MySQL 5.0 (as GA release) is not even half a year old and MySQL 5.1 has just turned into beta.

But I've heard that MySQL 5.1 will be quite a quick release, so MySQL 5.2 is maybe not that far away.

So it could be a good moment to start to talk about the features that could be in MySQL 5.2. Some plans have already been published:

http://dev.mysql.com/doc/refman/5.1/en/mysql-5-2-plans.html
http://blog.arabx.com.au/?p=111

(if you know more sources, please add them as comments ;-))

Maybe, someone could create a new forum where people can discuss what they would like to see inside MySQL 5.2. I'm sure, many people inside the MySQL Community (me included) have their favourite features.
at

3 comments:

  1. Anonymous09:54

    My wishlist, aside from what is planned already, from the top of my head in no particular order:
    - multiple roles per user
    - ability to name PK's something else than PRIMARY
    - smarten up the query planner for subqueries
    - letting the user define on what to cluster
    - true CHECK constraints
    - storage LOBs in separate pages
    - expressions in indexes

    ReplyDelete
  2. rpbouman15:26

    Hi Markus,

    this would be my shortlist

    -error handling improvements (SIGNAL, DIAGNOSTICS)
    -declarative CHECK constraints
    -the PARAMETERS and REFERENTIAL_CONSTRAINTS information_schema views
    -FOREIGN KEYs independant of storage engine
    -UPDATE: lift the limitation for subqueries on the same table that is being updated ;-)
    -

    ReplyDelete
  3. Anonymous19:51

    Almost forgot one more:
    - materialized views :-)

    ReplyDelete