Where not in and NULL

In this article, I want to show you queries might sometimes return results which may look strange at first glance. You need to remember the devil is in the detail while creating queries 😈

read more

A static property of a class as cache

While developing apps, developers have a case when they need to get data from the same table of DB, which aren't often changed, quite regularly. store settings or user settings are good examples what I mean. If an app is quite complex, the app'll need to get these data a minimum of several times during a request. It might be an optimisation problem for DB. In this article, I'm showing how to solve cases like that.

read more

Input suggestions using datalist

Suggestions for an input are very useful to improve UX of forms. A lot of developers use a complex code of JavaScript to achieve it. Fortunately, HTML supports it natively. I guess, many developers (including me) don't know or forgot it. Please have a look on my code to see how to add suggestions easily.

read more