Guchie francisguchie

## angular-cli-node-js-typescript-rxjs-compatiblity-matrix.csv

          
            Angular CLI version
            Angular version
            Node.js version
            TypeScript version
            RxJS version

            
              1.0.0-beta.17 (package name: angular-cli)
              2.0.x
              6.9.x or later minor version
              2.0.x
              5.0.x or later minor version

            
              1.0.0-beta.20-1 (package name: angular-cli)
              2.1.x
              6.9.x or later minor version
              2.0.x
              5.0.x or later minor version

            
              1.0.0-beta.22-1 (package name: angular-cli)
              2.2.x
              6.9.x or later minor version
              2.0.x
              5.0.x or later minor version

            
              1.0.0-beta.30
              2.3.x
              6.9.x or later minor version
              2.0.x
              5.0.x or later minor version

            
              1.0.0-rc.4
              2.4.x
              6.9.x or later minor version
              2.0.x
              5.0.x or later minor version

            
              1.0.6
              4.0.x/4.1.x
              6.9.x or later minor version
              2.2.x
              5.0.x or later minor version

            
              1.1.3
              4.0.x/4.1.x
              6.9.x or later minor version
              2.3.x
              5.0.x or later minor version

            
              1.2.7
              4.0.x/4.1.x
              6.9.x or later minor version
              2.3.x
              5.0.x or later minor version

            
              1.3.2
              4.2.x/4.3.x/4.4.x
              6.9.x or later minor version
              2.4.x
              5.0.x or later minor version

## rclone-mysql-googledrive
#!/bin/bash
##this script will backup mysql and upload it to google drive
##directory name
dirname=$1;
##database name
database=$2;
##database username
dbuser=$3;
##database password
dbpass=$4;

## LXD-cheat-sheet.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                francisguchie
                / LXD-cheat-sheet.md
            
            
              Created
              November 19, 2020 18:02
                — forked from berndbausch/LXD-cheat-sheet.md
            
              
                LXD cheat sheet
              
          
    Useful LXD commands

Summarized from https://stgraber.org/2016/03/19/lxd-2-0-your-first-lxd-container-312/.
Interestingly, the LXD command line client is named.... lxc!
List available containers

lxc image list ubuntu:        # ubuntu: is officially supported image source
lxc image list images:        # images: is an unsupported source
lxc image alias list images:  # lists user-friendly names


## MySql-5.6-installation guide on Ubuntu 20.04 Lts.md

      
              1 file
            
          
              3 forks
            
          
              0 comments
            
          
              1 star
            
          
                francisguchie
                / MySql-5.6-installation guide on Ubuntu 20.04 Lts.md
            
            
              Last active
              July 23, 2023 13:54
            
          
    ############### INSTALLING MySQL 5.6 ON UBUNTU 20.04 LTS

start by updating the release
sudo apt-get update && sudo apt-get dist-upgrade
######  Uninstall any existing version of MySQL

check if you have any mysql installed

mysql -version
or
sudo dpkg -l | grep mysql

  
## my.cnf.txt
# *** Application-specific options follow here ***

#
# The MySQL server
#
[mysqld]

# The maximum amount of concurrent sessions the MySQL server will
# allow. One of these connections will be reserved for a user with
# SUPER privileges to allow the administrator to login even if the

## my.ini
# MySQL Server Instance Configuration File
# ----------------------------------------------------------------------
# Generated by the MySQL Server Instance Configuration Wizard
#
#
# Installation Instructions
# ----------------------------------------------------------------------
#
# On Linux you can copy this file to /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options

## mysql-cumulative-sum.sql
-- without using SET variable
SELECT t.id,
         t.count,
         (@running_total := @running_total + t.count) AS cumulative_sum
    FROM TABLE t
    JOIN (SELECT @running_total := 0) r
ORDER BY t.id

-- with SET variable
SET @running_total := 0;

## mysql-cumulative-sum.sql
-- without using SET variable
SELECT t.id,
         t.count,
         (@running_total := @running_total + t.count) AS cumulative_sum
    FROM TABLE t
    JOIN (SELECT @running_total := 0) r
ORDER BY t.id

-- with SET variable
SET @running_total := 0;
Angular CLI version	Angular version	Node.js version	TypeScript version	RxJS version
1.0.0-beta.17 (package name: angular-cli)	2.0.x	6.9.x or later minor version	2.0.x	5.0.x or later minor version
1.0.0-beta.20-1 (package name: angular-cli)	2.1.x	6.9.x or later minor version	2.0.x	5.0.x or later minor version
1.0.0-beta.22-1 (package name: angular-cli)	2.2.x	6.9.x or later minor version	2.0.x	5.0.x or later minor version
1.0.0-beta.30	2.3.x	6.9.x or later minor version	2.0.x	5.0.x or later minor version
1.0.0-rc.4	2.4.x	6.9.x or later minor version	2.0.x	5.0.x or later minor version
1.0.6	4.0.x/4.1.x	6.9.x or later minor version	2.2.x	5.0.x or later minor version
1.1.3	4.0.x/4.1.x	6.9.x or later minor version	2.3.x	5.0.x or later minor version
1.2.7	4.0.x/4.1.x	6.9.x or later minor version	2.3.x	5.0.x or later minor version
1.3.2	4.2.x/4.3.x/4.4.x	6.9.x or later minor version	2.4.x	5.0.x or later minor version
	#!/bin/bash
	##this script will backup mysql and upload it to google drive
	##directory name
	dirname=$1;
	##database name
	database=$2;
	##database username
	dbuser=$3;
	##database password
	dbpass=$4;
	# * Application-specific options follow here *

	#
	# The MySQL server
	#
	[mysqld]

	# The maximum amount of concurrent sessions the MySQL server will
	# allow. One of these connections will be reserved for a user with
	# SUPER privileges to allow the administrator to login even if the
	# MySQL Server Instance Configuration File
	# ----------------------------------------------------------------------
	# Generated by the MySQL Server Instance Configuration Wizard
	#
	#
	# Installation Instructions
	# ----------------------------------------------------------------------
	#
	# On Linux you can copy this file to /etc/my.cnf to set global options,
	# mysql-data-dir/my.cnf to set server-specific options
	-- without using SET variable
	SELECT t.id,
	t.count,
	(@running_total := @running_total + t.count) AS cumulative_sum
	FROM TABLE t
	JOIN (SELECT @running_total := 0) r
	ORDER BY t.id

	-- with SET variable
	SET @running_total := 0;