Skip to content

Instantly share code, notes, and snippets.

@RajaniCode

RajaniCode/Path

Created July 15, 2024 09:15
Show Gist options
  • Save RajaniCode/c6de29d66504f5c50d8fafb5c62579e1 to your computer and use it in GitHub Desktop.
Save RajaniCode/c6de29d66504f5c50d8fafb5c62579e1 to your computer and use it in GitHub Desktop.
Download ZIP
Path
Raw
Path
###########################################################################################################################
# Google Cloud
###########################################################################################################################
***************************************************************************************************************************
# Google Cloud CLI # gcloud
***************************************************************************************************************************
% python3 --version
% ./google-cloud-sdk/install.sh
# Terminal New Window
% gcloud --version
% where gcloud
% which gcloud
% type gcloud
# Update gcloud to the latest version
% gcloud components update
***************************************************************************************************************************
# Google Cloud Debian GNU/Linux
***************************************************************************************************************************
===========================================================================================================================
# Debian GNU/Linux
===========================================================================================================================
$ sudo cat /etc/os-release
$ sudo cat /etc/*release
$ sudo cat /etc/*version
$ sudo cat /etc/issue
$ sudo more /etc/issue
$ sudo less /etc/issue
$ sudo cat /proc/version
$ sudo lsb_release --all
$ sudo lsb_release --description
$ sudo man lsb_release
[
$ sudo hostnamectl
]
$ sudo man hostnamectl
$ sudo uname
$ sudo uname -r
$ sudo uname --release
$ sudo uname -srm
$ sudo uname --kernel-name --kernel-release --kernel-version
$ sudo uname -amnoprsv
$ sudo uname --all
$ sudo man uname
$ sudo grep -E '^(VERSION|NAME)=' /etc/os-release
$ sudo grep '^VERSION' /etc/os-release
$ sudo apt --version
$ sudo apt-get --version
$ sudo dpkg --version
$ sudo dpkg -l
$ sudo which dpkg
$ sudo man dpkg
$ sudo arch
$ id -un
$ sudo id -un
$ whoami
$ sudo whoami
$ echo `whoami`
$ sudo echo $USER
$ sudo echo $HOSTNAME
$ sudo echo `hostname`
$ sudo echo $HOME
$ sudo echo ~/
$ sudo echo $SHELL
$ sudo echo $PATH
$ sudo env
$ sudo pwd
$ sudo date
$ sudo locale
$ sudo locale -a
$ sudo echo $LANG
$ sudo ls
$ sudo ls -a
$ sudo ls /usr/local/bin
$ sudo ls /usr/bin
$ sudo ls /bin
$ sudo ls /usr/sbin
$ sudo ls /sbin
$ type compgen
$ compgen -c
$ compgen -a
$ compgen -b
$ compgen -k
$ compgen -A function
$ compgen -A function -abck
$ www-browser
===========================================================================================================================
# Programming Languages
===========================================================================================================================
$ node --version
$ python3 --version
$ ruby --version
$ gcc --version
$ cc --version
$ g++ --version
$ c++ --version
$ java --version
$ gradle --version
$ mvn --version
$ dotnet --version
$ perl --version
$ php --version
$ go version
===========================================================================================================================
# Network
===========================================================================================================================
$ sudo apt update
$ sudo apt upgrade
[
$ sudo apt-get update
$ sudo apt-get upgrade
]
$ sudo netstat -tunpl
$ sudo netstat -nr
$ sudo netstat -ai
$ sudo netstat -ant
$ sudo ss -tunl
$ sudo ss -t
$ sudo ss -A tcp
$ sudo ss -ua
$ sudo ss -a -A udp
$ sudo ss -nt
$ sudo ss -ltn
$ sudo apt-get install netcat
# Address already in use # nc: Cannot assign requested address # 36523
$ sudo nc -l localhost 36523
# Not in use # 27017
$ sudo nc -l localhost 27017
# control + C
[
$ sudo apt-get remove netcat
$ sudo apt-get purge netcat
# The following packages were automatically installed and are no longer required:
# libpcre2-posix2 netcat-openbsd
# Use 'sudo apt autoremove' to remove them.
$ sudo apt autoremove
]
$ sudo apt-get install nmap
$ sudo nmap -n -PN -sT -sU -p- localhost
[
$ sudo apt-get remove nmap
$ sudo apt-get purge nmap
# The following packages were automatically installed and are no longer required:
# libblas3 liblinear4 liblua5.3-0 libpcap0.8 lua-lpeg nmap-common
# Use 'sudo apt autoremove' to remove them.
$ sudo apt autoremove
]
===========================================================================================================================
# Docker
===========================================================================================================================
$ sudo docker --version
$ sudo docker version
$ sudo docker info
===========================================================================================================================
***************************************************************************************************************************
###########################################################################################################################
###########################################################################################################################
# Amazon Web Services
###########################################################################################################################
***************************************************************************************************************************
# AWS CLI version 2 # aws
***************************************************************************************************************************
% curl "https://awscli.amazonaws.com/AWSCLIV2.pkg" -o "AWSCLIV2.pkg"
% sudo installer -pkg AWSCLIV2.pkg -target /
% aws --version
% where aws
% which aws
% type aws
[
# rm -rf
% ls -l /usr/local/bin/aws
% sudo rm /usr/local/bin/aws
% ls /usr/local/bin/aws_completer
% sudo rm /usr/local/bin/aws_completer
% ls /usr/local/aws-cli
% sudo rm -rf /usr/local/aws-cli
]
***************************************************************************************************************************
# AWS SAM CLI # sam
***************************************************************************************************************************
% sudo installer -pkg "$HOME/Downloads/Software/AWS/AWS SAM CLI/aws-sam-cli-macos-arm64.pkg" -target /
% sam --version
% where sam
% which sam
% type sam
***************************************************************************************************************************
# CLI for Amazon EKS # eksctl
***************************************************************************************************************************
# for ARM systems, set ARCH to: `arm64`, `armv6` or `armv7` # export keyword optional
% arch
# AWS CloudShell
# % export ARCH=amd64
% export ARCH=arm64
% export PLATFORM=$(uname -s)_$ARCH
% curl -sLO "https://github.com/eksctl-io/eksctl/releases/latest/download/eksctl_$PLATFORM.tar.gz"
% curl -sL "https://github.com/eksctl-io/eksctl/releases/latest/download/eksctl_checksums.txt" | grep $PLATFORM | sha256sum --check
% tar -xzf eksctl_$PLATFORM.tar.gz -C /tmp && rm eksctl_$PLATFORM.tar.gz
% sudo mv /tmp/eksctl /usr/local/bin
% eksctl version
% where eksctl
% which eksctl
% type eksctl
[
# rm -rf
% ls /usr/local/bin/eksctl
% sudo rm -rf /usr/local/bin/eksctl
]
***************************************************************************************************************************
# AWS IAM Authenticator for Kubernetes # aws-iam-authenticator
***************************************************************************************************************************
% brew install aws-iam-authenticator
% aws-iam-authenticator version
% where aws-iam-authenticator
% which aws-iam-authenticator
% type aws-iam-authenticator
***************************************************************************************************************************
# Amazon Linux centos rhel fedora
***************************************************************************************************************************
===========================================================================================================================
# Linux centos rhel fedora
===========================================================================================================================
$ sudo cat /etc/os-release
$ sudo cat /etc/*release
$ sudo cat /etc/issue
$ sudo more /etc/issue
$ sudo less /etc/issue
$ sudo cat /proc/version
[
$ sudo hostnamectl
]
$ sudo man hostnamectl
$ sudo uname
$ sudo uname -r
$ sudo uname --release
$ sudo uname -srm
$ sudo uname --kernel-name --kernel-release --kernel-version
$ sudo uname --all
$ sudo uname -amnoprsv
$ sudo man uname
$ sudo grep -E '^(VERSION|NAME)=' /etc/os-release
$ sudo grep '^VERSION' /etc/os-release
$ sudo yum --version
$ sudo rpm --version
$ sudo rpm -qa
$ sudo which rpm
$ sudo man rpm
$ sudo arch
$ id -un
$ sudo id -un
$ whoami
$ sudo whoami
$ echo `whoami`
$ sudo echo $USER
$ sudo echo $HOME
$ sudo echo ~/
$ sudo echo $SHELL
$ sudo echo $PATH
$ sudo env
$ sudo pwd
$ sudo date
$ sudo locale
$ sudo locale -a
$ sudo echo $LC_ALL
$ sudo ls
$ sudo ls -a
$ sudo ls /usr/local/bin
$ sudo ls /usr/bin
$ sudo ls /bin
$ sudo ls /usr/sbin
$ sudo ls /sbin
$ which compgen
$ type compgen
$ man compgen
$ compgen -c
$ compgen -a
$ compgen -b
$ compgen -k
$ compgen -A function
$ compgen -A function -abck
===========================================================================================================================
# Programming Languages
===========================================================================================================================
$ node --version
$ python3 --version
$ perl --version
$ go version
===========================================================================================================================
# Network
===========================================================================================================================
$ sudo yum update
$ sudo yum upgrade
[
$ sudo yum install net-tools
]
$ sudo netstat -tunpl
$ sudo netstat -nr
$ sudo netstat -ai
$ sudo netstat -ant
[
$ sudo yum remove net-tools
]
[
$ sudo yum install iproute iproute-doc
]
$ sudo ss -tunl
$ sudo ss -t
$ sudo ss -A tcp
$ sudo ss -ua
$ sudo ss -a -A udp
$ sudo ss -nt
$ sudo ss -ltn
[
$ sudo yum remove iproute iproute-doc
]
$ sudo yum install nc
# Ncat: bind to 127.0.0.1:36563: Address already in use. QUITTING.
$ sudo nc -l localhost 36563
# Not in use # 27017
$ sudo nc -l localhost 27017
# control + C
[
$ sudo yum remove nc
$ sudo yum erase nc
$ sudo yum autoremove
]
$ sudo yum install nmap
$ sudo nmap -n -PN -sT -sU -p- localhost
[
$ sudo yum remove nmap
$ sudo yum erase nmap
$ sudo yum autoremove
]
===========================================================================================================================
# Docker install
===========================================================================================================================
[
$ sudo yum install -y docker
]
$ sudo amazon-linux-extras install docker
$ sudo docker version
$ sudo dockerd
]
===========================================================================================================================
# Docker
===========================================================================================================================
$ sudo docker --version
$ sudo docker version
$ sudo docker info
===========================================================================================================================
***************************************************************************************************************************
###########################################################################################################################
###########################################################################################################################
# Azure
###########################################################################################################################
***************************************************************************************************************************
# Azure CLI # azure-cli
***************************************************************************************************************************
% python3 --version
% brew install azure-cli
% az --version
% where az
% which az
% type az
% az upgrade
[
% brew uninstall azure-cli
% ls ~/.azure
% rm -rf ~/.azure
]
***************************************************************************************************************************
# Azure Kubelogin # kubelogin
***************************************************************************************************************************
% brew install Azure/kubelogin/kubelogin
% kubelogin --version
% where kubelogin
% which kubelogin
% type kubelogin
[
% brew update %% brew upgrade Azure/kubelogin/kubelogin
]
***************************************************************************************************************************
# Azure Common Base Linux Mariner
***************************************************************************************************************************
===========================================================================================================================
# Linux Mariner
===========================================================================================================================
$ cat /etc/os-release
$ cat /etc/*release
$ cat /etc/issue
$ more /etc/issue
$ less /etc/issue
$ cat /proc/version
$ lsb_release --all
$ lsb_release --description
$ man lsb_release
[
$ hostnamectl
]
$ which hostnamectl
$ type hostnamectl
$ uname
$ uname -r
$ uname --release
$ uname -srm
$ uname --kernel-name --kernel-release --kernel-version
$ uname -amnoprsv
$ uname --all
$ man uname
$ grep -E '^(VERSION|NAME)=' /etc/os-release
$ grep '^VERSION' /etc/os-release
$ yum --version
$ rpm --version
$ rpm -qa
$ which rpm
$ type rpm
$ arch
$ whoami
$ echo `whoami`
$ echo $USER
$ echo $HOSTNAME
$ echo `hostname`
$ echo $HOME
$ echo ~/
$ echo $SHELL
$ echo $PATH
$ env
$ env
$ pwd
$ date
$ locale
$ locale -a
$ echo $LANG
$ ls
$ ls -a
$ ls /usr/local/bin
$ ls /usr/bin
$ ls /bin
$ ls /usr/sbin
$ ls /sbin
$ which compgen
$ type compgen
$ compgen -c
$ compgen -a
$ compgen -b
$ compgen -k
$ compgen -A function
$ compgen -A function -abck
===========================================================================================================================
# Programming Languages
===========================================================================================================================
$ node --version
$ python3 --version
$ ruby --version
$ gcc --version
$ cc --version
$ g++ --version
$ c++ --version
$ java --version
$ mvn --version
$ dotnet --version
$ perl --version
$ go version
===========================================================================================================================
# Network
===========================================================================================================================
$ netstat -tunpl
$ netstat -nr
$ netstat -ai
$ netstat -ant
$ ss -tunl
$ ss -t
$ ss -A tcp
$ ss -ua
$ ss -a -A udp
$ ss -nt
$ ss -ltn
===========================================================================================================================
***************************************************************************************************************************
###########################################################################################################################
###########################################################################################################################
# macOS
###########################################################################################################################
===========================================================================================================================
# Darwin
===========================================================================================================================
% sw_vers
% uname
% uname -amnoprsv
% arch
% arch -x86_64 zsh
% arch -arm64 zsh
% id -F
% sudo id -F
% id -un
% sudo id -un
% whoami
% sudo whoami
% echo `whoami`
% echo $USER
% echo $USERNAME
% echo $HOST
% echo `hostname`
% echo $HOME
% echo ~/
% echo $SHELL
% echo $PATH
$ env
% pwd
% date
% locale
% locale -a
% echo $LC_CTYPE
% ls
% ls -a
% ls /usr/local/bin
% ls /usr/bin
% ls /bin
% ls /usr/sbin
% ls /sbin
% type compgen
% compgen -c
% compgen -a
% compgen -b
% compgen -k
% compgen -A function
% compgen -A function -abck
===========================================================================================================================
###########################################################################################################################
###########################################################################################################################
# Homebrew
###########################################################################################################################
% git --version
% where git
% which git
% type git
% man git
% curl --version
% /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"
# % echo 'eval "$(/opt/homebrew/bin/brew shellenv)"' >> $HOME/.zprofile
% nano ~/.zprofile
eval "$(/opt/homebrew/bin/brew shellenv)"
% cat ~/.zprofile
% brew --version
% brew doctor
% brew doctor `brew doctor --list-checks | grep -v stray_headers`
% brew bundle dump
% brew update
% brew upgrade
% brew outdated
% brew --prefix
% where brew
% which brew
% type brew
% man brew
% brew list
% brew list --cask
# Or
% brew list --casks
% brew deps --tree --installed
% ls ~/Library/Caches/Homebrew/downloads
***************************************************************************************************************************
# openssl
***************************************************************************************************************************
% brew install openssl
[
% brew reinstall openssl@3
]
% openssl --version
% where openssl
% which openssl
% type openssl
% man openssl
***************************************************************************************************************************
# Git
***************************************************************************************************************************
% brew install git
% git version
% where git
% which git
% type git
% man git
***************************************************************************************************************************
# Kubernetes # K8s # kubectl
***************************************************************************************************************************
% brew install kubectl
% kubectl version
% where kubectl
% which kubectl
% type kubectl
% man kubectl
***************************************************************************************************************************
# minikube
***************************************************************************************************************************
% brew install minikube
% minikube version
% where minikube
% which minikube
% type minikube
% eval $(minikube docker-env)
% echo $(minikube docker-env)
% eval $(minikube docker-env -u)
% echo $(minikube docker-env -u)
***************************************************************************************************************************
# multipass # microk8s-vm
***************************************************************************************************************************
% brew install --cask multipass
% multipass version
% where multipass
% which multipass
% type multipass
% multipass launch --name microk8s-vm --memory 4G --disk 40G
% multipass shell microk8s-vm
ubuntu@microk8s-vm:~$ sudo snap install microk8s --classic
ubuntu@microk8s-vm:~$ sudo microk8s.status --wait-ready
ubuntu@microk8s-vm:~$ sudo microk8s.enable dns dashboard registry
ubuntu@microk8s-vm:~$ sudo snap alias microk8s.kubectl kubectl
ubuntu@microk8s-vm:~$ sudo microk8s.disable dashboard dns registry
% multipass stop microk8s-vm
% multipass delete microk8s-vm
% multipass purge
% brew uninstall --zap multipass
***************************************************************************************************************************
# Terraform
***************************************************************************************************************************
% brew tap hashicorp/tap
% brew install hashicorp/tap/terraform
% terraform --version
% where terraform
% which terraform
% type terraform
% touch ~/.zprofile
% terraform -install-autocomplete
***************************************************************************************************************************
# curl update
***************************************************************************************************************************
% brew install curl
% curl --version
% \curl --version
% where curl
% which curl
% type curl
% man curl
% brew reinstall curl
***************************************************************************************************************************
# wget update
***************************************************************************************************************************
% brew install wget
% wget --version
% where wget
% which wget
% type wget
% man wget
% brew reinstall wget
***************************************************************************************************************************
# jq # JSON processor
***************************************************************************************************************************
% brew install jq
% jq --version
% where jq
% which jq
% type jq
% man jq
***************************************************************************************************************************
# youtube-dl
***************************************************************************************************************************
% brew install youtube-dl
% youtube-dl --version
% where youtube-dl
% which youtube-dl
% type youtube-dl
% man youtube-dl
***************************************************************************************************************************
# tree # list contents of directories in a tree-like format
***************************************************************************************************************************
% brew install tree
% tree --version
% where tree
% which tree
% type tree
% man tree
***************************************************************************************************************************
***************************************************************************************************************************
# Beyond Compare
***************************************************************************************************************************
% brew install --cask beyond-compare
% bcomp
% brew uninstall --cask beyond-compare
***************************************************************************************************************************
###########################################################################################################################
###########################################################################################################################
# MacPorts # pkg
###########################################################################################################################
% port version
% where port
% which port
% type port
% man port
% sudo port -v selfupdate
###########################################################################################################################
###########################################################################################################################
# Node.js
###########################################################################################################################
[
% ls ~/.nvm
% sudo rm -rf ~/.nvm
]
% curl -o- https://raw.githubusercontent.com/nvm-sh/nvm/v0.39.7/install.sh | bash
% nano ~/.zprofile
export NVM_DIR="$HOME/.nvm"
[ -s "$NVM_DIR/nvm.sh" ] && \. "$NVM_DIR/nvm.sh" # This loads nvm
[ -s "$NVM_DIR/bash_completion" ] && \. "$NVM_DIR/bash_completion" # This loads nvm bash_completion
% cat ~/.zprofile
# Terminal New Window
% nvm --version
% where nvm
% which nvm
% type nvm
% nvm list
[
% nvm install node
]
% brew install node
% node --version
% where node
% which node
% type node
% man node
# REPL
% node
> process.version
> .exit
[
% brew uninstall node
% brew uninstall node --ignore-dependencies
]
% npx --version
% npx update --global
[
% npx outdated --global
]
% where npx
% which npx
% type npx
% man npx
# Server
% npm --version
% npm install http-server --global
% http-server
# Or
% http-server -p 8080
http://127.0.0.1:8080
http://192.168.1.33:8080
% npm uninstall http-server --global
% npm update --global
% npm upgrade --global
% npm outdated --global
% npm install npm --global
% npm view node
% npm view node version
% npm show node
% npm show node version
% npm list --global
% npm list
% npm view npm
% npm view npm version
% npm show npm
% npm show npm version
% npm view corepack
% npm view corepack version
% npm show corepack
% npm show corepack version
% where npm
% which npm
% type npm
% man npm
[
% ls ~/.npm
% sudo rm -rf ~/.npm
]
% npm prune
% npm install yarn --global
[
% npm update yarn
]
% yarn --version
% where yarn
% which yarn
% type yarn
[
# package.json
% yarn install --check-files
]
% yarnpkg --version
% where yarnpkg
% which yarnpkg
% type yarnpkg
% npm install gulp --global
[
% npm update gulp
]
% gulp --version
% where gulp
% which gulp
% type gulp
[
% npm uninstall gulp --global
]
% npm install n --global
[
% npm update n
]
% n --version
% where n
% which n
% type n
% man n
[
% sudo n latest
% sudo n prune
% sudo npm uninstall n --global
% ls /usr/local/n
% sudo rm -rf /usr/local/n
% ls /usr/local/bin/node
% sudo rm -rf /usr/local/bin/node
]
[
# package.json
% npm run-script
% npm install npm-add-script --global
% npmAddScript -k start -v "node index.js"
% npm uninstall npm-add-script --global
]
% npm install pnpm --global
[
% npm update pnpm
]
% pnpm --version
% pnpm setup
% source ~/.zshrc
# Terminal New Window
% pnpm update --global
% pnpm upgrade --global
% pnpm outdated --global
% pnpm install --global pnpm
% where pnpm
% which pnpm
% type pnpm
% pnpm prune
###########################################################################################################################
###########################################################################################################################
# Python # pkg
###########################################################################################################################
% python3 --version
% where python3
% which python3
% type python3
% man python3
# REPL
% python3
> __import__("sys").version
> exit()
# Server
% python3 -m http.server
# Or
% python3 -m http.server 8000
http://[::]:8000/
% pip3 --version
# Or
% python3 -m pip --version
% pip3 install --upgrade pip
# Or
% python3 -m pip install --upgrade pip
% where pip3
% which pip3
% type pip3
% pip3 list
# Or
% python3 -m pip3 list
% pip3 install tensorflow
# Or
% python3 -m pip uninstall tensorflow
# install specific version of a package
% pip install numpy==1.26.2
# Or
% python3 -m pip install numpy==1.26.2
[
% pip uninstall numpy==1.26.2
# Or
% python3 -m pip uninstall numpy==1.26.2
]
# install latest version of a package
% pip3 install pandas --upgrade
# Or
% python3 -m pip install pandas --upgrade
[
% pip3 uninstall pandas
# Or
% python3 -m pip uninstall pandas
]
[
% pip freeze
% pip freeze > requirements.txt
% cat requirements.txt
% rm -rf requirements.txt
% ls requirements.txt
]
# https://pypi.org/search
% pip3 install poetry
% poetry search pipreqs
% pip3 install pipreqs
% python3 -m pip show pipreqs
% pipreqs --version
% where pipreqs
% which pipreqs
% type pipreqs
# cd from ~ %
% cd ~/Desktop
% nano py-requests.py
import requests
print(requests.__version__)
% python3 py-requests.py
% python3 -m pip show requests
% pipreqs
% pipreqs --force
% cat requirements.txt
% rm -rf requirements.txt
% ls requirements.txt
]
% ls /Library/Frameworks/Python.framework/Versions
# Current
% ls /Library/Frameworks/Python.framework/Versions/Current
% ls /Library/Frameworks/Python.framework/Versions/Current/lib
% ls /Library/Frameworks/Python.framework/Versions/Current/lib/python3.11/site-packages
% ls /Library/Frameworks/Python.framework/Versions/Current/bin
# 3.11
% ls /Library/Frameworks/Python.framework/Versions/3.11
% ls /Library/Frameworks/Python.framework/Versions/3.11/lib
% ls /Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages
% ls /Library/Frameworks/Python.framework/Versions/3.11/bin
# 3.10
% ls /Library/Frameworks/Python.framework/Versions/3.10
% ls /Library/Frameworks/Python.framework/Versions/3.10/lib
% ls /Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages
% ls /Library/Frameworks/Python.framework/Versions/3.10/bin
***************************************************************************************************************************
# pgadmin4
***************************************************************************************************************************
% sudo mkdir -p /var/lib/pgadmin
% ls /var/lib/pgadmin
[
% sudo rm -rf /var/lib/pgadmin
]
% sudo mkdir -p /var/log/pgadmin
% ls /var/log/pgadmin
[
% sudo rm -rf /var/log/pgadmin
]
% sudo chown $USER /var/lib/pgadmin
% sudo chown $USER /var/log/pgadmin
[
% python3 -m venv pgadmin4
% source pgadmin4/bin/activate
# (pgadmin4) % pip3 install pgadmin4
# (pgadmin4) % where pgadmin4
# (pgadmin4) % which pgadmin4
# (pgadmin4) % type pgadmin4
# (pgadmin4) % pgadmin4
]
% pip3 install pgadmin4
% where pgadmin4
% which pgadmin4
% type pgadmin4
% pgadmin4
# pgadmin$4
[
NOTE: Configuring authentication for SERVER mode.
Enter the email address and password to use for the initial pgAdmin user account:
Email address: pgadmin4@example.com
Password: *********
Retype password: *********
]
[
% pip3 uninstall pgadmin4
% ls /var/lib/pgadmin
% sudo rm -rf /var/lib/pgadmin
% ls /var/log/pgadmin
% sudo rm -rf /var/log/pgadmin
]
***************************************************************************************************************************
# Django
***************************************************************************************************************************
% python3 -m pip install django
% python3 -m django --version
% django-admin --version
% where django-admin
% which django-admin
% type django-admin
***************************************************************************************************************************
###########################################################################################################################
###########################################################################################################################
# Java
###########################################################################################################################
***************************************************************************************************************************
# OpenJDK # /etc/paths # prepend path to # jdk-22.0.1.jdk/Contents/Home/bin
***************************************************************************************************************************
% java --version
% where java
% which java
% type java
% jshell --version
% where jshell
% which jshell
% type jshell
# REPL
% jshell
> System.getProperty("java.version")
> /exit
# Server
% jwebserver
# Or
% jwebserver --port 8888
http://127.0.0.1:8000/
# rm Java
% ls /Library/Java/JavaVirtualMachines
% ls /Library/Java
% ls /Library
% sudo rm -rf /Library/Java
% ls /Library
# NB
Do not attempt to uninstall Java by removing the Java tools from /usr/bin. This directory is part of the system software and any changes will be reset by Apple the next time that you perform an update of the OS.
***************************************************************************************************************************
# Gradle # /etc/paths # prepend path to # gradle-8.2.1/bin # requires Java Runtime # prepend path to # jdk-22.0.1.jdk/Contents/Home/bin
***************************************************************************************************************************
% gradle --version
% where gradle
% which gradle
% type gradle
***************************************************************************************************************************
# Apache Maven # /etc/paths # prepend path to # apache-maven-3.9.3/bin # requires Java Runtime # prepend path to # jdk-22.0.1.jdk/Contents/Home/bin
***************************************************************************************************************************
% mvn --version
% where mvn
% which mvn
% type mvn
***************************************************************************************************************************
# JAVA_HOME # M2_HOME # M2 # PATH # MAVEN_OPTS
***************************************************************************************************************************
% export JAVA_HOME="$HOME/Downloads/Software/OpenJDK/JDK22.0.1/jdk-22.0.1.jdk/Contents/Home"
% export M2_HOME="$HOME/Downloads/Software/ApacheMaven/apache-maven-3.9.3"
% export M2="$M2_HOME/bin"
% export PATH=$PATH:"$M2:$JAVA_HOME/bin"
% export MAVEN_OPTS="-Xms256m -Xmx512m"
% java --version
% mvn --version
***************************************************************************************************************************
# Java # Gradle # Apache Maven
***************************************************************************************************************************
% export PATH="$HOME/Downloads/Software/OpenJDK/JDK22.0.1/jdk-22.0.1.jdk/Contents/Home//bin/:$HOME/Downloads/Software/Gradle/gradle-8.2.1/bin/:$HOME/Downloads/Software/ApacheMaven/apache-maven-3.9.3/bin/":$PATH
% java --version
% gradle --version
% mvn --version
***************************************************************************************************************************
# JAVA_HOME # Apache Tomcat
***************************************************************************************************************************
% export JAVA_HOME="$HOME/Downloads/Software/OpenJDK/JDK22.0.1/jdk-22.0.1.jdk/Contents/Home/"
% cd "$HOME/Downloads/Software/ApacheTomcat/apache-tomcat-10.1.11/bin"
% ./startup.sh
% open http://localhost:8080/
% ./shutdown.sh
***************************************************************************************************************************
# Supersede existing Java installation # Suffix :$PATH
***************************************************************************************************************************
% export PATH="$HOME/Downloads/Software/OpenJDK/JDK20.0.2/jdk-20.0.2.jdk/Contents/Home/bin/":$PATH
***************************************************************************************************************************
###########################################################################################################################
###########################################################################################################################
# .NET
###########################################################################################################################
***************************************************************************************************************************
# dotnet # SDK pkg # installs [.NET SDK + .NET Runtime + ASP.NET Core Runtime]
***************************************************************************************************************************
% dotnet --version
% where dotnet
% which dotnet
% type dotnet
% dotnet --list-sdks
% dotnet --list-runtimes
% dotnet --info
% dotnet --help
% dotnet --diagnostics
% dotnet nuget --version
% where dotnet nuget
% which dotnet nuget
% type dotnet nuget
% dotnet fsi --version
% dotnet fsi '/langversion:?'
# REPL
% dotnet fsi
> System.Environment.Version;;
> System.Runtime.InteropServices.RuntimeInformation.FrameworkDescription;;
> #quit;;
# SDK
% ls /usr/local/share/dotnet/sdk/$version/
% ls /usr/local/share/dotnet/x64/
% ls /usr/local/share/dotnet/x64/sdk/$version/
# Runtime
% ls /usr/local/share/dotnet/shared/$product/$version
% ls /usr/local/share/dotnet/x64/shared/$product/$version
# .NET host
% ls /usr/local/share/dotnet/host/fxr/$version/
% ls /usr/local/share/dotnet/x64/host/fxr/$version/
# rm dotnet
% ls /usr/local/share/dotnet
% sudo rm -rf /usr/local/share/dotnet
% ls /usr/local/share
% ls /etc/paths.d/dotnet
% cat /etc/paths.d/dotnet
% sudo rm -rf /etc/paths.d/dotnet
% ls /etc/paths.d/
% ls /etc/paths.d/dotnet-cli-tools
% cat /etc/paths.d/dotnet-cli-tools
% sudo rm -rf /etc/paths.d/dotnet-cli-tools
% ls /etc/paths.d/
***************************************************************************************************************************
# Supersede existing dotnet arm64 with x64
***************************************************************************************************************************
# dotnet arm64
% ls /usr/local/share/dotnet/sdk
# dotnet x64
% ls /usr/local/share/dotnet/x64/sdk
% export PATH="/usr/local/share/dotnet/x64/":$PATH
***************************************************************************************************************************
# Visual Studio Code CLI # /etc/paths # prepend path to # vscode_cli_darwin_arm64_cli/code
***************************************************************************************************************************
% code --version
% where code
% which code
% type code
***************************************************************************************************************************
# Mono # MDK pkg
***************************************************************************************************************************
% fsharpi --help
% where fsharpi
% which fsharpi
% type fsharpi
% fsharpi '/langversion:?'
# REPL
% fsharpi
> System.Environment.Version;;
> System.Runtime.InteropServices.RuntimeInformation.FrameworkDescription;;
> #quit;;
% csc -version
% where csc
% which csc
% type csc
% csc '/langversion:?'
% csi -version
% where csi
% which csi
% type csi
% csi '/langversion:?'
# REPL
% csi
> System.Environment.Version
> System.Runtime.InteropServices.RuntimeInformation.FrameworkDescription
Ctrl-C
% csharp --version
% where csharp
% which csharp
% type csharp
# REPL
% csharp
> System.Environment.Version;
> System.Runtime.InteropServices.RuntimeInformation.FrameworkDescription;
> quit;
% vbc -version
% where vbc
% which vbc
% type vbc
% vbc '/langversion:?'
% mono --version
% where mono
% which mono
% type mono
% man mono
% mcs -about
% mcs --version
% where mcs
% which mcs
% type mcs
% man mcs
% nuget
% nuget help
% where nuget
% which nuget
% type nuget
# nuget update
% brew install nuget
# rm Mono.framework
% ls /Library/Frameworks/Mono.framework
% sudo rm -rf /Library/Frameworks/Mono.framework
% ls /Library/Frameworks
% sudo pkgutil --forget com.xamarin.mono-MDK.pkg
% ls /etc/paths.d/mono-commands
% cat /etc/paths.d/mono-commands
% sudo rm -rf /etc/paths.d/mono-commands
% ls /etc/paths.d/
***************************************************************************************************************************
# PowerShell
***************************************************************************************************************************
% brew install powershell/tap/powershell
% pwsh --version
% where pwsh
% which pwsh
% type pwsh
# REPL
% pwsh
> $host
> $host.Version
> $PSVersionTable
> help
> exit
***************************************************************************************************************************
###########################################################################################################################
###########################################################################################################################
# Ruby on Rails
###########################################################################################################################
% brew install ruby
% nano ~/.zprofile
if [ -d "/opt/homebrew/opt/ruby/bin" ]; then
export PATH=/opt/homebrew/opt/ruby/bin:$PATH
export PATH=`gem environment gemdir`/bin:$PATH
fi
% cat ~/.zprofile
% brew pin ruby
% ruby --version
% where ruby
% which ruby
% type ruby
% man ruby
% irb --version
% where irb
% which irb
% type irb
% man irb
# REPL
% irb
> RUBY_DESCRIPTION
> exit
# Server
% ruby -run -e httpd
# Or
% ruby -run -e httpd . -p 8000
http://127.0.0.1:8080
% gem --version
% gem update
% gem update --system
% where gem
% which gem
% type gem
% man gem
[
% bundler install
]
% bundler --version
% where bundler
% which bundler
% type bundler
[
% nano Gemfile
[
source "https://rubygems.org"
ruby "3.2.2"
gem 'nokogiri', '~> 1.15', '>= 1.15.4'
gem 'rack', '~> 3.0', '>= 3.0.8'
gem 'rspec', '~> 3.12'
]
% cat Gemfile
% bundler install
Resolving dependencies...
Fetching gem metadata from https://rubygems.org/.......
Bundle complete! 3 Gemfile dependencies, 10 gems now installed.
Use `bundle info [gemname]` to see where a bundled gem is installed.
% cat Gemfile.lock
% bundler config set --local frozen 'true'
]
[
% bundle install
]
% bundle --version
% where bundle
% which bundle
% type bundle
% man bundle
[
% nano Gemfile
[
source "https://rubygems.org"
ruby "3.2.2"
gem 'nokogiri', '~> 1.15', '>= 1.15.4'
gem 'rack', '~> 3.0', '>= 3.0.8'
gem 'rspec', '~> 3.12'
]
% cat Gemfile
% bundle install
Fetching gem metadata from https://rubygems.org/.......
Resolving dependencies...
Bundle complete! 3 Gemfile dependencies, 10 gems now installed.
Use `bundle info [gemname]` to see where a bundled gem is installed.
% cat Gemfile.lock
% bundle config set --local frozen 'true'
]
% rake --version
% where rake
% which rake
% type rake
% gem install rails
# Restart terminal window
% rails --version
% where rails
% which rails
% type rails
# rvm
% curl -sSL https://get.rvm.io | bash -s stable
# Restart terminal window
% rvm --version
% where rvm
% which rvm
% type rvm
% man rvm
% rvm install "ruby-3.2.2" --with-openssl-dir="$(brew --prefix)/opt/openssl@1.1/"
% ruby --version
% gem --version
% gem update
% gem update --system
% bundler --version
% bundle --version
% rake --version
% gem install rails
% rails --version
# rbenv
% brew install rbenv
# % echo 'eval "$(rbenv init -)"' >> $HOME/.zprofile
% nano ~/.zprofile
eval "$(rbenv init -)"
% cat ~/.zprofile
% source ~/.zprofile
% type rbenv
% rbenv --version
% rbenv install -l
% rbenv install 3.2.2
% rbenv global 3.2.2
% ruby --version
% gem --version
% gem update
% gem update --system
% echo "gem: --no-document" > ~/.gemrc
% bundler --version
% bundle --version
% rake --version
% gem env home
% gem install rails
% rails --version
% gem search '^rails$' --all
# % gem install rails --version 6.1.7.6
# For a new version of Ruby or a gem
# % rbenv rehash
% brew upgrade rbenv ruby-build
# Uninstall Ruby version 3.0.6
# % rbenv uninstall 3.0.6
# % sed -in-place '/eval "$(rbenv init -)"/d' $HOME/.zprofile
# % nano ~/.zprofile
eval "$(rbenv init -)"
# % cat ~/.zprofile
# % source ~/.zprofile
# % rm -rf `rbenv root`
# % brew uninstall rbenv
###########################################################################################################################
###########################################################################################################################
# GCC
###########################################################################################################################
% brew install gcc
% gcc --version
% where gcc
% which gcc
% type gcc
% cc --version
% where cc
% which cc
% type cc
% g++ --version
% where g++
% which g++
% type g++
% c++ --version
% where c++
% which c++
% type c++
###########################################################################################################################
###########################################################################################################################
# Swift
###########################################################################################################################
% swift --version
% where swift
% which swift
% type swift
% man swift
# REPL
% swift
> :version
> :exit
% swiftc --version
% where swiftc
% which swiftc
% type swiftc
###########################################################################################################################
###########################################################################################################################
# Perl
###########################################################################################################################
% perl --version
% where perl
% which perl
% type perl
% man perl
% perldoc -Version
# REPL
% perl -de1
> print "$]\n";
> q
% cpan -V
% where cpan
% which cpan
% type cpan
% man cpan
# REPL
% cpan
> help
> quit
# Or
> exit
###########################################################################################################################
###########################################################################################################################
# PHP
###########################################################################################################################
[
# You must `brew unpin ruby` as installing php requires the latest version of pinned dependencies
% brew unpin ruby
]
% brew install php
% php --version
% where php
% which php
% type php
% man php
% brew services start php
% brew services restart php
% brew services stop php
# REPL
% php -a
> print phpversion();
> exit
# Server
% php -S 127.0.0.1:8000
# composer
% brew install composer
% composer --version
% where composer
% which composer
% type composer
###########################################################################################################################
###########################################################################################################################
# MongoDB
###########################################################################################################################
% brew --version
% brew update
% brew upgrade
% brew --prefix
% brew tap mongodb/brew
[
% brew untap mongodb/brew && brew tap mongodb/brew
]
%
# % brew install mongodb-community
% mongod --version
% where mongod
% which mongod
% type mongod
% brew services start mongodb-community
% brew services list
% ps aux | grep -v grep | grep mongod
[
% brew services stop mongodb-community
% brew services restart mongodb-community
]
[
% brew uninstall mongodb-community
% ls /opt/homebrew/var/log/mongodb/mongo.log
% cat /opt/homebrew/var/log/mongodb/mongo.log
% rm -rf /opt/homebrew/var/log/mongodb/mongo.log
% ls /opt/homebrew/var/log/mongodb
% rm -rf /opt/homebrew/var/log/mongodb
% ls /opt/homebrew/var/mongodb
% rm -rf /opt/homebrew/var/mongodb
% ls /opt/homebrew/var/homebrew/linked/mongodb-database-tools
% rm -rf /opt/homebrew/var/homebrew/linked/mongodb-database-tools
% ls /opt/homebrew/var/homebrew/linked/mongosh
% rm -rf /opt/homebrew/var/homebrew/linked/mongosh
% ls /opt/homebrew/etc/mongod.conf
% rm -rf /opt/homebrew/etc/mongod.conf
% ls /opt/homebrew/Cellar/mongodb-database-tools
% rm -rf /opt/homebrew/Cellar/mongodb-database-tools
% ls /opt/homebrew/Cellar/mongosh
% rm -rf /opt/homebrew/Cellar/mongosh
% ls /opt/homebrew/opt/mongodb-database-tools
% rm -rf /opt/homebrew/opt/mongodb-database-tools
% ls /opt/homebrew/opt/mongosh
% rm -rf /opt/homebrew/opt/mongosh
# mongod # mongodump # mongoexport # mongofiles # mongoimport # mongorestore # mongos # mongosh # mongostat # mongotop
% ls /opt/homebrew/bin/mongod
% rm -rf /opt/homebrew/bin/mongod
% ls /opt/homebrew/bin/mongodump
% rm -rf /opt/homebrew/bin/mongodump
% ls /opt/homebrew/bin/mongoexport
% rm -rf /opt/homebrew/bin/mongoexport
% ls /opt/homebrew/bin/mongofiles
% rm -rf /opt/homebrew/bin/mongofiles
% ls /opt/homebrew/bin/mongoimport
% rm -rf /opt/homebrew/bin/mongoimport
% ls /opt/homebrew/bin/mongorestore
% rm -rf /opt/homebrew/bin/mongorestore
% ls /opt/homebrew/bin/mongos
% rm -rf /opt/homebrew/bin/mongos
% ls /opt/homebrew/bin/mongosh
% rm -rf /opt/homebrew/bin/mongosh
% ls /opt/homebrew/bin/mongostat
% rm -rf /opt/homebrew/bin/mongostat
% ls /opt/homebrew/bin/mongotop
% rm -rf /opt/homebrew/bin/mongotop
]
# log file
/opt/homebrew/var/log/mongodb/mongo.log
# log directory
/opt/homebrew/var/log/mongodb
# data directory
/opt/homebrew/var/mongodb
# configuration file
/opt/homebrew/etc/mongod.conf
[
% ls /opt/homebrew/var
% ls /opt/homebrew/var/mongodb
% ls /opt/homebrew/var/log
% ls /opt/homebrew/var/log/mongodb/mongo.log
% ls /opt/homebrew/var/log/mongodb
% ls /opt/homebrew/var/homebrew/linked
% ls /opt/homebrew/var/homebrew/linked/mongodb-community
% ls /opt/homebrew/var/homebrew/linked/mongodb-database-tools
% ls /opt/homebrew/var/homebrew/linked/mongosh
% ls /opt/homebrew/etc
% ls /opt/homebrew/etc/mongod.conf
% ls /opt/homebrew/Cellar
% ls /opt/homebrew/Cellar/mongodb-community
% ls /opt/homebrew/Cellar/mongodb-database-tools
% ls /opt/homebrew/Cellar/mongosh
% ls /opt/homebrew/opt
% ls /opt/homebrew/opt/mongodb-community
% ls /opt/homebrew/opt/mongodb-community@7.0
% ls /opt/homebrew/opt/mongodb-database-tools
% ls /opt/homebrew/opt/mongosh
]
# mongod # mongodump # mongoexport # mongofiles # mongoimport # mongorestore # mongos # mongosh # mongostat # mongotop
% ls /opt/homebrew/bin
# % pgrep mongo # % pkill mongo
# % pgrep mongod # % pkill mongod
# % ps -A | grep mongod | awk '{print $1}' # kill <mongod pid>
# % ps aux | grep -v grep | grep mongod # kill <mongod pid>
# % ps aux | grep -v grep | grep mongod | awk '{print $2}' # kill <mongod pid>
% ls /opt/homebrew/var/mongodb
% ls /opt/homebrew/var/log/mongodb/mongo.log
% mongod --dbpath /opt/homebrew/var/mongodb --logpath /opt/homebrew/var/log/mongodb/mongo.log --fork
# % pgrep mongo # % pkill mongo
# % pgrep mongod # % pkill mongod
# % ps -A | grep mongod | awk '{print $1}' # kill <mongod pid>
# % ps aux | grep -v grep | grep mongod # kill <mongod pid>
# % ps aux | grep -v grep | grep mongod | awk '{print $2}' # kill <mongod pid>
% ls /opt/homebrew/etc/mongod.conf
% sudo nano /opt/homebrew/etc/mongod.conf
% cat /opt/homebrew/etc/mongod.conf
% mongod --config /opt/homebrew/etc/mongod.conf --fork
% mongosh --version
% where mongosh
% which mongosh
% type mongosh
# REPL
% mongosh
> db.version()
> exit
% mongos --version
% where mongos
% which mongos
% type mongos
% mongoimport --version
% where mongoimport
% which mongoimport
% type mongoimport
% mongoexport --version
% where mongoexport
% which mongoexport
% type mongoexport
% mongodump --version
% where mongodump
% which mongodump
% type mongodump
% mongotop --version
% where mongotop
% which mongotop
% type mongotop
###########################################################################################################################
###########################################################################################################################
# SQLite
###########################################################################################################################
# sqlite3
% brew install sqlite3
% sqlite3 --version
% where sqlite3
% which sqlite3
% type sqlite3
% man sqlite3
# REPL
% sqlite3
> .version
> SELECT sqlite_version();
> .exit
###########################################################################################################################
###########################################################################################################################
# PostgreSQL
###########################################################################################################################
% brew install postgresql@16
# Restart terminal window
% brew services start postgresql@16
[
% ls /opt/homebrew/var/log
% ls /opt/homebrew/var/log/postgresql@16.log
% cat /opt/homebrew/var/log/postgresql@16.log
% ls /opt/homebrew/var/
% ls /opt/homebrew/var/postgresql@16
% ls /opt/homebrew/Cellar
% ls /opt/homebrew/Cellar/postgresql@16
% ls /opt/homebrew/Cellar/postgresql@16/16.1
% ls /opt/homebrew/opt
% ls /opt/homebrew/opt/postgresql@16
# postgres # psql # pgbench
% ls /opt/homebrew/opt/postgresql@16/bin
]
# % whoami
% export PATH=$PATH:"/opt/homebrew/opt/postgresql@16/bin"
# % createdb `whoami`
# role "postgres"
# % createuser -s postgres
% psql --version
% where psql
% which psql
% type psql
% man psql
# REPL
% psql
# SELECT version();
# exit
% psql -U postgres -l
[
% dropdb `whoami`
]
% dropdb `whoami` && createdb `whoami`
[
% brew services stop postgresql@16
% brew services restart postgresql@16
]
% locale -a
% locale
% export PGDATA="/opt/homebrew/var/postgresql@16"
% export LC_ALL="en_US"
% postgres --version
% where postgres
% which postgres
% type postgres
% man postgres
% postgres
# In another terminal
% psql
% pgbench --version
% where pgbench
% which pgbench
% type pgbench
% man pgbench
% pgbench -i `whoami`
% pgbench
[
% brew uninstall postgresql@16
% ls /opt/homebrew/var/log/postgresql@16.log
% cat /opt/homebrew/var/log/postgresql@16.log
% rm -r /opt/homebrew/var/log/postgresql@16.log
% ls /opt/homebrew/var/postgresql@16
% rm -r /opt/homebrew/var/postgresql@16
[
% ls /opt/homebrew/Cellar/postgresql@16
% rm -r /opt/homebrew/Cellar/postgresql@16
% ls /opt/homebrew/opt/postgresql@16
% rm -r /opt/homebrew/opt/postgresql@16
]
]
###########################################################################################################################
###########################################################################################################################
# MySQL
###########################################################################################################################
# brew install mysql
% mysql --version
% where mysql
% which mysql
% type mysql
% man mysql
% brew services start mysql
[
% ls /opt/homebrew/var/
% ls /opt/homebrew/var/mysql
% ls /opt/homebrew/Cellar
% ls /opt/homebrew/Cellar/mysql
% ls /opt/homebrew/Cellar/mysql/8.1.0
% ls /opt/homebrew/opt
% ls /opt/homebrew/opt/mysql
# mysql # mysql.server # mysqladmin
% ls /opt/homebrew/opt/mysql/bin
]
# NB: If root password was not set during mysql installation, then the password is blank.
# REPL
% mysql -u root
> SELECT VERSION();
> exit
[
% brew services stop mysql
% brew services restart mysql
]
% sudo mysql.server start
% sudo mysql.server stop
% mysqladmin -u root status
###########################################################################################################################
###########################################################################################################################
# MySQL Shell # mysql-shell-8.2.0-macos13-arm64.dmg
###########################################################################################################################
% mysqlsh --version
% where mysqlsh
% which mysqlsh
% type mysqlsh
# NB: If root password was not set during mysql installation, then the password is blank.
# REPL
% mysqlsh
> \sql
> \connect root@localhost:3306
> SELECT VERSION();
> \exit
[
# mysqlsh
% ls /usr/local/bin
]
###########################################################################################################################
###########################################################################################################################
# SQL Server 2022 # Docker # Rosetta
###########################################################################################################################
% docker version
# Find the “Features in development” option, and select the “Use Rosetta for x86/amd64 emulation on Apple Silicon” checkbox
[
# WARNING: The requested image's platform (linux/amd64) does not match the detected host platform (linux/arm64/v8) and no specific platform was requested
]
% docker pull mcr.microsoft.com/mssql/server:2022-latest
# $QL$erver@2022
% docker run -d --name mssql -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=**************' -p 1433:1433 mcr.microsoft.com/mssql/server:2022-latest
# Azure SQL Edge
% docker pull mcr.microsoft.com/azure-sql-edge:latest
# @zure$QLEdge1433
% docker run --cap-add SYS_PTRACE -e 'ACCEPT_EULA=1' -e 'MSSQL_SA_PASSWORD=****************' -p 1433:1433 --name azuresqledge -d mcr.microsoft.com/azure-sql-edge
###########################################################################################################################
###########################################################################################################################
# SQL Server command-line query tool # sql-cli
###########################################################################################################################
% npm show sql-cli
% npm show sql-cli version
% npm view sql-cli
% npm view sql-cli version
% npm install sql-cli --global
% mssql --version
% where mssql
% which mssql
% type mssql
% man mssql
# REPL
% mssql -u sa -p
> SELECT @@VERSION;
> .quit
[
% poetry search mssql-cli
% pip install mssql-cli
% python3 -m pip install mssql-cli
% mssql-cli --version
]
% pip3 install mssql
% mssql --version
% where mssql
% which mssql
% type mssql
[
# mssql
% ls ~/.nvm/versions/node/v20.9.0/bin
]
###########################################################################################################################
###########################################################################################################################
# Oracle Database 23c Free Release 23.0.0.0.0 # Docker # Lima # Ubuntu
###########################################################################################################################
# Lima # Ubuntu # Docker # Oracle
% brew install lima
% lima --version
% limactl --version
% limactl start
# Select
Open an editor to review or modify the current configuration
# Using the default editor (vi) modify the arch field to the following (i to enter insert mode, make the change, ESC to enter command mode, :wq to exit and save)
arch: "x86_64"
# Run the newly created default Lima VM, and change directories to the new VM's home directory. (All commands past this should be run in the newly started shell unless specified otherwise)
% lima
$
***************************************************************************************************************************
# Install Docker for Ubuntu in the Lima VM
***************************************************************************************************************************
# $
$ ls
# Install Docker Engine on Ubuntu
# Run the following command to uninstall all conflicting packages:
$ for pkg in docker.io docker-doc docker-compose docker-compose-v2 podman-docker containerd runc; do sudo apt-get remove $pkg; done
# Set up Docker's apt repository.
# Add Docker's official GPG key:
$ sudo apt-get update
$ sudo apt-get install ca-certificates curl gnupg
[
Package configuration
┌────┤ Daemons using outdated libraries ├─────┐
│ │
│ │
│ Which services should be restarted? │
│ │
│ [*] packagekit.service │
│ │
│ │
│ <Ok> <Cancel> │
│ │
└─────────────────────────────────────────────┘
]
<ok>
$ sudo install -m 0755 -d /etc/apt/keyrings
$ curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo gpg --dearmor -o /etc/apt/keyrings/docker.gpg
$ sudo chmod a+r /etc/apt/keyrings/docker.gpg
# Add the repository to Apt sources:
$ echo \
"deb [arch="$(dpkg --print-architecture)" signed-by=/etc/apt/keyrings/docker.gpg] https://download.docker.com/linux/ubuntu \
"$(. /etc/os-release && echo "$VERSION_CODENAME")" stable" | \
sudo tee /etc/apt/sources.list.d/docker.list > /dev/null
$ sudo apt-get update
***************************************************************************************************************************
# Ubuntu
***************************************************************************************************************************
$ sudo cat /etc/os-release
$ sudo cat /etc/*release
$ sudo cat /etc/*version
$ sudo cat /etc/issue
$ sudo more /etc/issue
$ sudo less /etc/issue
$ sudo cat /proc/version
$ sudo lsb_release --all
$ sudo lsb_release --description
$ sudo man lsb_release
$ sudo hostnamectl
$ which hostnamectl
$ type hostnamectl
$ sudo man hostnamectl
$ sudo uname -r
$ sudo uname --release
$ sudo uname -srm
$ sudo uname --kernel-name --kernel-release --kernel-version
$ sudo uname --all
$ sudo man uname
$ sudo grep -E '^(VERSION|NAME)=' /etc/os-release
$ sudo grep '^VERSION' /etc/os-release
$ sudo dpkg -l
$ sudo which dpkg
$ sudo man dpkg
$ sudo arch
$ sudo whoami
$ whoami
$ sudo echo `whoami`
$ sudo echo $USER
$ sudo echo $PATH
$ sudo echo $HOME
$ sudo echo ~/
$ sudo echo $SHELL
$ sudo env
$ sudo pwd
$ sudo ls
$ sudo ls -a
$ sudo date
$ sudo locale
$ sudo locale -a
***************************************************************************************************************************
# Docker
***************************************************************************************************************************
# Install the Docker packages
$ sudo apt-get install docker-ce docker-ce-cli containerd.io docker-buildx-plugin docker-compose-plugin
# Verify that the Docker Engine installation is successful by running the hello-world image.
$ sudo docker run hello-world
# Add your user to the docker group, and activate the changes to be able to run docker commands without root access
$ sudo usermod -aG docker $USER
$ newgrp docker
# Run Image from docker hub
$ docker login
$ docker pull container-registry.oracle.com/database/free:latest
$ docker image list
[
REPOSITORY TAG IMAGE ID CREATED SIZE
container-registry.oracle.com/database/free latest 39cabc8e6db0 2 months ago 9.16GB
hello-world latest 9c7a54a9a43c 6 months ago 13.3kB
]
$ docker run -d -p 1521:1521 -e ORACLE_PASSWORD=Oracle_23c container-registry.oracle.com/database/free:latest
$ docker container list --all --format "table"
[
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
a2162156edd5 container-registry.oracle.com/database/free:latest "/bin/bash -c $ORACL…" About a minute ago Up About a minute (health: starting) 0.0.0.0:1521->1521/tcp, :::1521->1521/tcp angry_wing
d39603b235cb hello-world "/hello" 25 minutes ago Exited (0) 25 minutes ago charming_wilson
]
***************************************************************************************************************************
$ docker exec -it a2162156edd5 bash
***************************************************************************************************************************
bash-4.4$ ls
setPassword.sh
bash-4.4$ cat setPassword.sh
#!/bin/bash
# LICENSE UPL 1.0
#
# Copyright (c) 1982-2023 Oracle and/or its affiliates. All rights reserved.
#
# Since: November, 2016
# Author: gerald.venzl@oracle.com
# Description: Sets the password for sys, system and pdb_admin
#
# DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
#
if [ -e "${ORACLE_BASE}/oradata/${ORACLE_SID}/.prebuiltdb" ] && [ -n "${ORACLE_PWD}" ] && [ "${ORACLE_PWD}" != "$1" ]; then
echo "WARNING: The database password can not be changed for this container having a prebuilt database. The original password exists in the container environment. Your new password has been ignored!"
exit 1
fi
ORACLE_PWD=$1
ORACLE_SID="$(grep "$ORACLE_HOME" /etc/oratab | cut -d: -f1)"
ORACLE_PDB="$(ls -dl "$ORACLE_BASE"/oradata/"$ORACLE_SID"/*/ | grep -v -e pdbseed -e "${ARCHIVELOG_DIR_NAME:-archive_logs}"| awk '{print $9}' | cut -d/ -f6)"
ORAENV_ASK=NO
source oraenv
sqlplus / as sysdba << EOF
ALTER USER SYS IDENTIFIED BY "$ORACLE_PWD";
ALTER USER SYSTEM IDENTIFIED BY "$ORACLE_PWD";
ALTER SESSION SET CONTAINER=$ORACLE_PDB;
ALTER USER PDBADMIN IDENTIFIED BY "$ORACLE_PWD";
exit;
EOF
***************************************************************************************************************************
bash-4.4$ ./setPassword.sh Oracle_23c
The Oracle base remains unchanged with value /opt/oracle
SQL*Plus: Release 23.0.0.0.0 - Production on Sat Nov 11 15:48:29 2023
Version 23.3.0.23.09
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Connected to:
Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.3.0.23.09
SQL>
User altered.
SQL>
User altered.
SQL>
Session altered.
SQL>
User altered.
SQL> Disconnected from Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.3.0.23.09
bash-4.4$ sqlplus PDBADMIN/Oracle_23c@//localhost:1521/FREEPDB1
SQL>
***************************************************************************************************************************
-- Version
SELECT * FROM V$VERSION;
-- USER
SELECT user FROM DUAL;
-- INSTANCE_NAME
SELECT sys_context('USERENV','INSTANCE_NAME') FROM DUAL;
-- SID
SELECT sys_context('USERENV', 'SID') FROM DUAL;
-- DB_NAME
SELECT sys_context('USERENV','DB_NAME') FROM DUAL;
-- SERVICE_NAME
SELECT sys_context('USERENV','SERVICE_NAME') FROM DUAL;
-- ORA_DATABASE_NAME
SELECT ora_database_name FROM DUAL;
-- GLOBAL_NAME
SELECT * from global_name;
-- Tables in USER
SELECT table_name FROM user_tables;
EXIT
***************************************************************************************************************************
export APP_USER="Oracle_23c_Free_User"
export APP_USER_PASSWORD="Oracle_23c_Free"
export TARGET_PDB="FREEPDB1"
echo $APP_USER
echo $APP_USER_PASSWORD
echo $TARGET_PDB
ALTER_SESSION_CMD="ALTER SESSION SET CONTAINER=${TARGET_PDB};"
sqlplus -s / as sysdba << EOF
-- Exit on any errors
WHENEVER SQLERROR EXIT SQL.SQLCODE
${ALTER_SESSION_CMD}
CREATE USER ${APP_USER} IDENTIFIED BY "${APP_USER_PASSWORD}" QUOTA UNLIMITED ON USERS;
GRANT CONNECT, RESOURCE, CREATE VIEW, CREATE MATERIALIZED VIEW, CREATE SYNONYM TO ${APP_USER};
exit;
EOF
***************************************************************************************************************************
bash-4.4$ sqlplus Oracle_23c_Free_User/Oracle_23c_Free@//localhost:1521/FREEPDB1
SQL>
***************************************************************************************************************************
-- Version
SELECT * FROM V$VERSION;
-- USER
SELECT user FROM DUAL;
-- INSTANCE_NAME
SELECT sys_context('USERENV','INSTANCE_NAME') FROM DUAL;
-- SID
SELECT sys_context('USERENV', 'SID') FROM DUAL;
-- DB_NAME
SELECT sys_context('USERENV','DB_NAME') FROM DUAL;
-- SERVICE_NAME
SELECT sys_context('USERENV','SERVICE_NAME') FROM DUAL;
-- ORA_DATABASE_NAME
SELECT ora_database_name FROM DUAL;
-- GLOBAL_NAME
SELECT * from global_name;
-- Tables in USER
SELECT table_name FROM user_tables;
-- DROP SEQUENCE seq_id;
CREATE SEQUENCE seq_id
MINVALUE 1
START WITH 1
INCREMENT BY 1
CACHE 10;
-- DROP TABLE users;
CREATE TABLE users
(
id INT NOT NULL,
username VARCHAR(50) NOT NULL,
login_date DATE NOT NULL,
login_time VARCHAR(10) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT pk_id PRIMARY KEY(id),
CONSTRAINT idx_username UNIQUE(username)
);
COMMIT;
INSERT INTO users(id, username, login_date, login_time, created_at, updated_at)
VALUES
(
seq_id.nextval,
'Foo',
TO_DATE('2016-11-06', 'YYYY-MM-DD'),
'10:49:35',
TO_TIMESTAMP('2016-11-06 10:49:35.0', 'YYYY-MM-DD HH:MI:SS.FF'),
TO_TIMESTAMP('2016-11-06 10:49:35.0', 'YYYY-MM-DD HH:MI:SS.FF')
);
COMMIT;
INSERT INTO users(id, username, login_date, login_time, created_at, updated_at)
VALUES
(
seq_id.nextval,
'Bar',
TO_DATE('2016-11-06', 'YYYY-MM-DD'),
'10:49:35',
TO_TIMESTAMP('2016-11-06 10:49:35.0', 'YYYY-MM-DD HH:MI:SS.FF'),
TO_TIMESTAMP('2016-11-06 10:49:35.0', 'YYYY-MM-DD HH:MI:SS.FF')
);
COMMIT;
SELECT * FROM users;
-- Tables in USER
SELECT table_name FROM user_tables;
EXIT
***************************************************************************************************************************
-- SQL Developer --
Name:
Oracle_23c_Free_Docker
Database Type:
Oracle
User Info
Authentication Type:
Default
Username:
Oracle_23c_Free_User
Password:
Oracle_23c_Free
Role: Default
Connection Type:
Basic
Hostname:
localhost
Port:
1521
Service name:
FREEPDB1
***************************************************************************************************************************
% sqlplus Oracle_23c_Free_User/Oracle_23c_Free@//localhost:1521/FREEPDB1
SQL>
-- Version
SELECT * FROM V$VERSION;
-- USER
SELECT user FROM DUAL;
-- INSTANCE_NAME
SELECT sys_context('USERENV','INSTANCE_NAME') FROM DUAL;
-- SID
SELECT sys_context('USERENV', 'SID') FROM DUAL;
-- DB_NAME
SELECT sys_context('USERENV','DB_NAME') FROM DUAL;
-- SERVICE_NAME
SELECT sys_context('USERENV','SERVICE_NAME') FROM DUAL;
-- ORA_DATABASE_NAME
SELECT ora_database_name FROM DUAL;
-- GLOBAL_NAME
SELECT * from global_name;
-- Tables in USER
SELECT table_name FROM user_tables;
SELECT * FROM users;
EXIT
***************************************************************************************************************************
bash-4.4$ exit
***************************************************************************************************************************
$ exit
logout
[
# Lima Shell # logout # exit
% lima
$ exit
logout
]
% limactl shell default uname -a
% lima uname -a
[
Linux lima-default 6.5.0-9-generic #9-Ubuntu SMP PREEMPT_DYNAMIC Sat Oct 7 01:35:40 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux
]
# List instance(s)
% limactl list
[
NAME STATUS SSH VMTYPE ARCH CPUS MEMORY DISK DIR
default Running 127.0.0.1:60022 qemu x86_64 4 4GiB 100GiB ~/.lima/default
]
# Stop instance
[
% limactl stop default
]
% limactl stop
# List instance(s)
% limactl list
[
NAME STATUS SSH VMTYPE ARCH CPUS MEMORY DISK DIR
default Stopped 127.0.0.1:0 qemu x86_64 4 4GiB 100GiB ~/.lima/default
]
# Delete instance # default
% limactl delete default
[
% brew uninstall lima
% ls ~/.lima
% rm -rf ~/.lima
]
***************************************************************************************************************************
###########################################################################################################################
###########################################################################################################################
# SQL*Plus
###########################################################################################################################
% brew tap InstantClientTap/instantclient
% brew install instantclient-basic
% brew install instantclient-sqlplus
% nano ~/.zprofile
export LD_LIBRARY_PATH=/usr/local/Cellar/instantclient-sqlplus/19.3.0.0.0dbru/lib:/usr/local/Cellar/instantclient-basic/19.3.0.0.0dbru/lib:$LD_LIBRARY_PATH
export PATH=/usr/local/Cellar/instantclient-sqlplus/19.3.0.0.0dbru/bin:$PATH
% cat ~/.zprofile
% source ~/.zprofile
% sqlplus -version
% where sqlplus
% which sqlplus
% type sqlplus
# REPL
% sqlplus PDBADMIN/Oracle_23c@//localhost:1521/FREEPDB1
> SELECT * FROM V$VERSION;
> EXIT
[
# sqlplus
% ls /opt/homebrew/bin
]
###########################################################################################################################
# Windows
###########################################################################################################################
***************************************************************************************************************************
# Git Bash
***************************************************************************************************************************
$ echo $PATH
$ set
[
# dotnet 6+ # dotnet 6 # Exists # C:/Program Files/dotnet/ # Suffix :$PATH $ dotnet --version
$ export PATH="/C/Users/Rajani/Downloads/CS.NET/Binaries/dotnet-sdk-6+/":$PATH
]
# csc # .NET Framework $ csc -version $ csc -langversion:? $ csi -version
$ export PATH=$PATH:"/C/Program Files/Microsoft Visual Studio/2022/Community/MSBuild/Current/Bin/Roslyn/"
# nuget $ nuget ? $ nuget install Microsoft.Net.Compilers.Toolset -Version 4.0.1
$ export PATH=$PATH:"/C/Users/Rajani/Downloads/CS.NET/NuGet/"
# csc # .NET Framework $ csc -version $ csc -langversion:? $ csi -version
$ export PATH=$PATH:"/C/Users/Rajani/Downloads/CS.NET/NuGet/Microsoft.Net.Compilers.Toolset.4.0.1/tasks/net472"
# devenv $ devenv -?
$ export PATH=$PATH:"/C/Program Files/Microsoft Visual Studio/2022/Community/Common7/IDE/"
# ildasm # sn # xsd # SvcUtil # wsdl $ ildasm -? $ sn -version $ xsd -version $ svcutil -version $ wsdl /?
$ export PATH=$PATH:"/C/Program Files (x86)/Microsoft SDKs/Windows/v10.0A/bin/NETFX 4.8 Tools/"
# NUnit # $ nunit3-console --version $ nunit3-console $ nunit.engine.tests --version $ nunit.engine.tests $ testhost --version
$ export PATH=$PATH:"/C/Users/rajanis/Downloads/.NET/NUnit/NUnit.Console-3.12.0/bin/netcoreapp3.1/"
# NUnit Lite $ nunitlite.tests --version $ nunitlite.tests $ nunitlite-runner --version $ nunitlite-runner
$ export PATH=$PATH:"/C/Users/rajanis/Downloads/.NET/NUnit/NUnit.Framework-3.13.2/bin/net35/"
# SQL Server # sqlpackage $ winpty sqlpackage -help
$ export PATH=$PATH:"/C/Users/Rajani/Downloads/SQL Server 2019/sqlpackage/sqlpackage-win7-x64-en-US-15.0.5084.2/"
# SQL Server # SqlPackage # Visual Studio $ SqlPackage -help
$ export PATH=$PATH:"/C/Program Files/Microsoft Visual Studio/2022/Community/Common7/IDE/Extensions/Microsoft/SQLDB/DAC/"
# Java $ java --version
$ export PATH=$PATH:"/C/Users/Rajani/Downloads/Java/JDK/OpenJDK/openjdk-17.0.1_windows-x64_bin/jdk-17.0.1/bin/"
# Apache Tomcat $ ./startup.sh $ start http://localhost:8080/ $ ./shutdown.sh
$ cd "C:\Users\Rajani\Downloads\Java\Apache Tomcat\apache-tomcat-10.0.13-windows-x64\apache-tomcat-10.0.13\bin"
# Java # Apache Maven $ java --version $ mvn --version
$ export PATH=$PATH:"/C/Users/Rajani/Downloads/Java/JDK/OpenJDK/openjdk-17.0.1_windows-x64_bin/jdk-17.0.1/bin/:/C/Users/Rajani/Downloads/Java/Apache Maven/apache-maven-3.8.4-bin/apache-maven-3.8.4/bin/"
# Scala # Java # Coursier Native Launcher $ java --version $ cs --version
$ export PATH=$PATH:"/C/Users/Rajani/Downloads/Java/JDK/OpenJDK/openjdk-17.0.1_windows-x64_bin/jdk-17.0.1/bin/:/C/Users/Rajani/Downloads/Scala/Scala3/Bitsadmin/Native/"
# Scala # Java # Apache Maven # Coursier Native Launcher $ java --version $ mvn --version $ cs --version
$ export PATH=$PATH:"/C/Users/Rajani/Downloads/Java/JDK/OpenJDK/openjdk-17.0.1_windows-x64_bin/jdk-17.0.1/bin/:/C/Users/Rajani/Downloads/Java/Apache Maven/apache-maven-3.8.4-bin/apache-maven-3.8.4/bin/:/C/Users/Rajani/Downloads/Scala/Scala3/Bitsadmin/Native/"
# Scala # Java # Coursier JAR-based Launcher $ java --version $ coursier --version
$ export PATH=$PATH:"/C/Users/Rajani/Downloads/Java/JDK/OpenJDK/openjdk-17.0.1_windows-x64_bin/jdk-17.0.1/bin/:/C/Users/Rajani/Downloads/Scala/Scala3/Bitsadmin/JAR/"
# Scala # Java # Apache Maven # Coursier JAR-based Launcher $ java --version $ mvn --version $ coursier --version
$ export PATH=$PATH:"/C/Users/Rajani/Downloads/Java/JDK/OpenJDK/openjdk-17.0.1_windows-x64_bin/jdk-17.0.1/bin/:/C/Users/Rajani/Downloads/Java/Apache Maven/apache-maven-3.8.4-bin/apache-maven-3.8.4/bin/:/C/Users/Rajani/Downloads/Scala/Scala3/Bitsadmin/JAR/"
# Scala # Java # sbt $ java --version $ sbt --version
$ export PATH=$PATH:"/C/Users/Rajani/Downloads/Java/JDK/OpenJDK/openjdk-17.0.1_windows-x64_bin/jdk-17.0.1/bin/:/C/Users/Rajani/Downloads/Scala/Scala3/sbt/sbt-1.5.6/sbt/bin/"
# Scala # Java # Apache Maven # sbt $ java --version $ mvn --version $ sbt --version
$ export PATH=$PATH:"/C/Users/Rajani/Downloads/Java/JDK/OpenJDK/openjdk-17.0.1_windows-x64_bin/jdk-17.0.1/bin/:/C/Users/Rajani/Downloads/Java/Apache Maven/apache-maven-3.8.4-bin/apache-maven-3.8.4/bin/:/C/Users/Rajani/Downloads/Scala/Scala3/sbt/sbt-1.5.6/sbt/bin/"
# Python $ winpty python --version $ pip --version $ python -m pip install --upgrade pip $ pip show pip $ pip show setuptools $ pip list $ pip install django $ python -m django --version $ django-admin --version $ python -c "import django; print(django.__version__)"
$ export PATH=$PATH:"/C/Python310/:/C/Python310/Scripts/"
# PostgreSQL ($ pip --version) $ pip show pgAdmin4 $ winpty pgAdmin4
$ pip install pgAdmin4
# PostgreSQL $ pgAdmin4
$ export PATH=$PATH:"/C/Users/rajanis/Downloads/PostgreSQL/postgresql-13.1-1-windows-x64-binaries/pgsql/pgAdmin 4/bin/"
# PostgreSQL $ winpty initdb --version $ pg_ctl --version $ winpty psql --version $ winpty psql -U postgres
$ export PATH=$PATH:"/C/Users/rajanis/Downloads/PostgreSQL/postgresql-13.1-1-windows-x64-binaries/pgsql/bin/"
# Node.js $ node -v $ npm -v $ npx -v $ npm -g list $ npm view npm version $ npm view npm $ npm show npm version $ npm show npm $ npm view corepack $ npm view corepack version $ npm show corepack $ npm show corepack version
$ export PATH=$PATH:"/C/Users/Rajani/Downloads/Node.js/node-v16.13.1-win-x64/"
# Ruby $ ruby --version $ gem --version $ rake --version $ gem install bundler $ bundler --version $ bundle --version $ gem install rails $ rails --version $ npm install --global yarn $ yarn --version $ yarn install --check-files
$ export PATH=$PATH:"/C/Users/Rajani/Downloads/Node.js/node-v16.13.1-win-x64/:/C/Ruby30-x64/bin/"
# SQLite $ winpty sqlite3 -version
$ export PATH=$PATH:"/C/Users/rajanis/Downloads/SQLite/sqlite-tools-win32-x86-3330000/"
# MongoDB $ mongo -version
$ export PATH=$PATH:"/C/Users/rajanis/Downloads/MongoDB/mongodb-win32-x86_64-2012plus-4.2.8/bin/"
# MySQL $ winpty mysqlsh --version $ winpty mysqlsh --sql # \connect --mysql root@localhost
$ export PATH=$PATH:"/C/Users/rajanis/Downloads/MySQL/MySQL Shell/mysql-shell-8.0.25-windows-x86-64bit/bin/"
# XAMPP $ xampp-control $ xampp_start $ xampp_stop
# MySQL # MariaDB $ winpty mysqladmin --version $ mysql_start.bat $ winpty mysqladmin -u root password $ winpty mysql --version $ winpty mysql -u root -p $ mysql_stop.bat
$ export PATH=$PATH:"/C/Users/rajanis/Downloads/XAMPP/xampp/:/C/Users/rajanis/Downloads/XAMPP/xampp/mysql/bin/"
# PHP $ php -version
$ export PATH=$PATH:"/C/Users/rajanis/Downloads/XAMPP/xampp/php/"
# Composer $ php -version $ composer --version
$ export PATH=$PATH:"/C/Users/rajanis/Downloads/XAMPP/xampp/php/:/C/Users/rajanis/Downloads/XAMPP/xampp/php/Composer/"
# Perl # Git # Exists # C:/Users/rajanis/AppData/Local/Programs/Git/usr/bin/ # Suffix :$PATH $ perl --version
$ export PATH="/C/Users/rajanis/Downloads/Perl/strawberry-perl-5.32.0.1-64bit-portable/perl/bin/":$PATH
# gcc $ gcc --version
$ export PATH=$PATH:"/C/Users/rajanis/Downloads/Perl/strawberry-perl-5.32.0.1-64bit-portable/c/bin/"
# OR
$ export PATH=$PATH:"/C/Ruby30-x64/msys64/mingw64/bin/"
# wget $ wget -V
$ export PATH=$PATH:"/C/Users/rajanis/Downloads/wget/"
# PowerShell $ pwsh --version $ pwsh
$ export PATH=$PATH:"/C/Users/Rajani/Downloads/PowerShell/Binary/PowerShell-7.2.1-win-x64/"
***************************************************************************************************************************
***************************************************************************************************************************
# cmd
***************************************************************************************************************************
> path
> echo %path%
> set
[
# dotnet 6+ # dotnet 6 # Exists # C:/Program Files/dotnet/ # Suffix ;%path% > dotnet --version
> set path=C:\Users\Rajani\Downloads\CS.NET\Binaries\dotnet-sdk-6+\;%path%
]
# csc # .NET Framework > csc -version > csc -langversion:? > csi -version
> set path=%path%;C:\Program Files\Microsoft Visual Studio\2022\Community\MSBuild\Current\Bin\Roslyn\
# nuget > nuget ? > nuget install Microsoft.Net.Compilers.Toolset -Version 4.0.1
> set path=%path%;C:\Users\Rajani\Downloads\CS.NET\NuGet\
# csc # .NET Framework > csc -version > csc -langversion:? > csi -version
> set path=%path%;C:\Users\Rajani\Downloads\CS.NET\NuGet\Microsoft.Net.Compilers.Toolset.4.0.1\tasks\net472\
# devenv > devenv /?
> set path=%path%;C:\Program Files\Microsoft Visual Studio\2022\Community\Common7\IDE\
# ildasm # sn # xsd # SvcUtil # wsdl > ildasm -? > sn -version > xsd -version > svcutil -version > wsdl /?
> set path=%path%;C:\Program Files (x86)\Microsoft SDKs\Windows\v10.0A\bin\NETFX 4.8 Tools\
# NUnit # $ nunit3-console --version $ nunit3-console $ nunit.engine.tests --version $ nunit.engine.tests $ testhost --version
> set path=%path%;C:\Users\rajanis\Downloads\.NET\NUnit\NUnit.Console-3.12.0\bin\netcoreapp3.1\
# NUnit Lite $ nunitlite.tests --version $ nunitlite.tests $ nunitlite-runner --version $ nunitlite-runner
> set path=%path%;C:\Users\rajanis\Downloads\.NET\NUnit\NUnit.Framework-3.13.2\bin\net35\
# SQL Server # sqlpackage > sqlpackage -help
> set path=%path%;C:\Users\Rajani\Downloads\SQL Server 2019\sqlpackage\sqlpackage-win7-x64-en-US-15.0.5084.2\
# SQL Server # SqlPackage # Visual Studio > SqlPackage -help
> set path=%path%;C:\Program Files\Microsoft Visual Studio\2022\Community\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\
# Java > java --version
> set path=%path%;C:\Users\Rajani\Downloads\Java\JDK\OpenJDK\openjdk-17.0.1_windows-x64_bin\jdk-17.0.1\bin\
# Apache Tomcat # startup.bat and shutdown.bat require JAVA_HOME and M2_HOME hence startup.sh and shutdown.sh > startup.sh > start http://localhost:8080/ > shutdown.sh
> cd "C:\Users\Rajani\Downloads\Java\Apache Tomcat\apache-tomcat-10.0.13-windows-x64\apache-tomcat-10.0.13\bin"
# Java # Apache Maven > java --version > cs --version
> set path=%path%;C:\Users\Rajani\Downloads\Java\JDK\OpenJDK\openjdk-17.0.1_windows-x64_bin\jdk-17.0.1\bin\;C:\Users\Rajani\Downloads\Java\Apache Maven\apache-maven-3.8.4-bin\apache-maven-3.8.4\bin\
# Scala # Java # Coursier Native Launcher > java --version > cs --version
> set path=%path%;C:\Users\Rajani\Downloads\Java\JDK\OpenJDK\openjdk-17.0.1_windows-x64_bin\jdk-17.0.1\bin\;C:\Users\Rajani\Downloads\Scala\Scala3\Bitsadmin\Native\
# Scala # Java # Apache Maven # Coursier Native Launcher > java --version > mvn --version > cs --version
> set path=%path%;C:\Users\Rajani\Downloads\Java\JDK\OpenJDK\openjdk-17.0.1_windows-x64_bin\jdk-17.0.1\bin\;C:\Users\Rajani\Downloads\Java\Apache Maven\apache-maven-3.8.4-bin\apache-maven-3.8.4\bin\;C:\Users\Rajani\Downloads\Scala\Scala3\Bitsadmin\Native\
# Scala # Java # Coursier JAR-based Launcher > java --version > coursier --version
> set path=%path%;C:\Users\Rajani\Downloads\Java\JDK\OpenJDK\openjdk-17.0.1_windows-x64_bin\jdk-17.0.1\bin\;C:\Users\Rajani\Downloads\Scala\Scala3\Bitsadmin\JAR\
# Scala # Java # Apache Maven # Coursier JAR-based Launcher > java --version > mvn --version > coursier --version
> set path=%path%;C:\Users\Rajani\Downloads\Java\JDK\OpenJDK\openjdk-17.0.1_windows-x64_bin\jdk-17.0.1\bin\;C:\Users\Rajani\Downloads\Java\Apache Maven\apache-maven-3.8.4-bin\apache-maven-3.8.4\bin\;C:\Users\Rajani\Downloads\Scala\Scala3\Bitsadmin\JAR\
# Scala # Java # sbt > java --version > sbt --version
> set path=%path%;C:\Users\Rajani\Downloads\Java\JDK\OpenJDK\openjdk-17.0.1_windows-x64_bin\jdk-17.0.1\bin\;C:\Users\Rajani\Downloads\Scala\Scala3\sbt\sbt-1.5.6\sbt\bin\
# Scala # Java # Apache Maven # sbt > java --version > mvn --version > sbt --version
> set path=%path%;C:\Users\Rajani\Downloads\Java\JDK\OpenJDK\openjdk-17.0.1_windows-x64_bin\jdk-17.0.1\bin\;C:\Users\Rajani\Downloads\Java\Apache Maven\apache-maven-3.8.4-bin\apache-maven-3.8.4\bin\;C:\Users\Rajani\Downloads\Scala\Scala3\sbt\sbt-1.5.6\sbt\bin\
# Python > winpty python --version > pip --version > python -m pip install --upgrade pip > pip show pip > pip show setuptools > pip list > pip install django > python -m django --version > django-admin --version > python -c "import django; print(django.__version__)"
> set path=%path%;C:\Python310\;C:\Python310\Scripts\
# PostgreSQL (> pip --version) > pip show pgAdmin4 > pgAdmin4
> pip install pgAdmin4
# PostgreSQL > pgAdmin4
> set path=%path%;C:\Users\rajanis\Downloads\PostgreSQL\postgresql-13.1-1-windows-x64-binaries\pgsql\pgAdmin 4\bin\
# PostgreSQL > initdb --version > pg_ctl --version > psql --version > psql -U postgres
> set path=%path%;C:\Users\rajanis\Downloads\PostgreSQL\postgresql-13.1-1-windows-x64-binaries\pgsql\bin\
# Node.js > node -v > npm -v > npx -v > npm -g list > npm view npm version > npm view npm > npm show npm version > npm show npm > npm view corepack > npm view corepack version > npm show corepack > npm show corepack version
> set path=%path%;C:\Users\Rajani\Downloads\Node.js\node-v16.13.1-win-x64\
# Ruby > ruby --version > gem --version > rake --version > gem install bundler > bundler --version > bundle --version > gem install rails > rails --version > npm install --global yarn > yarn --version > yarn install --check-files
> set path=%path%;C:\Users\Rajani\Downloads\Node.js\node-v16.13.1-win-x64\;C:\Ruby30-x64\bin\
# SQLite > sqlite3 -version
> set path=%path%;C:\Users\rajanis\Downloads\SQLite\sqlite-tools-win32-x86-3330000\
# MongoDB > mongo -version
> set path=%path%;C:\Users\rajanis\Downloads\MongoDB\mongodb-win32-x86_64-2012plus-4.2.8\bin\
# MySQL > mysqlsh --version > mysqlsh --sql # \connect --mysql root@localhost
> set path=%path%;C:\Users\rajanis\Downloads\MySQL\MySQL Shell\mysql-shell-8.0.25-windows-x86-64bit\bin\
# XAMPP > xampp-control > xampp_start > xampp_stop
# MySQL # MariaDB > mysqladmin --version > mysql_start.bat > mysqladmin -u root password > mysql --version > mysql -u root -p > mysql_stop.bat
> set path=%path%;C:\Users\rajanis\Downloads\XAMPP\xampp\;C:\Users\rajanis\Downloads\XAMPP\xampp\mysql\bin\
# PHP > php -version
> set path=%path%;C:\Users\rajanis\Downloads\XAMPP\xampp\php\
# Composer > php -version > composer --version
> set path=%path%;C:\Users\rajanis\Downloads\XAMPP\xampp\php\;C:\Users\rajanis\Downloads\XAMPP\xampp\php\Composer\
# Perl # Git > perl --version
> set path=%path%;C:\Program Files\Git\usr\bin
# Perl > perl --version
> set path=%path%;C:\Users\rajanis\Downloads\Perl\strawberry-perl-5.32.0.1-64bit-portable\perl\bin\
# gcc > gcc --version
> set path=%path%;C:\Users\rajanis\Downloads\Perl\strawberry-perl-5.32.0.1-64bit-portable\c\bin\
# OR
> set path=%path%;C:\Ruby30-x64\msys64\mingw64\bin\
# wget > wget -V
> set path=%path%;C:\Users\rajanis\Downloads\wget\
# PowerShell > pwsh --version > pwsh
> set path=%path%;C:\Users\Rajani\Downloads\PowerShell\Binary\PowerShell-7.2.1-win-x64\
***************************************************************************************************************************
###########################################################################################################################
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment