MariaDB SQL Recursive call to self (single table)

If you need to recursively query data based on child / parent relation between rows, you can achieve that using WITH RECURSIVE & UNITE ALL query instructions. Let’s have a look at example “software table”. Software can be declared as virtual machine,...

Bubble sort Explained

Bubble sort complexity: O(n^2) Pseudocode: src: https://www.youtube.com/watch?v=xli_FI7CuzA Bubble sort PHP code example: function bubble_sort($arr) { $size = count($arr)-1; for ($i=0; $i<$size; $i++) { for ($j=0; $j<$size-$i; $j++) { $k = $j+1; if ($arr[$k]...

Open PowerShell terminal as Administrator from CLI

Type PowerShell and select run as Administrator from windows context menu. Open PowerShell terminal as Administrator (GUI) On keyboard, press Windows button ([win]) and [x]. The windows tool menu will pop up. [win] + x Open PowerShell terminal as admin from CMD (CLI)...

How to get Windows 10 activation KEY for my PC?

Perhaps you already tried to obtain Windows 10 key from CMD with a command you found on the Internet, but it did not work. I had the same problem. CMD simple did not work. I got blank output. So I tried to look for different solution. Below, I present a solution that...

How to protect PHP source Code?

When to keep your PHP code logic secret? Whenever you need to pass a script to a client, but you are afraid that it will get copied and reused elsewhere without your permission. How to protect your PHP code? You could implement code “blockers”. Provide a...

VPS DirectAdmin running out of space

Login to your VPS with SSH Find all files larger them 500 MB find / -type f -size +500M -exec ls -lh {} \; List root dir sizes. Or any current folder (run without /) du -h –max-depth=1 / Remove specific files: sudo rm -R...