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."

4 of 359 comments (clear)

  1. Re:Generic Web-Frontends for MySQL by FireFury03 · · Score: 5, Informative

    This is slightly off-topic, but I was wondering if anyone is aware of any generic web-frontends for MySQL?

    How about http://www.phpmyadmin.net/?

    --
    http://blog.nexusuk.org
  2. Re:stored procs and triggers, finally by User+956 · · Score: 5, Informative

    Almost every database out there impliments an ISO or similar SQL standard as it's base (SQL-92 in most cases). They then build on top of that by adding their own features, while still supporting the common SQL syntax. It's not about being a barebones implimentation of a standard, it's about supporting the standard as your base.

    PostgreSQL supports SQL-92, while adding it's own extra features (which describes most other databases like Oracle and MS SQL too), including the support of the "LIMIT" statement. MySQL doesn't support any standard base, instead existing as an arbitrary mish mash of standard and propritary SQL. It wasn't until the current version, 4, that MySQL even bothered to add support for UNION.

    With every other database you can start working safe in the knowledge that while having it's own extensions, you're working with a normal "SQL" database. MySQL, while posing as SQL, has little if anything in common (in particular see threads about optimization - getting fast code in MySQL means learning an entirely new system filled with quirks and vomit inducing workarounds to solve language faults)

    --
    The theory of relativity doesn't work right in Arkansas.
  3. Re:stored procs and triggers, finally by temojen · · Score: 5, Informative
    And if its in your code, the query executes using the resources of the machine running your code, as opposed to the resources of that (usually) bigged database server.

    This is so wrong it made my head explode. All queries are executed in the server. Stored procedures are compiled and optimized once (per connection, and most sites use connection pooling).

  4. Re:Almost caught up to MSSQL! by TheKubrix · · Score: 5, Informative

    I hope someone mods the parent down, because thats just stupid/ignorant.

    I've been running MS SQL 2000 for about 4 years now and it has NEVER crashed. Nor has it corrupted any data or any other such destruction.

    I notice that its people that either have _NO_ database experience tend to bash MSSQL, and they don't even know why. Your comment is a case in point.