NoSQL is not only about scale, but also about flexibility? the flexibility and schemalessness of NoSQL is actually a consequence of the scaling possibilities -

NoSQL is not only about scale, but also about flexibility? the flexibility and schemalessness of NoSQL is actually a consequence of the scaling possibilities - it's hard to manage horizontal partitioning and maintain consistency between multiple tables with foreign keys and rollback transactions in a distributed environment; and easy when you have only one table with two fields: key and value. when, like in mongodb, the value is actually a tree-like document, and you need to have an index on some of the element, you gradually return to schema, because this element should be in the same place/surrounding in all indexed values. i am saying that flexibility is not why you should choose NoSQL, but actually the scalability that you might need later. (and non-relational data is kept ok in blob fields or in files and indexed by lucene - if you want (i don't))