Reset 'root'@'localhost' for MariaDB
I'm running a Pixelbook with Crostini, and my MariaDB database sits in my linux instance. Sometimes, weird things happens and my root user loses the password and I can't access my database. So here is…
WHERE..IN vs UNION ALL Performance
For a while I was sure that UNION ALL had better performance when dealing with multiple matches from SELECT * FROM table. But recently I revisited my code and the performance is negligible. My code is…
Docker Alpine + ExpressJS + Angular
Docker has been around for a considerable time already, released on 2013, it aims to solve the problem of "But it works on my computer".…
Using Plotly.js Charts for Dashboards
Today we're going to look at a really powerful charting library that is really easy to use and set up. Plotly Open Source Graphing Library supports several programming languages, including Python, Matlab, R, and most importantly Javascript!…
29 Ways AI Will Change Your Life
AI is set to take over the world in a few years. Here are a few ideas how it will used to improve your life. Some are already being developed actively!…