4 ms·
This whole 'general purpose' term is meaningless. If you're talking about NoSQL vs SQL (ACID), you're just looking at trade-offs. Data integrity and distributed
by Demiurge 5y ago
This whole 'general purpose' term is meaningless. If you're talking about NoSQL vs SQL (ACID), you're just looking at trade-offs. Data integrity and distributed systems are always in contention. Of course, the moment you don't rely on types and structure constraints, you can have more performance and easier replication. You can't just solve this problem through evolution, until we have quantum computers, but all living projects are evolving towards some overlapping features and happy mediums.
The thing that seems to be happening over time is that those who optimize for performance, want integrity, and those who start with transactional guarantees want performance. So I guess, there could be some hype train pendulum swinging.