4 ms·
In my experience, the average coder dealing with SQL is flummoxed by non-trivial problems (even those that have fairly well-understood solutions) and wind up ha
by roc 17y ago
In my experience, the average coder dealing with SQL is flummoxed by non-trivial problems (even those that have fairly well-understood solutions) and wind up hacking in messes anyway. Heck, it's 50-50 whether they normalize their data or use transactions in the first place.
But I don't think you can fairly judge specialized tools based on the likely experience of coders using it outside their experience.
- astine 17y agoThe more I use SQL, the more I like it. Modeling certain kinds of data in RDBMS can be tricky, or near impossible, but one you get the schema down, the queries fetch and insert the data are usually straightforward. SQL's only real problem in my opinion is that it doesn't provide many good facilities for handling fluctuating schemas.
- roc 17y agoI was just pointing out that it's unfair to judge a tool based on how it might be used by people who don't really understand what it is and what it does. SQL is a great tool and there are many, very good reasons that it rose to prominence. It just isn't the only tool and it isn't right for every problem.