Close
  • Latest News
  • Artificial Intelligence
  • Video
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Artificial Intelligence
  • Video
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Applications
    • Applications
    • Database
    • Servers

    MySQL Releases Most Ambitious Database Yet

    Written by

    Lisa Vaas
    Published September 27, 2005
    Share
    Facebook
    Twitter
    Linkedin

      eWEEK content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More.

      MySQL AB has announced the first release candidate of its most ambitious open-source database version to date.

      The version, 5.0.0, has been under development for some three years. It delivers new ANSI SQL features, some of which have never before been seen in the database.

      These new features include both read-only and updated views, stored procedures and stored functions that rely on the SQL:2003 syntax also used by IBM DB2, row-level triggers, and both read-only and non-scrolling server-side cursors.

      “Implementing ANSI SQL standard ways of using existing MySQL features means there will be fewer unpleasant surprises (“gotchas”) for those migrating to MySQL from other database systems,” wrote MySQL Vice President of Community Relations Kaj Arnö on the companys site.

      /zimages/5/28571.gifClick here to read more about Sun launching StarOffice 8.

      For example, Arnö said, MySQL 5.0 adds a mode that enables strict data-type checking. Thus, the database will issue errors for invalid dates, numbers and strings.

      Brian “Krow” Aker, a MySQL employee, wrote in a Slashdot posting that the company has resolved issues with bad data inserts, which “personally annoyed the hell out of me when we rewrote Slashdot a couple of years back, so I am happy to see this issue go away.”

      Other goodies include an ANSI SQL-compliant Data Dictionary to access metadata and a new library for arithmetic that will give high accuracy on financial and mathematical operations.

      MySQL 5.0 also packs new storage engines, tools and extensions. For example, the Archive Storage Engine is designed for storing large amounts of data without indexes in a very small footprint. Thats intended to handle historical data to keep enterprises in compliance with audits, such as with Sarbanes-Oxley regulations.

      Also, 5.0s Federated Storage Engine is geared to accessing data in tables of remote databases, as opposed to in local tables (only available in the MAX version).

      MySQL 5.0 also includes an Instance Manager tool for starting and stopping the MySQL Server, whether locally or remotely.

      More details on whats new in 5.0 are available here.

      At this point, 5.0 is stable enough that MySQL hasnt received a “significant inflow” of bugs that impacted a large number of users in a while, Arnö wrote.

      /zimages/5/28571.gifClick here to read more about Microsoft and JBoss team up on interoperability.

      Still, MySQL is hoping the open-source community keeps finding bugs, and its offering prizes to spur on the hunt. For those who deliver the most valuable feedback, the company is giving away Apple iPod Nanos or full conference passes to its 2006 MySQL Users Conference.

      “We recognize we havent crossed the finish line yet, so we still very much need your involvement to ensure that MySQL 5.0 is the best that it possibly can be,” Arnö said. “To show our appreciation for your efforts, well be fixing the bugs you find as fast as we can.”

      MySQL 5.0 can be downloaded here.

      /zimages/5/28571.gifCheck out eWEEK.coms for the latest database news, reviews and analysis.

      Lisa Vaas
      Lisa Vaas
      Lisa Vaas is News Editor/Operations for eWEEK.com and also serves as editor of the Database topic center. She has focused on customer relationship management technology, IT salaries and careers, effects of the H1-B visa on the technology workforce, wireless technology, security, and, most recently, databases and the technologies that touch upon them. Her articles have appeared in eWEEK's print edition, on eWEEK.com, and in the startup IT magazine PC Connection.

      Get the Free Newsletter!

      Subscribe to Daily Tech Insider for top news, trends & analysis

      Get the Free Newsletter!

      Subscribe to Daily Tech Insider for top news, trends & analysis

      MOST POPULAR ARTICLES

      Artificial Intelligence

      9 Best AI 3D Generators You Need...

      Sam Rinko - June 25, 2024 0
      AI 3D Generators are powerful tools for many different industries. Discover the best AI 3D Generators, and learn which is best for your specific use case.
      Read more
      Cloud

      RingCentral Expands Its Collaboration Platform

      Zeus Kerravala - November 22, 2023 0
      RingCentral adds AI-enabled contact center and hybrid event products to its suite of collaboration services.
      Read more
      Artificial Intelligence

      8 Best AI Data Analytics Software &...

      Aminu Abdullahi - January 18, 2024 0
      Learn the top AI data analytics software to use. Compare AI data analytics solutions & features to make the best choice for your business.
      Read more
      Latest News

      Zeus Kerravala on Networking: Multicloud, 5G, and...

      James Maguire - December 16, 2022 0
      I spoke with Zeus Kerravala, industry analyst at ZK Research, about the rapid changes in enterprise networking, as tech advances and digital transformation prompt...
      Read more
      Video

      Datadog President Amit Agarwal on Trends in...

      James Maguire - November 11, 2022 0
      I spoke with Amit Agarwal, President of Datadog, about infrastructure observability, from current trends to key challenges to the future of this rapidly growing...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2024 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×