When using MySQL (or most any DB really), it’s a good idea to understand about collation: the implications, the defaults, and how to change it. Collation determines how data is sorted and compared in the database. Its essentially a set of rules for the DB to follow when making decisions on said sort and comparison. […]
MySQL Collation & Case Sensitivity or Insensitivity Read More »
The The MySQL Command-Line Client will show the version as soon as you successfully enter it: admin@server:~$ sudo mysql -u admin -p [sudo] password for admin: Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 70589 Server version: 5.7.27-0ubuntu0.16.04.1 (Ubuntu) If you are already in the
Check MySQL Version Read More »
One way to monitor DB activity in MySQL is to enable logging and then tail the log file. mysql -u root -p You can check the status of logging and get the path of the log file with: SHOW VARIABLES LIKE "general_log%"; And then enable logging with: SET GLOBAL general_log = 'ON'; Finally, tail the
Monitor MySQL DB Activity Read More »
On some platform / shell combos, you may find Git has gone hog-wild with the paging. I.e., you may find it pages things like logs & diffs when there is not even a single page of information in the first place. In this situation, I have found the following Git global config can resolve the
Prevent Git From Paging When Not Needed Read More »
In Python, we can use the random library to get a random number like so: from random import * x = randint(1, 100) print(x) or maybe you only want an odd number: from random import * x = randrange(1, 100, 2) print(x) But what if you want an infinite stream of random odd numbers available
Infinite random number generator expressions in Python Read More »
Description A tutorial and how-to demonstration of a download and installation of Git on Windows 10 64 bit. All install options are discussed in some detail in a step-by step fashion. The Bash shell, MinTTY, and MinGW 64 bit are briefly discussed & the configuration / install options are considered. This particular Git version
How to Download & Install Git on Windows 10 Read More »
Description A video which shows How To Download and Install Python 3.8 on Windows 10 or Windows 7. This is a Python Windows tutorial for beginners. This is an easy installation, but important information is provided to help choose the installation options. After we install Python 3.x.x, we want to confirm our installation by running
How To Download and Install Python 3.8 on Windows 10 Read More »
zsh (“zee shell”) is awesome. Alas, its still not installed by default in most Linux distributions. Here’s how to install & configure zsh on Debian 9: grokman@li598-26:~$ sudo apt-get update [sudo] password for grokman: Ign:1 http://mirrors.linode.com/debian stretch InRelease Get:2 http://mirrors.linode.com/debian-security stretch/updates InRelease [94.3 kB] Get:3 http://mirrors.linode.com/debian stretch-updates InRelease [91.0 kB] Hit:4 http://mirrors.linode.com/debian stretch Release Fetched
Linux – Switching to zsh Read More »
For admin work, using a non-root user with super-user privileges is good practice. This user has to be created. Let’s see how its done with an example on Debian 9: First we SSH into our target machine: $ ssh root@grokshop.tv Enter passphrase for key '/c/Users/[user]/.ssh/id_rsa': Linux li598-26.members.linode.com 4.9.0-9-amd64 #1 SMP Debian 4.9.168-1 (2019-04-12) x86_64 The
Linux – How To Create a Sudo User Read More »
Software Engineering: Open source project Gitea is forked & a minor GoLang code change affected to improve the startup sequence timing & robustness as pertains to the ORM layer and database connection. The overall Synology-linux debugging process is examined including upstart log analysis, process log analysis, Github source cloning, Go Programming Language coding, GoLang make,