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

editor

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

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