If
If you can keep your head when all about you Are losing theirs and blaming it on you, If you can trust yourself when all men doubt you, But make allowance for their doubting too;…
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!…