Software Engineering

MySQL Collation & Case Sensitivity or Insensitivity

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 »

How to Download & Install Git on Windows 10

  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 »

How To Download and Install Python 3.8 on Windows 10

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 »

Linux – Switching to zsh

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 »

Linux – How To Create a Sudo User

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 »

GoLang Programming: Gitea Open Source Patch – Improving Startup Robustness on Synology Linux

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, …

GoLang Programming: Gitea Open Source Patch – Improving Startup Robustness on Synology Linux Read More »