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 Latest News
    • Servers

    PostgreSQL, MySQL Tweak Their Wares

    By
    Lisa Vaas
    -
    November 27, 2002
    Share
    Facebook
    Twitter
    Linkedin

      Two of the leading open-source database vendors, MySQL AB and PostgreSQL Inc., are making bids for the enterprise with new features and support.

      MySQL, of Uppsala, Sweden, next week will announce support for IBMs zSeries servers running the Linux and AIX operating systems.

      Such support has been available to open-source users for some time, but MySQLs formal announcement reassures the thousands of enterprises that run databases on IBM technology that their DBAs (database administrators) will have someplace to turn to for backup. “We have a habit of formalizing support for platforms so conservative companies will know its supported and they can come to us for any problems,” said Marten Mickos, MySQLs CEO.

      MySQL Pro costs $395 per server. Pricing for annual support contracts starts at $2,500.

      Jason Jacobs, CEO of CoreSense Inc., a New York company that makes e-business software for resellers and manufacturers, said that even though hes not running MySQL on IBM hardware, the IBM support is still welcome because it broadens the pool of users contributing to open-source enhancements. “The larger the user group, the better for all of us,” he said. “[Enterprises are] going to look for something to be supported, in order to bet their business on it.”

      For its part, PostgreSQL, of Wolfville, Nova Scotia, on Wednesday rolled out PostgreSQL 7.3. Major new features include the addition of SQL schemas, which allows users to create objects in separate namespaces, so multiple people can have tables with the same name in a database. This facilitates mobile users working in the same database. Also new is a public schema for shared tables. Table/index creation can be restricted by removing permissions on the public schema.

      PostgreSQL 7.3 also can return record sets and prepared queries—features that appeal to power users. Also, table functions that return multiple rows and/or multiple columns are now easier to use. Users can call a table function in the SELECT FROM clause, treating its output like a table. A full list of new features in 7.3 appear on PostgreSQLs Web site.

      Bruce Momjian, a lead member of the PostgreSQL 7.3 development team, said that users have been requesting schemas for some time. Oracle Corp. databases already have the capability of letting mobile users work in the same database. Since PostgreSQL is already considered the “Oracle-class” open-source database, he said, it makes sense to plug in the features it lacks to make it even more of an enterprise database than it already is.

      “We have lots of people moving from Oracle to [PostgreSQL] already,” said Momjian, in Philadelphia. The more Oracle-like features his database has, the more alluring an alternative to Oracle it becomes, he added.

      Christopher Kings-Lynne, lead programmer for Family Health Network Pty Ltd., a company that specializes in online weight loss programs in Australia and the United States, said that appealing to power users is a good way to get open-source accepted in the enterprise.

      “More and more enterprises will see PostgreSQL as a viable backend for their operation,” Kings-Lynne said.

      Kings-Lynne also said that the addition of SQL schemas to PostgreSQL 7.3 should appeal to academic environments, since administrators can now create separate workspaces for all their users. But its 7.3s advances in ease-of-use and functionality that matters the most to him. For example, in 7.3, users can drop columns from tables and can easily change the NOT NULL status of a column. Also, foreign keys are smarter and are easier to drop and manipulate.

      Ericson Smith, a database administrator for Did-it.com Inc., in Rockville Centre, N.Y., said the prepared-queries feature of 7.3 will help automate the “millions” of simple queries in the companys Maestro product, a service that optimizes search engine technology. “This will help us a lot,” he said.

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

      ×