Use this comparison matrix to learn about the differences between - and relative benefits of - the popular open source databases MySQL, PostgreSQL, Derby and H2 Database Engine (H2DB).
Over the years, offerings in the sphere of Databases available from the open source community have become faster and more reliable and, with that, increasingly popular choices for enterprises globally and across a broad swath of industries. As with a number of other categories of project, open source databases now compete on equal footing with established proprietary offerings such as SQL Server and Oracle. In fact, studies and polls executed in the last few years consistently indicate that MySQL and PostgreSQL both rank in the top ten databases used by enterprises; MySQL frequently appears in the top three along with SQL Server and Oracle.The following tables represent research completed in the fall of 2007 by OpenLogic. We went to the experts -- members of the OpenLogic Expert Community who are committers and expert users of the projects -- and asked them to answer a set of questions. Experts in MySQL, PostgreSQL, Derby and H2DB responded. Use the resulting information as a tool to plan your projects.The five questions we asked the experts appear below. To view the detail on the projects* compared across each question, click the question.
For comprehensive information on each project, search the OLEX Open Source Library. For a list of the open source developers we interviewed, click here.
*While no version of the projects is specified, you can assume that the information relates to the latest version in our library at the time of the last update.
Allowed tags: <a> link, <b> bold, <i> italics