The SQL langauge is old, strange, and important. We’ll take those in reverse order:
SQL is important. Unlike many other types of databases, SQL databases can give strong guarantees of data correctness.
If we have a regular, user-facing bug in our application, some users will see an error. When we fix the bug, the users stop seeing the error and everything is fine.
But if we have a bug that inserts incorrect data into the database, then fixing the bug doesn’t fix the problem. Even after the fix, the database is full of incorrect data, so we have to do something to clean it up. Here’s a concrete example…
Read in full here:
This thread was posted by one of our members via one of our news source trackers.