Sorry but...uh, have you ever managed a production database with millions of users? Asking an AI to do something like normalize all the phone numbers would be completely trivial. Why don't people do it? Hmmmmm...
[edit] What might be nice would be if it wrote an execution plan about what exact queries it was going to run. That might be helpful because it could spot outliers. But when you're talking about updating millions of rows of data for something, you'd have to have a death wish. Even if you're just starting off a DB with some bunch of data you're getting from somewhere else, you'd want normalization you could trust.
If data cleanup needs to be deterministic, why is so much of it done by humans? Two humans also won't normalize the same table in the same way. The main thesis is that AI data cleanup is cheaper and less mistake-prone than the same work done by a bored intern.
noduerme•58m ago
[edit] What might be nice would be if it wrote an execution plan about what exact queries it was going to run. That might be helpful because it could spot outliers. But when you're talking about updating millions of rows of data for something, you'd have to have a death wish. Even if you're just starting off a DB with some bunch of data you're getting from somewhere else, you'd want normalization you could trust.
ZeljkoS•29m ago
https://github.com/ZSvedic/TamedTable/blob/main/spec/test-ca...
And if an action can be done deterministically, then JS code will be generated:
https://github.com/ZSvedic/TamedTable/blob/main/spec/test-ca...
If data cleanup needs to be deterministic, why is so much of it done by humans? Two humans also won't normalize the same table in the same way. The main thesis is that AI data cleanup is cheaper and less mistake-prone than the same work done by a bored intern.