In this blog post BJ Clark overviews the available key-value stores that aren't SQL based.
On some projects he yields interesting experiences. Make sure to check out the comments as well.

The post has spread throughout social tiny text services so there is a chance you've already read it, but still worthwhile to put here.