I recently wanted to check all tables’ current AUTO_INCREMENT value (if any) for a database dump structure. I wasn’t sure if a tables’ Data Definition Language (DDL) statement contained the current AUTO_INCREMENT value or not. So after I loaded the dump file, I learned of a query to use and find out…
(more…)Blogging
Python vs. PHP: Which is Better for Web Development?
In the digital world, web development has become one of the most in-demand skills. The biggest companies have already invested in developing their website to help boost business and brand identity. When first developing a website, you may be wondering which programming language to use.
(more…)CodeIgniter 4 Query Builder join() Method Explained
The CodeIgniter 4 Query Builder class provides ORM-like functionality for Database operations in the framework. As developers, we know SQL JOINs are foundational and oftentimes required in order to retrieve the correct data. The Query Builder class has a dedicated join() method you can use when constructing queries where JOINs are necessary. Continue reading and learn how to use the CodeIgniter 4 Query Builder join() method…
(more…)MySQL ALTER TABLE – Add Multiple Columns
I recently needed to add multiple columns to an existing table to store summary data calculations and wondered if I could do it in one MySQL ALTER TABLE statement. Turns out you can. And, it’s super simple. Convenient too. Continue reading and learn what I learned…
(more…)5 Truths I’ve Come To Realize As a Self-taught Developer – Premium Content 🔒
When I began my self-taught developer journey back in 2016 (I go more in-depth in this RTC interview), little did I know – at that time – learning the tech side of things would be the easy part. Here are 5 hard truths I’ve come to realize, personally, on this never-ending journey…
(more…)