Tuesday, February 28, 2006

MySQL


MySQL is a product I have been using since 2000. For those of you who don’t know, the product, here is a brief description. MySQL is an open-source Relational Database Management System. For those who don’t know what that is..then quite honestly, this blog entry isn't for you. :-)

Until recently, MySQL in my opinion was a good RDBMS to develop on, make some prototypes and then carry your schema over to a more mature RDBMS such as DB2, Oracle or SQL Server. It lacked certain features, that I considered as “givens” in an RDBMS solution, such as triggers, transaction support, views and even the dreaded stored procedures (An article will follow on this in the future).

However with the release of version 5.0, many of these short comings have been addressed. Views, limited trigger support, transaction support and stored procedures have been introduced. This, in essence, completes the offering and finally puts MySQL in the same category as the big boys.

The MySQL Effect The biggest impact MySQL has had on the RDBMS industry doesn't even have anything to do with the software. Its the fact that with a stable, full featured Open-Source RDBMS solution making waves, it has forced the big 3 to release free versions of their previously extremely expensive software. Oracle, IBM and Microsoft each released free versions of their software to the public. This in hope that as you get used to one product, and your business or needs grow, you will scale to a paid version of their products.

Conclusion MySQL is a good piece of software, well thought out and free. However, lets no kid ourselves. Oracle, DB2 and SQL Server are mature database offerings with many more features that MySQL. MySQL is still playing catch-up to the big 3. However, its doing a good job of it. As for whether to use it over any other solution? I guess it falls under the IT religion thing. If you sweat and bleed Open-Source, go for it! However with the release of free versions of the big 3, you will have a hard time convincing me to use MySQL over those.

Thursday, February 23, 2006

What is the best OS?

As some of you know, I am a DBA and System Administrator.  I manage Linux and Windows boxes alike.  However at home, I run a MAC. The question I get, too often is what is the best OS?  Well quite honestly, there isn’t a best OS.  Rather, there isn’t a best OS for every context.

At work we run Linux (Novell’s SUSE Linux) and its rock solid on our servers.  I wouldn’t imagine running anything else for a transactional Java and DB2 based production environment.

Although I run Linux on my desktop, and so do most other developers in my company, and rightfully so, since we want to develop in the environment we will deploy in, I actually prefer Windows for that environment.  Especially for laptops.  Now I know that you can get almost every feature of a modern day laptop to work on a modern Linux Distro, but who needs the head-aches?  XP, with an updated Anti-Virus software and the user not having Admin privileges, is just fine.  Now I won’t get into why,  in this article, and remember, this is my opinion, so keep the flaming to a minimum. :-)

For home, I like the MAC.  Its simple, and it works.  Personally, when I get home at night, I don’t want to “deal” with my computer, I just want to turn it on and have it work.  The MAC, in my opinion, is ideal for this.  Apple ships it with so much software, that wanting more, is just asking for trouble, when all you want to do is surf, email, and write the occasional Blog entry.  Besides, they look too damn nice!

To conclude, Linux in the server-room, Windows at the office, and MAC at home.

Sunday, February 19, 2006

My first post!

Not gonna talk about much today. Just wanted to say hi and just get the first Blog entry behind me.