DevelopmentAttitudes
Programming is a creative endeavor, and many of us approach it as if it's an art. When we examine code, we consider aesthetic fashions at the same time as we consider the concrete feasibility. To help people who aren't immersed in the culture of developing MySQL server, here's an attempt to enumerate and make explicit some of those attitudes that may not be obvious.
- SHOW commands are ugly but Information_schema and Performance_schema tables are pretty. All new SHOW commands, if you really need them, should be a thin layer over an Information_schema or Performance_schema table. -cm
- sql_modes are a necessary evil, to arrange compatibility with other SQL flavours. Adding a new sql_mode is almost always the wrong plan. If you think you need one, then ask us for advice. -cm