I was kinda getting sick of hearing that "SQL is not scalable", "you can't have schema-free engine in SQL" .. so i thought of looking at what the fuss is all about.. i won't add anything myself here since i haven't done any benchmarking but from my experience of mySql, i can say one thing for sure that it IS scalable, you CAN have schema-free engine in mySql and if you use it rightly i.e. using techniques like sharding and memcache, you can achieve pretty high performance with the security and data-safety. Here are few links that i saw on the topic;
- a nice article on why you shouldn't use NoSQL for everything http://bit.ly/cVUm4B
- another nice article on how you can create a schema-free engine in mySql http://bit.ly/9zqBcK
- this is an open source library for using key/value structure with mySql http://bit.ly/gYvBWF
- and finally a big proof that mySql is scalable and if you use it rightly you can do wonders.. friendfeed uses mySql and here is a description of their mechanism http://bit.ly/U2A8M
