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

• excalidraw
  • using razer-keypad with excalidraw
• local drawing tool
• white board for collaboration
• white board for collaboration
• drawing tool

diagram drawing

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

markdown

• diagrams within markdown
  • mermaid live
  • zenuml
• markdown editor realtime collaboration
• list of markdown code supported languages
• plantuml inside VisualCode

    "plantuml.fileExtensions": ".wsd,.pu,.puml,.plantuml,.iuml,.md",
    # "plantuml.server": "https://plantuml-mci.bmwgroup.net/",
    "plantuml.server": "http://localhost:3344",
    "plantuml.render": "PlantUMLServer",    
  

  docker run -d --name plantuml_local -p 3344:8080 plantuml/plantuml-server:jetty
  

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