Close
  • Latest News
  • Cybersecurity
  • Big Data and Analytics
  • Cloud
  • Mobile
  • Networking
  • Storage
  • Applications
  • IT Management
  • 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
Menu
eWEEK.com
Search
eWEEK.com
  • Latest News
  • Cybersecurity
  • Big Data and Analytics
  • Cloud
  • Mobile
  • Networking
  • Storage
  • Applications
  • IT Management
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Applications
    • Applications
    • Database
    • Networking
    • Servers
    • Storage

    PostgreSQL Advocates Press On

    By
    BRIAN PRINCE
    -
    November 6, 2007
    Share
    Facebook
    Twitter
    Linkedin

      Advocates of PostgreSQL say the open-source database is continuing to slowly win converts even as it remains in the shadow of the more widely used MySQL.

      PostgreSQL has come a long way technically since its inception in the 1980s, when it was known as Postgres. Today it remains sufficiently modern and relevant to developers, and it is one of the lower-cost open-source alternatives to proprietary products, advocates say.

      A recent survey of 226 members of the Independent Oracle Users Group released last month found that 74 percent of the respondents who are using open-source and Express edition databases use MySQL, while 20 percent use PostgreSQL. Nine percent of respondents reported using PostgreSQL in an IOUG survey in 2006.

      “It’s very hard to unseat an entrenched solution in any market, and all of the commercial vendors [IBM, Oracle, Microsoft and MySQL] are certainly firmly entrenched, but I think PostgreSQL is moving in the right direction,” said Robert Treat, database architect at OmniTI Computer Consulting in Columbia, Md.

      Treat, who has been recognized as a major contributor to PostgreSQL, claims key factors in the growth of PostgreSQL are friendly licensing and a general movement toward open-source software by enterprises looking to cut costs. Name recognition also plays no small part, as mainstream technology companies such as Sony and Apple have taken to using PostgreSQL-based solutions, he added.

      Overall, the adoption of open-source databases has been strong when compared with commercial closed-source databases, according to Noel Yuhanna, an analyst with Forrester Research. He estimated the open-source database market to be around $650 million including new licenses, software maintenance and support, and consulting services. A recent Forrester survey revealed 32 percent of enterprises have at least one open-source database in their environment, up from about 11 percent in 2003, he added.

      “[The] majority of the deployment of open-source databases is around MySQL, and that has not changed,” Yuhanna said. “Although PostgreSQL adoption has grown, the biggest challenge has been that no vendor until more recently pushed this software commercially—it’s always been community-driven. However, with EnterpriseDB and Sun Microsystems committing to support PostgreSQL, there has been some headway, but much work needs to be done to increase its adoption.”

      EnterpriseDB, which has based its Advanced Server product on Postgres, has positioned itself in the market as a leading provider of professional, round-the-clock PostgreSQL technical support, services and training.

      “EnterpriseDB chose [PostgreSQL] because of the advanced technical capabilities of the database and the ease of extending it,” said Bruce Momjian, PostgreSQL community leader and senior database architect at EnterpriseDB. “I think we [PostgreSQL] are on par with MySQL in terms of ease of use.”

      The open-source community is leery of EnterpriseDB’s efforts to market a commercial version of PostgreSQL. Read why.

      “In terms of community adoption, we have a lot of users coming from commercial databases, while I believe MySQL is mostly new Web applications,” Momjian continued. “Our [PostgreSQL] user base is mostly companies that have large data needs—[for example] the National Weather Service runs PostgreSQL—or have tight profit margins.”

      The key drivers for increased open-source database adoption in general continue to be cost, support from more vendors and expansion of the ecosystem—tools, applications and services, Yuhanna said. Key challenges that are keeping adoption from moving faster are migration efforts, long-term ROI when training, migration and integration, and administration, he added. There are also continuing concerns about security and performance, he said.

      “Open-source databases are free, but that does not mean that they cost nothing,” Yuhanna said.

      Right now, PostgreSQL suffers from a lack of ubiquity other products have—there are fewer third-party applications, and fewer instructional articles and books—but it is nearing a tipping point, Treat observed.

      “As more people use it, and more people are vocal about using it, I think you are really going to see a snowball effect,” he said.

      Check out eWEEK.com’s Database Center for the latest database news, reviews and analysis.

      MOST POPULAR ARTICLES

      Android

      Samsung Galaxy XCover Pro: Durability for Tough...

      CHRIS PREIMESBERGER - December 5, 2020 0
      Have you ever dropped your phone, winced and felt the pain as it hit the sidewalk? Either the screen splintered like a windshield being...
      Read more
      Cloud

      Why Data Security Will Face Even Harsher...

      CHRIS PREIMESBERGER - December 1, 2020 0
      Who would know more about details of the hacking process than an actual former career hacker? And who wants to understand all they can...
      Read more
      Cybersecurity

      How Veritas Is Shining a Light Into...

      EWEEK EDITORS - September 25, 2020 0
      Protecting data has always been one of the most important tasks in all of IT, yet as more companies become data companies at the...
      Read more
      Big Data and Analytics

      How NVIDIA A100 Station Brings Data Center...

      ZEUS KERRAVALA - November 18, 2020 0
      There’s little debate that graphics processor unit manufacturer NVIDIA is the de facto standard when it comes to providing silicon to power machine learning...
      Read more
      Apple

      Why iPhone 12 Pro Makes Sense for...

      WAYNE RASH - November 26, 2020 0
      If you’ve been watching the Apple commercials for the past three weeks, you already know what the company thinks will happen if you buy...
      Read more
      eWeek


      Contact Us | About | Sitemap

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Property of TechnologyAdvice.
      Terms of Service | Privacy Notice | Advertise | California - Do Not Sell My Info

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

      ×