3 ms·
This isn't ideal but SQL got a lot less mind-numbing for me when I got decently good at vim. Maybe SQL doesn't have macros but vim macros, dot, and column mode
by DennisP 8y ago
This isn't ideal but SQL got a lot less mind-numbing for me when I got decently good at vim. Maybe SQL doesn't have macros but vim macros, dot, and column mode reduced my repetitive typing by a lot. Starting with a tool-generated list of column names often helped too.
- ah- 8y agoThe downside of that is that you end up with heaps and heaps of buggy queries and SQL code resulting in a maintenance nightmare.
- DennisP 8y agoAre you saying that about SQL in general? I end up with the same queries as if I'd typed out the SQL any other way. Or are you saying that efficient editing makes people forget about writing clean, concise code? I don't find that to be the case.