On 06/23/2011 02:00 PM, Les Hazlewood wrote: > This leads me to believe that Cassandra may not be a good idea for a primary > OLTP data store. For example "only create a user object if email foo is not > already in use" or, more generally, "you can't create object X because one > with an existing constraint already exists". > > Is that a fair assumption?
I think so. Lacking a built in T for OLTP the amount of hard thinking you will have to do increases are you want to maintain more constraints. The obvious trade off is that instead of transaction you get that distirbuted horizontal scalability stuff with Cassandra.