Sep 2, 2018 · 1 min read
More of a PHPstorm question today.
I have a standard pattern for building complex multi-table reports. First, I create a temporary MySQL table in the format if the desired report. Then, I fill this table based upon inserts and updates from the various source tables. Finally, I fetch the temporary table to an array for output.
This workflow leverages all the speed of MySQL without involving joins-from-hell. It just works.
PHPstorm hates this workflow. Refuses to acknowledge the existance of the temporary table or of its columns.
Am I anti-patterning or is PHPstorm being a PITA?
