Slashdot Mirror

← Back to Stories (view on slashdot.org)

MySQL 5.0 Now Available for Production Use

Posted by Hemos on from the moving-into-the-big-time dept.

chicagoan writes "MySQL AB today announced the general availability of MySQL 5.0, the most significant product upgrade in the company's ten-year history. The major new version delivers advanced SQL standard-compliant features such as stored procedures, triggers, views & new pluggable storage engines. Over 30 enterprise platform and tool vendors have also expressed enthusiastic support for the new release of the world's most popular open source database."

2 of 359 comments (clear)

  1. Re:stored procs and triggers, finally by CastrTroy · · Score: 1, Flamebait

    You know, you bring up a good point. There's going to be a lot of people who disagree with you, but I think that what you say has a lot of fact. What they really need, is a way to include stored procedures in your code, so that queries can be run with the speed of a stored procedure, but still keeping the code for the stored procedure with the rest of your code. There's no reason why you couldn't have a language construct that says, i'm starting a stored procedure here, and then process that part to create a stored procedure.

    --

    Anthropic principle: We see the universe the way it is because if it were different we would not be here to see it.
  2. Re:Speed and simplicity. by commanderfoxtrot · · Score: 1, Flamebait

    Got to agree with you- VIEWS and triggers are great, but stored procedures are a real pain. However, they make triggers SO powerful (check out this blog entry on synchronising Apache passwords by one of the PostgreSQL developers).

    I'd really like to know how you are supposed to edit stored procedures without programs like phppgadmin.

    --
    http://blog.grcm.net/