I think that it means the reason for doing where 1 = 1 is sometimes to allow for easy insertion of dynamic queries which can be a security and performance issue. The actual usage of where 1 = 1 doesn't cause the security or performance issue.
100%. ORMs are good for basic queries but the messes I have seen written joining 20 plus tables with conditions and left joins, etc, oof. Just use SQL, it’s much cleaner and easier to maintain.
To add to this Commander Keen was released on a very limited platform. More people were gaming on Nintendo systems than personal computers. If Commander Keen was released on Nintendo things may have gone differently.
20+ years ago I wrote a completely custom open order dashboard on top of Oracle database that was modeled after a 30+ page daily report that the warehouse guy was printing every morning (M-F) and making 15 - 20 copies, then delivering to management. Aside from saving some trees the warehouse guy was able to come into work an hour later! (He was salary, so no issues there.)
I’ve been exploring generating small charts with SVGs lately. Does anyone have good resources or suggestions for SVG chart generation? Ideally without requiring a JavaScript framework.
I’ve heard it said that if it’s important enough to you then you will give it the time it needs. Either spending time with certain people or when working. For long lists, pick the task that’s most important to complete and do it. Then pick the next most important task and repeat.
I’m in the same position as you. They keep removing features and raising the prices. Been with them for 6 years. Biggest concern is moving all of my monthly recurring revenue elsewhere since I’m auto billing stored CC information (stored with CC processor only).