News.com: Open-source databases gaining favor

J.W. Bizzaro • January 6, 2004

News.com: Open-source databases gaining favor
(1 comment)

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

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

Start a new thread:

You have to be to post a reply.