Hi!
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!
MySQL
The good
- New releases, and the “inner” message that MySQL is (still) alive and doing great!
- The special attention they are giving up lately to the Windows world. Check out the new Excel add-in, the Windows smart installer, the new planned Node.js driver and others.
- LAMP still rulz the world! :)
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
- Any SQL thingy can you run on Microsoft Surface…?!?
PostgreSQL
The good
- The 9.x releases
- Great support for events, trainings, online publishing etc.
- A strong community of die-hard fans
- Geospatial support (PostGIS)
- Cloud support
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
- CUBRID had a strong finish last year, with the 9.0 release. Keeping a fast releases pace is really great, especially with so many improvements and new features added!
- Finally, we have proper multilingual support into CUBRID! …long-long awaited…
- We have a Node.js driver!
- Sharding support!
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!
/Dee
No comments:
Post a Comment