Skip to content

cherkavi/cheat-sheet

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

Other cheat sheets:

useful tools:

collaboration whiteboard drawing

diagram drawing

markdown

regular expressions

stream editor

online coding

code analyser

code changer

database GUI client

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

text/password exchange

REST api test frameworks