4 ms·
I use couch, pouch, elasticsearch and sql dbs. I never really got the "schemaless" selling point of nosql though. I do see the point of storing documents rathe
by brimstedt 9y ago
I use couch, pouch, elasticsearch and sql dbs. I never really got the "schemaless" selling point of nosql though.
I do see the point of storing documents rather than rows for some use cases, or dbs extra strong on searches, etc.
But what is the problem with an "add column" or "change datatype" operation is sql..?
- deepsun 9y ago+1 In my experience, "schemaless" just means that I'll have to manage the schema manually through some "updater" scripts. Any data without schema is just noise, so if you have any data, it means that you have schema for it somewhere.
- bsg75 9y agoPartly because MySQL requires a full table lock and full table copy to implement those operations. Much of the nosql movement originated from implementing schema changes on production MySQL databases. In many if not most cases, NoSQL is really NoMySQL. Many other engines, PostgreSQL for example, can add a new column without constraints as a nearly instant metadata change only. Data type changes that do not require validation (expanding a VARCHAR vs CHAR to INT) are also rapid.