3 ms·
If properly modelled so the modifying operations are consistent and logical, SQL for modification has the advantage over "proper code to update" has the advanta
by dspillett 5y ago
If properly modelled so the modifying operations are consistent and logical, SQL for modification has the advantage over "proper code to update" has the advantage that in many cases the same query to find something is used with only minor alteration to modify it.
Now the real magic, would be to make changes atomic!
- verdverm 5y agoTF has locks so that two people cannot modify infra at the same time. There are also dependencies within the resources to consider, such as network creation before firewall rule before VM
- yawaramin 5y agoYeah, and Terraform providers can be buggy and actually mess up those dependencies. I ran into this very recently where Terraform planned my changes successfully but failed to delete something because it had a dependency on another thing which it was planning to delete later. It would be very difficult to mess this up with SQL foreign keys.