NoSQL isn't a replacement for SQL, it's just another tool along side it. NoSQL solves the persistent data, random access, high speed access problem. Yes, you can make SQL do key-value pairs, but even with spending money on Oracle etc you're no going to be able to pull 10s of Ks worth of records in 10s of ms. And yes, you could just use a Memcache layer on top of SQL, but now you're double writing, you have unneeded evictions cause of Memcache's crappy slab setup, and all your standard cache stampeding issues, and on top of it all, Memcache still isn't that fast.
I'd love to use pretty and perfect SQL for everything, but sometimes it's just not the right tool for the job, and when you're talking huge web-scale apps, it just can't keep up.
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
ninetydegrees
no subject
on 2010-02-25 02:42 am (UTC)I'd love to use pretty and perfect SQL for everything, but sometimes it's just not the right tool for the job, and when you're talking huge web-scale apps, it just can't keep up.