I’m always trying different programming exercises in order to learn and grow as a Developer. One of my favorite learning exercises is porting over from one SQL dialect to another, as they all have their own individual features. Having to hack together or mirror non-existent functionality really challenges my thinking, therefore enabling growth and improvement in my query skills. In this post, I share reproducing the same query results using MySQL for queries I first learned of/discovered that were covered using Oracle SQL and specific implementation features…
(more…)Latest Blog Posts
OpenLampTech issue #9
Guess what? OpenLampTech, the newsletter for PHP/MySQL developers, has a new issue full of great curated content for your reading experience this week. Come on by and read the publication!
(more…)CodeIgniter 4 Query Helper getLastQuery() method – MySQL Prototyping
I’m resharing a post I first published over on my Medium account for interested readers here. As you know, SQL is my passion and sweet spot. But, I also have an affinity for PHP and CodeIgniter. Continue reading and learn how I prototype Query Builder patterns in CodeIgniter 4…
(more…)OpenLamp.tech issue #8
It’s that time once again. I’ve published another issue of OpenLamp.tech, the newsletter for PHP/MySQL developers, over the weekend with all the curated content for your reading experience. There is plenty to learn for everyone so dig in…
(more…)