Linked by Eugenia Loli on Tue 26th Oct 2004 22:58 UTC
Databases MySQL announced the general availability of MySQL 4.1. Certified by the company as production-ready for large-scale enterprise deployment, this significant upgrade to the MySQL database server features advanced querying capabilities through subqueries, faster and more secure client-server communication, new installation and configuration tools, and support for international character sets and geographic data.
Permalink for comment
To read all comments associated with this story, please click here.
My reasons for using MySQL...
by Anonymous on Wed 27th Oct 2004 20:02 UTC


Here are my reasons for using MySQL:

1.) Easy to use and administer
2.) Plenty of MySQL literature (i.e. Books)
3.) It works well enough
4.) It's relatively fast
5.) Seems to have a simple design (i.e. makes it easier to understand)

I know alot of people push PostgreSQL touting that it's a better database. I'm sure it is a better database, but migrating from MySQL to PostgreSQL is that much more difficult when there are few recently published books on PostgreSQL. Having a book there to guide me through installation, administration, and usage would be of great help. There are plenty of MySQL books, but few PostgreSQL books.

Honestly, I would love to use PostgreSQL for the license alone. I'm a proponent of the BSD license. I guess for now, I'll keep using MySQL and when I'm ready, I'll migrate. Besides, SQL concepts are virtually the same not matter what database you use. It's only the administration part that's different, which is what I'll need to learn to fully migrate.

I guess now I have to see what I need to do in order to upgrade from 4.0 to 4.1. Also, should I be using MyISAM tables or InnoDB tables? Can I migrate from MyISAM table to InnoDB tables easily?