January 1, 2013

The Good, The Bad, and The Ugly

First of all, HAPPY NEW YEAR! Wish you a year full of great SQL coding! :)

This post is a little different - it is not a "techno-post" as usual, but more of a looking back and gathering about what was good, what was bad and what was ugly last year in the world of some well-known SQL databases… ...Let’s start!


The good
  • New releases, and the “inner” message that MySQL is (still) alive and doing great!

The bad
  • The releases pace is too slow for the #1 open-source database! We need more and more improvements and features, especially when looking at the big community out there!
  • Non-linear performance scaling, but the good news is that there are some improvements.

The ugly
  • The unknowns about the future of MySQL... Will it still be out there in 3 years from now?
  • The too small, quite non-existing improvements on query plans engine…

SQL Server

The good
  • The Azure! SQL Server does absolutely great in terms of Cloud support, they are simply #1 in this area!
  • The freeware, the open-source support! If this is a trend for the future, than great job, Microsoft!
  • This worth mentioning a thousand times – the 100% freeware SQL Server Compact release. Simply amazing for Windows solutions…!
  • Their web site! A model of simplicity and great design – I love it!

The bad
  • No Linux, no OSX…
  • Price… Installing SQL Server 2012 on a Windows Server 2012 and using a domain controller and so on is still too expensive for a small business…
  • Windows 8! I know, I know! - this has nothing to do with SQL, but please be kind and indulge me this one rant… ha-ha :)

The ugly


The good

The bad
  • Still too less publicity for what this database true value stands for!
  • No Amazon RDS support (yet)
  • Still has a reputation of poor Windows support when compared to Linux; actually, this is not true anymore, but PostgreSQL should do much more to advertise their achievements in the Windows arena.

The ugly
  • The feeling that “you need to know what you’re doing” if you ever intend to use PostgreSQL… …the feeling that it’s simply not a solution for the casual beginner…

and we got to CUBRID

The good

The bad
  • The web site search still does not work the way it should… ...too much “not what I searched for”, too many low significant search results, too many “version-oriented” results.
  • No published vision about what’s going on in the future…! Hey - what is the plan for 2013 and beyond, guys…? Any NoSQL support…? Any new drivers…? Tell us, please! :)
  • No GIS support, no data warehousing (Cubes/OLAP) support
  • No Cloud

The ugly

...Well, I have one big time favorite here – the www.cubrid.org website itself! Yes, it looks "old", it looks “outdated”… The CUBRID web site really needs a facelift…! …Take a look here or here, for example, for some modern interface designs.

One last thing – some food for thoughts at the beginning of 20123…  

What do you think about Service Oriented Database Architecture?

Do you think this is the next big thing after NoSQL? Do you think that maybe database services is the next big step in databases architecture?

That’s it for my first post this year – let me know what do you think!

See you next time – Bye-bye!

P.S. If you have some time to spare, consider taking a look at Oracle XE… …You might have a nice surprise (and yes – it’s 100% freeware!)…

No comments:

Post a Comment