Greg Blumenthal
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?

Greg Blumenthal

Written by

I have more questions than answers