There have arrived a number of frameworks in the market to organize web databases like PostgreSQL, MongoDB, Oracle, etc. But the most popular one among these is MySQL. Statista gave MySQL second place as the most famous database technology. Although there are several competitors competing against MySQL, the popularity that MySQL enjoys can’t be compared with anything else. It is competing with all other technologies very fiercely. A survey conducted by Datanyze a few days back found that 14.46% of the users in the market are using MySQL. On the other hand, the share of MongoDB is just a mere 4.13%.
(more…)Latest Blog Posts
OpenLampTech issue #38 – Substack Repost
We have another massive newsletter for you this week. And OpenLampTech is growing! Thank you for making it a success!
(more…)MySQL WHERE Clause Inequality Comparison Operators
Just as you want to filter the rows of data returned in a SELECT query with the equality comparison operator (=), you can also create a conditional filter to test if 2 values are not equal to one another. Learn more in the following article.
(more…)OpenLampTech issue #37 – Substack Repost
We are moving right along with the OpenLampTech publication. This week’s issue has a great developer interview, in addition to all the curated MySQL, PHP, and LAMP stack content you’ve come to expect. Let’s get to it. Enjoy OpenLampTech issue #37!
(more…)CodeIgniter 4 Query Parameter Binding with examples in MySQL
As powerful and useful as the CodeIgniter 4 Query Builder class methods and functions are, there are times when you need to hand-craft your own queries. Perhaps they are complex. Or, you would just rather write the raw SQL. Learn how to safely use the input you need – typically as part of the WHERE clause conditional(s) – using 2 different parameter binding variations with examples in MySQL.
(more…)