3 ms·
And not only that, your application becomes littered with: if (data.schema_version === 1) { ... } else if (data.schema_version === 2) { ... } UGH!
by baudehlo 14y ago
And not only that, your application becomes littered with:
if (data.schema_version === 1) { ... }
else if (data.schema_version === 2) { ... }
UGH!
- sreeix 14y agoBut it is better than not having the ability to change the schema when there are more than a few million rows, thanks to the enormous time taken
- baudehlo 14y agoThat's just a limitation of MySQL, not relational databases in general. In Postgres you can do it live in a transaction.
- mattbriggs 14y agoSchemaless would let you add/remove a field easily. What is hard is if you need to restructure things, which is also probably a more common occurence in a document db then a relational one. If you hit a few million rows, you are in for a world of hurt changing things in any data store