|
|
|
|
|
by eeperson
1893 days ago
|
|
> the only natural way to work with the native way that SQL databases express writes - in-place updates to rows - is with a model that represents them as in-place updates I strongly disagree with this for a few reasons. I actually think the command-oriented way is makes the most sense. The problem with in place updates is that: - Your queries aren't views. What you queried out of the DB is a snapshot of what is in there. It may already be different.
- The way you interact with a DB is command based. If you want to update a row that is a command that may fail. The only way I feel that using mutable data would make sense is if you had some sort of 2-way syncing. But those are notoriously difficult to get right even without network trips in the middle. |
|