Close
  • Latest News
  • Artificial Intelligence
  • 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
  • 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

    By
    Lisa Vaas
    -
    September 27, 2005
    Share
    Facebook
    Twitter
    Linkedin

      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 is News Editor/Operations for eWEEK.com and also serves as editor of the Database topic center. Since 1995, she has also been a Webcast news show anchorperson and a reporter covering the IT industry. 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. Prior to becoming a journalist, Vaas experienced an array of eye-opening careers, including driving a cab in Boston, photographing cranky babies in shopping malls, selling cameras, typography and computer training. She stopped a hair short of finishing an M.A. in English at the University of Massachusetts in Boston. She earned a B.S. in Communications from Emerson College. She runs two open-mic reading series in Boston and currently keeps bees in her home in Mashpee, Mass.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.

      MOST POPULAR ARTICLES

      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
      Applications

      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
      IT Management

      Intuit’s Nhung Ho on AI for the...

      James Maguire - May 13, 2022 0
      I spoke with Nhung Ho, Vice President of AI at Intuit, about adoption of AI in the small and medium-sized business market, and how...
      Read more
      Cloud

      IGEL CEO Jed Ayres on Edge and...

      James Maguire - June 14, 2022 0
      I spoke with Jed Ayres, CEO of IGEL, about the endpoint sector, and an open source OS for the cloud; we also spoke about...
      Read more
      Applications

      Kyndryl’s Nicolas Sekkaki on Handling AI and...

      James Maguire - November 9, 2022 0
      I spoke with Nicolas Sekkaki, Group Practice Leader for Applications, Data and AI at Kyndryl, about how companies can boost both their AI and...
      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.
      © 2022 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.

      ×