3 ms·
This might reveal my technical mediocrity, but my approach: 1. Write the SQL that I think should mostly work 2. Try to run it 3. Fix errors with the help of
by EForEndeavour 3y ago
This might reveal my technical mediocrity, but my approach:
1. Write the SQL that I think should mostly work
2. Try to run it
3. Fix errors with the help of docs, Stack Overflow, and now generative AI
4. Subconsciously learn whatever dialect this is to improve my performance on Step 1
- gvx 3y agoThis might work in the short term, but I don't recommend it as a general technique. This sort of an approach often causes there to be hidden bugs, which do not generate errors now, but will cause some problem down the line. It also has a tendency to lead to cargo cult programming (https://en.wikipedia.org/wiki/Cargo_cult_programming https://en.wikipedia.org/wiki/Cargo_cult_programming), which is less immediately problematic, but is still not great, especially for whoever needs to maintain that code.