A long time ago in a far away office…
Developing a web app meant breaking out your favorite text editor and starting to write code. Every line of code had to be written from scratch and the text editor was not a lot of help. During this period to survive as a PHP developer you had to be very familiar with MySQL. Writing long drawn out SQL statements was all in a days work.
As time progressed developers starting writing code in a way that could be reused. Boilerplate became a common term for writing the same code over and over, project after project. I still gets chills thinking about boilerplate work. Eventually this reusable code was turned into frameworks and released into the wild. Now days there is really no reason to build a web app without a framework.
Lately I have been working on some very complex WordPress plugins which require stability and performance beyond your typically everyday plugin. Yesterday while digging deeper than anyone ever goes into WordPress core I hear this cry, “I’m so lonely!”. Startled by this unexpected feedback I was forced to investigate.
That is when I ran into an old friend, MySQL. WordPress has made database interaction so easy that MySQL has become neglected and forgotten. Developers who were once MySQL experts now act as total strangers to this necessary companion. Heavy with shame, I vowed to rekindle this relationship to its full potential.
Now highly complex tasks which seem nearly impossible using WordPress functions can be accomplished easily using direct database interaction. Queries run leaner, sites load faster, and I write less code. Thank you old friend for reminding me how powerful you are.
Please developers, don’t neglect MySQL.