cheat sheet

useful search function for using whole cheat sheet

function cheat-grep(){
    if [[ $1 == "" ]]; then
        echo "nothing to search"
        return;
    fi

    search_line=""
    for each_input_arg in "$@"; do
        if [[ $search_line == "" ]]; then
            search_line=$each_input_arg
        else
            search_line=$search_line".*"$each_input_arg
        fi
    done

    grep -r $search_line -i -A 2 $HOME_PROJECTS/cheat-sheet/*.md $HOME_PROJECTS/bash-example/*
}

other cheat-tools

• cht.sh
• tldr
• how2

other cheat sheets:

• root/entrypoint to different resources
• cheat sheets collection
• cheat sheets

documentation examples, how to write good documentation, documentation tools

useful tools:

free online resources for developers

list of online tools

free hosted applications, locally started applications

collaboration whiteboard drawing

• miro: white board for collaboration
• draw chat: white board with chat
• excalidraw
  • using razer-keypad with excalidraw
• local drawing tool

editor

• https://vscode.dev
• https://code.visualstudio.com/
• https://lite-xl.com/

render/run html/js/javascript files from github

githack.com

• Development https://raw.githack.com/[user]/[repository]/[branch]/[filename.ext]
• Production (CDN) https://rawcdn.githack.com/[user]/[repository]/[branch]/[filename.ext] example: https://raw.githack.com/cherkavi/javascripting/master/d3/d3-bar-chart.html

github.io

http://htmlpreview.github.io/?[full path to html page] example http://htmlpreview.github.io/?https://github.com/cherkavi/javascripting/blob/master/d3/d3-bar-chart.html
http://htmlpreview.github.io/?https://github.com/twbs/bootstrap/blob/gh-pages/2.3.2/index.html

rawgit

https://rawgit.com/[user]/[repository]/master/index.html https://rawgit.com/cherkavi/javascripting/master/d3/d3-bar-chart.html

diagram drawing

• ascii graphics for drawing Architecture Diagrams in text
• uml, sysml, archimate tool

markdown

• diagrams within markdown
  • mermaid live
  • fond awesome fa:fa-user
  • zenuml
• markdown editor realtime collaboration
• list of markdown code supported languages

regular expressions

• regular expressions regexp

stream editor

• sed escape, sed online escape

online coding

• online editor with prepared UI frameworks
• code compiler/editor online
• code compiler/editor online
• typescript sandbox
• repl online
• code sandbox

code analyser

• code lines counter
• code secrets finder code passwords checker

code changer

• auto code refactoring

database GUI client

• Azure Data Studio
• DbGate
• Sqlectron
• Antares SQL
• Beekeeper Studio

database cli clients, sql cli tools, db connect from command line

https://java-source.net/open-source/sql-clients

• https://hsqldb.org doc download

• sqlshell download

• henplus

• sqlline sqlline doc installation from source

  git clone https://github.com/julianhyde/sqlline.git
  cd sqlline
  git tag
  git checkout sqlline-1.12.0
  mvn package  

  download from maven

  ver=1.12.0
  wget https://repo1.maven.org/maven2/sqlline/sqlline/$ver/sqlline-$ver-jar-with-dependencies.jar

  usage

  java -cp "*" sqlline.SqlLine \
  -n myusername 
  -p supersecretpassword \
  -u "jdbc:oracle:thin:@my.host.name:1521:my-sid"

  usage with db2

  JDBC_SERVER_NAME=cat.zur
  JDBC_DATABASE=TOM_CAT
  JDBC_PORT=8355
  JDBC_USER=jerry
  JDBC_PASSWORD_PLAIN=mousejerry
  JDBC_DRIVER='com.ibm.db2.jcc.DB2Driver'
  java -cp "*" sqlline.SqlLine -n ${JDBC_USER} -p ${JDBC_PASSWORD_PLAIN} -u "jdbc:db2://${JDBC_SERVER_NAME}:${JDBC_PORT}/${JDBC_DATABASE}" -d $JDBC_DRIVER

password storage

• one time password storage

text/password exchange

• online clipboard

list of opensource api tools

REST api test frameworks

• karate
  • tutorial
  • how to start with
• k6
• cypress
• gatling
• junit
  • how to junit
  • junit how to
• locust
  • how to locust
• performance testing with traffic re-play