[I, Librarian]
  • [Photo] J.W. Bizzaro • January 6, 2004
    ``Big companies are warming up to open-source database software, according to a new study.

    ``The open-source database MySQL grew rapidly in popularity over the last year, according to results from a survey released Monday by research company Evans Data. Usage of MySQL for developing applications rose 30 percent over the past year, while usage of Microsoft's SQL Server and Access databases increased 6 percent, according to the survey of 550 developers conducted last month.''

    Full story:
    http://news.com.com/2100-7344-5134836.html

    MySQL is a light-weight, SQL-like

    DBMS

    http://www.mysql.com

    PostgreSQL (not mentioned in the article) is a powerful, SQL-compliant DBMS:
    http://www.postgresql.org

    Both are open-source and free to use, and both are being used here at Bioinformatics.Org.

Discussion forums: News.com: Open-source databases gaining favor

Expanded view | Monitor forum | Save place

Comment

PostgreSQL vs MySQL
Submitted by Nobody ; posted on Sunday, January 11, 2004
There are two key advantages to PostgreSQL over MySQL when it comes to bioinformatics: 1) PostgreSQL is a true object-relational DBMS 2) PostgreSQL was designed on the premise of extensibility (3rd Manifesto, H.Downs) Essentially, PostgreSQL was designed to be adaptable (user defined data types/blades) and well-suited for complex queries. To say that MySQL is inherently faster is misleading. A good resource for these types of issues/problems would be the consulting group out of Berkekely (ex-INGRES folks): i think it is http://www.varlena.com . i'm currently using postgresql and neural nets on secondary structure prediction of proteins. we are using Joone as the 'OO glue' for distributed processing. lon @ efcodd.org

Reply to this comment:

You have to be logged in to post a reply.

Thread view:

PostgreSQL vs MySQL
Submitted by Nobody ; posted on Sunday, January 11, 2004
There are two key advantages to PostgreSQL over MySQL when it comes to bioinformatics: 1) PostgreSQL is a true object-relational DBMS 2) PostgreSQL was designed on the premise of extensibility (3rd Manifesto, H.Downs) Essentially, PostgreSQL was designed to be adaptable (user defined data types/blades) and well-suited for complex queries. To say that MySQL is inherently faster is misleading. A good resource for these types of issues/problems would be the consulting group out of Berkekely (ex-INGRES folks): i think it is http://www.varlena.com . i'm currently using postgresql and neural nets on secondary structure prediction of proteins. we are using Joone as the 'OO glue' for distributed processing. lon @ efcodd.org

© 1998-2025 Scilico, LLC. All rights reserved.