http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Solr / Lucene are usually used as external indexes for NoSQL stores http://ayende.com/4449/that-no-sql-thing-key-value-stores#comment7http://ayende.com/4449/that-no-sql-thing-key-value-stores#comment7Sun, 04 Apr 2010 08:47:27 GMTI'm wondering, where do solutions like Solr fit in between SQL and NoSQL war. http://ayende.com/4449/that-no-sql-thing-key-value-stores#comment6http://ayende.com/4449/that-no-sql-thing-key-value-stores#comment6Fri, 02 Apr 2010 07:21:02 GMTData mining or, for the example of "shopping-cart", statistics of sold products ? http://ayende.com/4449/that-no-sql-thing-key-value-stores#comment5http://ayende.com/4449/that-no-sql-thing-key-value-stores#comment5Tue, 30 Mar 2010 06:29:45 GMTThanks, fixed the issue with Redis http://ayende.com/4449/that-no-sql-thing-key-value-stores#comment4http://ayende.com/4449/that-no-sql-thing-key-value-stores#comment4Mon, 29 Mar 2010 15:46:51 GMTNote: FYI Redis does support atomic transactions: [code.google.com/p/redis/wiki/MultiExecCommand](http://code.google.com/p/redis/wiki/MultiExecCommand) Otherwise great post Oren, I would expand a little on queries which is one of the biggest limitations in NoSql databases. To support queries you effectively 'think in reverse', i.e. you need to know what queries your system will need up-front, then have your writes update these 'redundant query indexes'. On NoSql Schema's fundamentally they all implement one big hash table, but there are NoSql variants like Redis which also support atomic server-side operations on rich data constructs like Lists, Sets, Sorted Sets and Hashes which are useful in a variety of programming problems. http://ayende.com/4449/that-no-sql-thing-key-value-stores#comment3http://ayende.com/4449/that-no-sql-thing-key-value-stores#comment3Mon, 29 Mar 2010 13:40:44 GMTTomnaso, That is an embedded solution, what I would use to build a distributed key value store backend http://ayende.com/4449/that-no-sql-thing-key-value-stores#comment2http://ayende.com/4449/that-no-sql-thing-key-value-stores#comment2Mon, 29 Mar 2010 13:21:41 GMTWhat about Oracle Berkeley DB? http://ayende.com/4449/that-no-sql-thing-key-value-stores#comment1http://ayende.com/4449/that-no-sql-thing-key-value-stores#comment1Mon, 29 Mar 2010 12:32:29 GMT