2 ms·
>I am curious what HN thinks as major reasons for why everyone seems to have moved away from 1 big SQL database For the places I worked: 1. We transitioned to
by DeathArrow 3y ago
>I am curious what HN thinks as major reasons for why everyone seems to have moved away from 1 big SQL database
For the places I worked:
1. We transitioned to microservices
2. Performance, 1 BIG database slows that
3. Ops/maintenance is very hard in a huge DB
4. In a huge DB there can be a lot of junk no one uses, no one remembers why is there, but no one is certain whether that junk is still needed
5. We had different optimization strategies for reads and writes
6. Teams need to have ownership on databases/data stores so we can move fast instead waiting for DBAs to reply to tickets.
- lisasays 3y ago4. In a huge DB there can be a lot of junk no one uses, no one remembers why is there, but no one is certain whether that junk is still needed Of course no one knows how to even begin to come up with a way of addressing that problem. So the only viable option is to keep on masking it. And keep propagating the junk data and zombie schemas ever forward.