Common Issues with Databases

If we can’t trust our data, we can’t trust our program. Issues with data correctness can go unnoticed for a long time, popping up unexpectedly to pollute the user experience, raise doubt about the web application, or crash a server process. This is especially true as the data gets more complicated and as the points of contact with the data increase. The best practice for developing a new application is to enforce data integrity constraints from the beginning and re-run total data checks periodically. Three broad categories ...