x
-
+
Binary Powers
<
o
>
2 0
=
1
2 1
=
2
2 2
=
4
2 3
=
8
2 4
=
16
2 5
=
32
2 6
=
64
2 7
=
128
2 8
=
256
2 9
=
512
2 10
=
1024
2 11
=
2048
2 12
=
4096
2 13
=
8192
2 14
=
16384
2 15
=
32768
quartz resonation per second
2 16
=
65536
2 17
=
131072
2 18
=
262144
2 19
=
524288
2 20
=
1048576
x
-
+
Linux "find" Command
<
o
>
find
<dir>
[-not] -name
<regex>
 . . .
 . . .
-type
<d,f,...>
 . . .
 . . .
-mtime
<+/-><integer>
 . . .
 . . .
-maxdepth
<integer>
 . . .
 . . .
-mindepth
<integer>
 . . .
 . . .
 . . .
 . . .
-exec <command> {} \;
x
-
+
Computer Links
<
o
>
x
-
+
VI Quick Navigation
<
o
>
"/"<string> ENTER
search   (forward)
"/\c"<string> ENTER
search   (case insensitive)
"?"<string> ENTER
search   (backward)
"?\c"<string> ENTER
search   (case insensitive)
"n"
next match in search   (same direction)
"N"
next match in search   (opposite direction)
<integer>"G"
move cursor to <integer> line
"G"
move cursor to last line
"^", "0", or "|"
move cursor to first column
<integer>"|"
move cursor to <integer> column
"$"
move cursor to last column
<integer>"$"
move cursor to last column <integer> lines down
CONTROL "f"
move forward one full screen
CONTROL "b"
move backward one full screen
"w"
move to next word
"b"
move to previous word
<integer> ENTER
move <integer> lines down
")"
move a sentence forward
"("
move a sentence back
"}"
move a paragraph forward
"{"
move a paragraph back
"%"
match brackets or parenthesis
"z" ENTER
move cursor line to top of screen
x
-
+
JavaScript
<
o
>
<script src="myScript.js"></script>
debugger;
document.activeElement
console.log(   );
console.trace(   );
clear(   );
localStorage.clear(   );
document.getElementsById( 'name' );
document.getElementsByClassName( 'name' );
document.getElementsByTagName( 'name' );
document.getElementsByName( 'name' );
preventDefault(   );
document.styleSheets[9].rules[9] || document.styleSheets[9].cssRules[9]
document.styleSheets[9].cssRules[9].style.backgroundImage
"text-align: center;" ... "display: inline-block;"
querySelector( body #id );
querySelectorAll( body .class );
JSON.stringify(   ) turns a Javascript object into JSON text and stores that JSON text in a string
JSON.parse(   ) turns a string of JSON text into a Javascript object.
null != element.match(   )
string = element.replace(   )
element.style.zIndex = 9
window (global), var (local fn) and let (local block)
getElementByID(   ) can only be used on "document"
basically there are two event models in JavaScript...event capturing and event bubbling
element.classList.contains( 'class name to search' );
if( document.querySelector( '.mydivclass' ) !== null ){ // .. it exists }

chrome://about
chrome://version
chrome://settings
chrome://settings/cookies
chrome://settings/clearBrowserData
chrome://bookmarks
file:///

opera://about
opera://settings
opera://settings/content/cookies
opera://settings/siteData
opera://bookmarks
opera://history
opera://flags
file:///

/* -webkit-user-select: none; */
/* user-select: none; */
x
-
+
oxygen (linux web server)
<
o
>
Linux
  • use PuTTY to SSH to server
  • put server name in the window title
    • can be set in PuTTY
    • can be dynamic with server's command prompt
      • PS1="# \u@\h:\w \t #"a (review oxygen's prompt)
  • use different colors for different servers
Naming
  • general to specific
  • noun then verb
  • camelCase
  • keep database column names in code until ready to output on report
JSON (JavaScript Object Notation)
  • layer between database and user
  • can generate per report and/or for multiple reports
  • make for process/queue time
  • make a daily build to cover multiple files
PHP Headers
  • "base" for error, debugging, language... settings. Pulling in all other headers
  • "database" for connecting to databases
  • "datetime" for formatting dates and times
  • "page" for headers, footers, etc
BASH Scripts
  • set_env
  • backup.sh
  • email.sh
  • diskChk.sh
  • loadChk.sh
  • swapChk.sh
To Do
  • git source control (configs and app code)
  • masquerade as xyz.abc.com (instead of oxygen.xyz.abc.com)
  • add page loaded timestamp in report footer (already in headers)
x
-
+
WikipediA (1st)
<
o
>
PHP
x
-
+
Musicians
<
o
>
Lit
NF
Sia
TLC
U2
x
-
+
Music Clips
<
o
>

6886a47e.mp3

6bc7fb39.mp3

04cfc7ac.mp3

4239e686.mp3

6f6cfd47.mp3

759ce8db.mp3

52a408d6.mp3

9b1bac49.mp3

74d5a128.mp3

4468ba43.mp3

1bf7bbcb.mp3

37389c43.mp3

4fb0b290.mp3

7d679906.mp3

655c809f.mp3

fbdfbeec.mp3

bbc267f7.mp3

6a977133.mp3

d14ada59.mp3

3ddf93a5.mp3

1780b3b5.mp3

b0f93436.mp3

ce708a9d.mp3

022f3ffc.mp3

1d2ccc5f.mp3

b08baa4e.mp3

1dfee438.mp3

2b9f9d8d.mp3

49b55dd8.mp3

7509b87e.mp3

25a2a370.mp3

2a260ac1.mp3
x
-
+
Apache2 Server
<
o
>
Comments
  • Inline comments
    • # comment(s)
  • Block comments
    • <IfDefine IgnoreBlockComment>
         comment(s)
      </IfDefine>
Apache HTTP server control interface
  • List help
    • apachectl -h
  • List server root directory (configs)
    • apachectl -t -D DUMP_RUN_CFG 2>/dev/null | grep 'ServerRoot' | awk -F'"' '{print $2}'
  • List server error file
    • apachectl -t -D DUMP_RUN_CFG 2>/dev/null | grep 'Main Error' | awk -F'"' '{print $2}'
  • show all loaded modules
    • apachectl -t -D DUMP_MODULES
  • Show parsed vhost settings
    • apachectl -t -D DUMP_VHOSTS
  • Restart server
    • apachectl -k restart
a2ensite, a2dissite - enable or disable an apache2 site / virtual host
  • Config file(s) are in <ServerRoot>/sites-available
  • a2ensite configFile
  • a2dissite configFile
Reload configs
  • systemctl reload apache2
  • OR
  • service apache2 reload
Retrieve runtime configuration from a local Apache 2 HTTP server
  • List help
    • a2query -h
  • List available sites
    • a2query -s
Manage user files for basic authentication
  • List help
    • htpasswd
  • Create a new file
    • htpasswd -c .htpasswd user
  • Add user to file
    • htpasswd .htpasswd user
  • Display line to added to file
    • htpasswd -n user
htaccess file basic setup
  • AuthType Basic
    AuthName "Restricted Area"
    AuthUserFile .htpasswd
    Require valid-user
Log rotate config
  • /etc/logrotate.d/apache2
My custom script called from "/etc/logrotate.d/apache2"
  • /usr/sbin/apacheAccessLog.sh
x
-
+
Hangman (elements)
<
o
>


Wrong Letters:


x
-
+
Linux Command Line
<
o
>
PS1='\[\e]0;$(printf "${USER}@${HOSTNAME}:${PWD}")\a\]\[\e[1;33m\]#] \u@\h:\w \t [\[\e[0m\] '   # a very useful prompt
apropos   # search the manual page names and descriptions
bc -lq   # calculator...type "quit" and press enter to exit
bg   # put a job in the background
blkid   # locate/print block device attributes (UUID, LABEL, etc)
cat /etc/os-release   # show OS version, etc
cat /proc/cpuinfo   # list cpu
cat /proc/meminfo   # list memory
clear   # clears the terminal screen
column   # columnate lists
dpkg -l [package]   # package manager for Debian...list package(s)
du   # estimate file space usage...great switches "-h" and "-d"
env   # print a list of environment variables
exif <image file>   # show meta data
fdisk -l   # list partition tables
ffmpeg -i <music file>   # list info...title, duration, bitrate, etc.
ffmpeg -i <input.flac> -ab 320k -map_metadata 0 -id3v2_version 3 <output.mp3>   # encode to mp3
ffmpeg -i <input.m4a> -acodec libmp3lame -ab 256k <output.mp3>   # encode to mp3
ffmpeg -i <input.mp3> -ss <00:02:54.583> -t <20.0> [-c copy <output.mp3>]   # start at a very precise time
ffmpeg -i <input.mp3> -ss <2.0> -t <20.0> [-c copy <output.mp3>]   # cut a section of audio 2nd sec for 20 sec to the 22nd sec
ffmpeg -i <input.mp3> -ss <2.0> -to <15.0> [-c copy <output.mp3>]   # cut a section of audio 2nd sec to the 15th sec
ffmpeg -i <input.ogg> -acodec libmp3lame <output.mp3>   # encode to mp3
ffplay [-nodisp] [-autoexit] <mp3 file>   # play a mp3 file
ffprobe <mp3 file>   # list meta data and more
fg   # put a job in the foreground
file -s <device>   # list special files detail
file <file>   # determine the file type
find . -name "*" -exec grep -inHI foo {} \; 2>/dev/null   # i = case insensitive, n = line number, H = print path, I = ignore binary
find . -type f -print0 | tar -czvf backup.tar.gz --null -T -   # tar files with spaces, etc
fstrim -v <device>   # display amount of free and used memory
free [-b,-k,-m,-g]   # display amount of free and used memory in the system...b = bytes, k = kibibytes, m = mebibytes, g = gibibytes
gdisk -l   # list the partition table for the specified device
grep [-i,I,n,v] <file>   # print lines matching a pattern...i = ignore case, I = ignore binary files, n = line number, v = ignore match
hdparm -I <device>   # request identification info directly from the drive, which is displayed in a new expanded format
hostnamectl   # control the system hostname
identify <image file>   # show image stats
iw dev   # show/manipulate wireless devices and their configuration
history [integer]   # list previously run commands
jobs   # list background jobs
ldd --version   # glibc version
locate <pattern>   # quickly list all matching files
locate --regex <pattern>   # quickly list all matching files using regular expressions
ls -latrh   # file listing...long, all, time, reverse, human readable size
ls --quoting-style=shell-escape-always   # displays the output single quoted
ls -lt /var/log/installer   # find Linux install date
ls [-i,--inode] <file>   # display inode and filename
lsb-release -a   # print distribution-specific information
lsblk [-f] [device]   # list block devices
lscpu   # display CPU information
lspci   # list all PCI devices
lsusb | sort -k4,4 -k2,2   # list USB devices
mkfs.ext4 [-O ^has_journal] <device>   # make ext4 filesystem...with or without journaling
mp3info <mp3 file>   # list meta data
mp3info -p "%m:%02s\n" <mp3 file>   # audio length
od -c   # show all characters...even unprintable
parted -l   # lists partition layout on all block devices
pulseaudio -k && sudo alsa force-reload   # restart audio
sed -n '/regex1/,/regex2/p'    # print lines from regex1 to regex2
set   # display values of shell attributes and parameters
sort   # "-h" and "-r" are great switches
ssh-copy-id <user@server> || cat ~/.ssh/id_rsa.pub | ssh <user@server> "mkdir -p ~/.ssh cat >> ~/.ssh/authorized_keys"
ssh-keygen -t rsa   # generate a RSA key
stat <file>   # display file status...including inode, etc.
sudo apt install sysstat   # install sysstat set of tools
sudo dmidecode -t bios   # Desktop Management Interface
sudo dmidecode -t memory   # Desktop Management Interface
sudo dmidecode -t processor   # Desktop Management Interface
sudo dmidecode -t system   # Desktop Management Interface
sudo dmidecode -t   # Desktop Management Interface
sudo lshw -class cpu   # list cpu
sudo lshw -class disk   # list disk
sudo lshw -class memory   # list memory slots and values
sudo lshw -class network   # list network
sudo lspci   # list all PCI devices
tar --extract --file="file.tar" file to extract (with path) [file to extract (with path)]...   # extract individual file(s)
tar xzvf <file.tgz> -C <extract path>   # extract to a path
tune2fs -l <device>   # list the contents of the filesystem superblock, including the current values of the parameters that can be set
type <name>   # indicate how interpreted, if used as a command name
typeset -f   # list defined shell functions
uname --all   # kernel version, etc
wget --recursive --no-parent https://www.vmwareblog.org/forgot-esxi-root-password-no-problems-4-ways-reset/   # download all files in a tree
which <command>   # locate a command

locate --regexp "\.ttf$" | awk -F'/' '{print $NF}' | sort | uniq -c | sort -n   # "locate" all TTFs...uniq list with count of each font
locate --regexp "\.ttf$" | while read file; do ls -lah --time-style=long-iso "$file"; done | grep ' 202' | sort -k6,6 -n   # "locate" all TTFs...list from the 2020s
while [ 1 ]; do date; free -m; read key; done   # watch memory usage

#!/bin/bash
#set -x

# 2024-07-26; free.sh; Kent M Kohlmeyer (kemiko)

# This script shows memory usage in...
# bytes, kibibytes, mebibytes, and gibibytes

# Add seconds to execute after pause...
# or <enter> is pressed

# don't echo key presses to screen
stty -echo

# don't show cursor
tput civis

trap 'tput cnorm; stty echo; exit 1' 0 1 2 15

# set defaults
size=m
seconds=86400

if [ ${#} -eq 0 ]
then
  printf "^[[1mUsage: %s <b|k|m|g> [seconds]^[[0m\n" "${0}"
  exit 1
fi

if [ ${1} != b ] && [ ${1} != k ] && [ ${1} != m ] && [ ${1} != g ]
then
  printf "^[[1mArgument one, \"${1}\", is not \"b|k|m|g\"^[[0m\n"
  exit 1
else
  size=${1}
fi

# test if argument two is set
if [ -z ${2+x} ]
then
  :
else
  # test if argument two is an integer
  if [ "${2}" -eq "${2}" ] 2>/dev/null
  then
    seconds=${2}
  else
    printf "^[[1mArgument two, \"${2}\", is not an integer^[[0m\n"
    exit 1
  fi
fi

while [ 1 ]
do
  printf "^[[1m%s^[[0m\n" "$(date '+%Y-%m-%d @ %H:%M:%S (%A)')"
  free -${size}
  read -t ${seconds}
done
x
-
+
Colors
<
o
>
Blank out background/wallpaper
"loaded" =

metal = rgb(111, 115, 118)
rust = rgb(176, 101, 40)
chocolate = rgb(115, 82, 51)
crimson = rgb(128, 0, 0)
forest = rgb(18, 71, 18)
sand = rgb(221, 198, 154)
orange (medium) = rgb(230, 140, 63)
orange (bright) = rgb(255, 103, 42)
gray/gold = rgb(153, 153, 102)
gray/green = rgb(128, 149, 120)
olive = rgb(99, 114, 88)
brown = rgb(136, 78, 31)
green = rgb(31, 136, 80)
green = rgb(27, 119, 66)

Hints:
-use with...CoNtRoL PaNeL -> Colors -> Background
-use with...Footer (double click) -> Color > Background
x
-
+
SQL Joins
<
o
>
x
-
+
Informix
<
o
>
Informix History

Informix Exam...Application Test Developer Questions
  1. Database Objects (16%)
  2. Traditional Data Manipulation (30%)
  3. SPL Programming (14%)
  4. Core Concepts (24%)
  5. Extensibility (16%)
itop (Informix Top)...a tool I wrote in C
  • Create open source project
  • Add filter
  • Add sort
x
-
+
Web Utilities
<
o
>
x
-
+
About AOS
<
o
>
x
-
+
Interest Calculator
<
o
>
Principle
Interest
Year(s)
Δ Principle

x
-
+
"Quotes"
<
o
>
"Great Minds Discuss Ideas; Average Minds Discuss Events; Small Minds Discuss People" ― First Lady Eleanor Roosevelt "In America, there are two tax systems: one for the informed and one for the uninformed. Both are legal" ― Learned Hand "Lottery: A tax on people who are bad at math" ― Ambrose Bierce "Insanity: doing the same thing over and over again and expecting different results" ― Unknown "Nothing in all the world is more dangerous than sincere ignorance and conscientious stupidity" ― Martin Luther King, Jr "I would explain, but I don't have enough time or crayons" ― Unknown "I am always doing that which I cannot do, in order that I may learn how to do it" ― Pablo Picasso "The devil is in the details" ("God is in the details") ― Gustave Flaubert "But instinct is something which transcends knowledge. We have, undoubtedly, certain finer fibers that enable us to perceive truths when logical deduction, or any other willful effort of the brain, is futile" ― Nikola Tesla "Laughter is the shortest distance between two people" ― Victor Borge "I love and appreciate how much we have in common and also those places where we differ" ― Agent Pumpkin "If you tell the truth you don't have to remember anything" ― Mark Twain "Trust me my heart is always in a good place for you" ― Agent K^2 "Always think of those whom love you" ― Agent K^2 "There's never a moment when I'm not thinking of you. There will never be a time when I don't love you. ― Agent Pumpkin "I contend that for a nation to try to tax itself into prosperity is like a man standing in a bucket and trying to lift himself up by the handle" ― Winston Churchill "Yesterday is history. Tomorrow is a mystery. And today? Today is a gift. That's why we call it the present." ― First Lady Eleanor Roosevelt "First they came for the socialists, and I did not speak out— Because I was not a socialist. Then they came for the trade unionists, and I did not speak out— Because I was not a trade unionist. Then they came for the Jews, and I did not speak out— Because I was not a Jew. Then they came for me—and there was no one left to speak for me." ― Martin Niemöller "If you don't read the news, you're uninformed. If you do read the news, you're misinformed." ― Unknown
x
-
+
Hall of Fame
<
o
>
x
-
+
Sandbox
<
o
>
|PANES | | |PANES /^\ |PANES | |~~~| | | |^^^^^^^| / \ /^\ |[]+ | |~~~| |^^^^^^^| | +[]| | | | +[]|/\/\/\/\^/\/\/\/\|^^^^^^^| |+[]+ |~~~~~~~~~~~~~~~~~| +[]| | | [] /^\ [] |+[]+ | | +[]+| [] || || [] | +[]+| |[]+ | || || |[]+ | |_______|-----------------|_______|
Build a sand castle... or two!
x
-
+
Playground
<
o
>
__________ __ ___ \______ \ | _____ ___ __ ___________ ___ __ __ ____ __| _/ | ___/ | \__ \\ | |/ __ \ __ \ / __\| | \/ \ / __ | | | | |__/ __ \\___ / /_/ \ | \_\ /_/ | | / | \/ /_/ | |____| |____(____ / ____\___ /|__| \___/|____/|___| /\____ | \/\/ /_____/ \/ \/
Run around!

x
-
+
Garage
<
o
>
Park cars in here!

    Autozam AZ-1
    Honda Beat






x
-
+
SSH connection attempts
<
o
>
1. Filter for interactive SSH logins
   bash> grep sshd.\*Failed /var/log/auth.log | less

2. Filter for failed connections (i.e. no login attempted, could be a port scanner, etc)
   bash> grep sshd.\*Did /var/log/auth.log | less
              
x
-
+
Class Outline - 2018/02/20
<
o
>
  1. Terminal
    • Basics...
      • simple commands...hostname, whoami, pwd, ls...
      • less overhead
      • super flexible...can do everything!
      • great tools
      • automation
      • VI
    • SSH to webserver
      • file structure dev, run and production
      • Files...panes*, hangman*, etc
      • reversi
  2. Browser
    • mulitiple tabs
      • great for testing...don't refresh
    • incognito window
      • fooled me with localStorage
    • refresh
      • get programming change into memory
      • page is really messed up
    • Inspect/JavaScript console
      • find elements in pages
      • localStorage
      • view CSS
      • type in console
  3. Page "find" layout and functionality
    • issue with highlight inside panes
  4. To Do List
    • explain what I ran into making this pane
x
-
+
Agent Jinxes
<
o
>
Password:
x
-
+
Places to Visit
<
o
>
Paper Places!
x
-
+
Three Sysadmin Rules...
<
o
>
You Can’t (And Shouldn’t) Break

Rule #1: Backup Everything ( and validate the backup regularly )
Rule #2: Master the Command Line ( and avoid the UI if possible )
Rule #3: Automate Everything ( and become lazy )

Rule #4: Document very well ( in code and in man pages )
x
-
+
Island Albums (K^2)
<
o
>

Honorable mention:
x
-
+
Travel - NYC...Planning!
<
o
>



x
-
+
Agent Questions
<
o
>
Password:
x
-
+
Companies (Dream)
<
o
>
x
-
+
Interview Questions
<
o
>
Interviewer
What historical periods are you interested in?
What do you think is the most important invention?
What is your life story.  The decisions you made along the way, and why you made them.
What are the most difficult problems you have worked on and how did you solve them?
What was your favorite year in/of life?
What was your biggest missed opportunity?
Who do you look up to?
What is the one experience you would really like to relive?
Where do you see yourself in the next five years?
Do you enjoy focusing on one task or many?
Do you prefer working with people or alone?
Love job vs love pay?
Have you ever been fired, layed off, or asked to leave? If so, why?
Interviewee
What is the style of your general/project management?
What are goals and reviews like?
How big is the team I will be working on?
What exact platform(s) does your shop use?
What is your test environment like?
Do you pay for professional training?
Does this position require on call?
Do you pay for a work cell phone?
Do you have an ESPP and/or a 401K?
What is your vacation/holiday time?  Is it a PTO bucket?
What is your medical insurance like?
x
-
+
Island Albums (Pumpkin)
<
o
>
x
-
+
Idioms
<
o
>
Idiom: a group of words established by usage as having a
meaning not deducible from those of the individual words
Favorite idioms are colored
30,000 foot view
A bird in the hand is better than two in the bush
A bit of a stretch
(Even) A broken/stopped clock is right twice a day
A dime a dozen
(Throw) A curve ball
A hop, skip, and a jump
(Have) A lot on your plate
A pencil pusher
A picture is worth a thousand words
A roll in the hay
A rough patch
A sandwich short of a picnic
A storm is brewing
(Be) A weight off (one's) mind/shoulders
A white lie
A wolf in sheep's clothing
Above the law
Actions speak louder than words
Air (one's) dirty laundry
All bark and no bite
All hands on deck
All talk, no walk
All the marbles
Apple of my eye
Apples to apples
Apples to oranges
Are you game
As the crow flies
Ass handed to you
Assclown
At arm's length
At the back of (your) mind
At the drop of a hat
At the end of (your) rope
Average Joe
Baby steps
Back of the envelope
(Whoa,) Back the bus up
Back to square one
Back to the drawing board
Back to/against the wall
Backdoor
Backfire
Backseat driver
Backstabber
Bait and switch
Baked into (the cake)
Bald-faced lie
(The) ball is in your court
Ball of yarn
Balls to the wall
Balls-out
Bare bones
Barking up the wrong tree
Batten down the hatches
Be toast
Beat a dead horse
Beat around the bush
Beat the clock
Behind your back
Bells and whistles
Bend over backwards
Bent out of shape
Beside yourself with joy
(Put one's) Best foot forward
Bet you dollars to doughnuts
(The) Big cheese
Big deal
Bigger fish to fry
Bigwig
Bingo
(A) Bird's eye view
Birdbrain
Bite off more than you can chew
Bite the bullet
Bite your tongue
Black and white
Blank out
Black sheep
(A) Blessing in disguise
Blood in the water
Blow off (some) steam
Blow smoke
Blow sunshine up (one's) ass
Blow this popsicle stand
Blow your cork
Blown away
Blue in the face
Boatload
Boil down
Boil the ocean
Bold-faced lie
Bookworm
(A) Boomer
(Give someone) Both barrels
(The) Bottom line
Bottom of the barrel
Bottomless
Bottoms up
Box in
Brain freeze
Bread and butter
Break a leg
Break the ice
Bring home the bacon
Broaden your horizons
Broken record
Brownie points
Brush off
Bucket list
Buckle down
Bug someone
(Like a) Bull in a china shop
Bulletproof
Burn
Burn bridges
(Some money is) Burn(ing) a hole in your pocket
Burn(ing) daylight
Burn(ing) the Midnight oil
Burn(ing) daylight
Burying the hatchet
Bust (your) balls
Busy as a bee
Busy beaver
Butter up
Butterfingers
Butthead
Butthurt
Button your lip
Buttons are working but the electricity's out
(I don't) Buy it
Buzz off
By leaps and bounds
(To escape) By the skin of your teeth
Cadillac
Call in/out/off
(The) Calm before the storm
Came unleashed
(Open a) can of worms
(You) Can't change a leopard's spots
(You) Can't put the toothpaste back in the tube
Can't see the forest through the trees
Carry (someone's) water
Cash cow
Cat got your tongue?
Catch (one) red-handed
Caught with (one's) hand in the cookie jar
Chatty Cathy
(The) Check is in the mail
Checked out
Cherry-pick
Cherry on top
Chew (your) ear off
Chicken and egg
Chicken out
(A) Chip off the old block
(A) Chip on (your) shoulder
Circle the drain
Circle the wagons
Clam up
Clear sailing
Clapping seals
Clicky, clicky - K^2's own...when someone is doing some computer mouse work!
Cliffhanger
Close call
Close, but no cigar
Cloud nine
Clown(s)
Cold shoulder
Cold turkey
Come clean
Come out of (your) shell
Come unglued
Coming out of (your) ears
Coming out of the woodwork
Common denominator
Connect the dots
Cookie cutter
Cost an arm and a leg
Cough it up
Couldn't find (one's) way out of a paper bag
Couldn't pour water out of a boot if there was instructions on the heel
Country mile
Cover (your) bases
Crack the whip
Cramp (one's) style
Crap/shit sandwich
Crapshoot
Crickets
Cry (someone) a river
Cry over spilt milk
Crystal clear
(Not my) Cup of tea
Cut corners
Cut from the same cloth
Cut the cheese
Cut the cord
(To) Cut corners
Cut the mustard
Cut your losses
Cut both ways
Cut to the chase
(As) Cute as a button
Dangle a carrot
(In a) Dark alley
Dawn of a new day
Dawn on (someone)
Dead duck
Dead in the water
Dead soldier
Dead weight
Death trap
Deer in the headlights
Dial it back/down
Diamond in the rough
Diddly-squat
(A) Different ball game
(In a) Different light
Dime a dozen
Do a 180
Do a double take
Do unto others as you would have them do unto you
Do you a solid
Dodge a bullet
(Money) Doesn't grow on trees
Dog-ear
Dog eat dog
Dog pile
Dog them
Dog whistle
Doggy bag
(In the) Doghouse
Don't count your chickens before they hatch
Don't give up your day job
Don't have a leg to stand on
Don't poke the bear
Don't put all your eggs in one basket
(Don't put the) Cart before the horse
Don't shit where you eat
Dorkus maximus
(A) Double-edged sword
Double-dipping
Down for the count
Down the drain/crapper
Down wind
Drag (your) feet
Draw a line in the sand
Draw the shortest straw
Drop it
Drop like flies
Drop the ball
Dumpster fire
Duped
Eager beaver
Eagle eye
Early bird
Easy money
Easy on the eyes
Eat my dust
Eat crow
Egghead
Elbow grease
Elephant in the room
Elevator doesn't go to the top floor
Every cloud has a silver lining
Every pot has a lid
(When) Everything clicks (into place)
Everything but the kitchen sink
Evil eye
Excess baggage
Eye of the beholder
Eye of the storm
Fair-weather friend
Fall by the wayside
Fall into (your) lap
Fall off the wagon
Fall on your sword
Fall through the cracks
Falling into a trap
Fart in a windstorm
Fight fires
Fight tooth and nail
(The) Fine print
(Get) Fired
Firing on all cylinders
Fish for (something)
Fish out of water
Fishtailing
(Be) Fishy
Fit as a fiddle
Fixed their wagon
Flat-footed
(The) Flip side (of something)
Float an idea
Floats your boat
Fly in the ointment
Fly off the handle
(A) Fly on the wall
(With) Flying colors
Food chain
(Put) Foot in your mouth
(Get a) Foot in the door
For Pete's sake
For the long haul
Fork in the road
Frankly speaking (to be frank)
(As) Free as a bird
Free lunch
(Straight) From the horse's mouth
Full of it
Funny business
Game changer
Gang up on
Gaslight(ing)
Get back on the horse
Get canned
Get (your) ducks in a row
Get (your) feet wet
Get (your) hands dirty
Get (one's) hopes up
Get off my case
Get (something) off my chest
Get off on the wrong foot
Get off the ground
Get on the horn
Get the ax(e)
Get the ball rolling
Get the boot
Get the memo
Get the short end of the stick
Get this show on the road
Get to first base
Get to the bottom of (something)
Get under (your) skin
Getting a taste of your own medicine
Ghost town
Give (someone) a blank stare
Give me a break
Give (someone) the stink eye
Glass ceiling
(The) Glass is half full/empty
Go against the grain
Go big or go home
Go commando
Go down in flames
Go down the rabbit hole
Go hog wild
Go nuclear
Go postal
Go south
Go the way of the dodo (bird)
Go to bat (for someone)
Go to hell in a handbasket
Go up in smoke
Go with the flow
Gold plate(d)
Golden goose
Good bones
Grapevine
Grasping at straws
Gravy
Grease monkey
Grease the skids
(It's all) Greek to me
Greener pastures
Grow a pair
Grow on (someone)
Grumpy pants
(A) Guinea pig
Gun it
Gun shy
Hair-trigger
Half-baked
(The) Hamster has died but the wheel is still going
Ham-handed
Ham it up
Hand in glove
Hand over fist
Handful
Handle with kid gloves
(One's) hands are tied
Hang it up
Hang (one) out to dry
(As) Happy as a clam
Happy accident
Happy camper
(Cold,) Hard cash
Has a hollow leg
Hauling balls
Have a bee in your bonnet
Have a Dog in the fight
Have a good head on (your) shoulders
Have a screw loose
Have an ace up the sleeve
Have butterflies in (your) stomach
Have clean hands
Head for the hills
Head in the sand
Head over heels/feet
Heads up!
Healthy as a horse
Heartbreaking
(A) Heavy hand
(As) High as a kite
High horse
Hindsight is (always) 20/20
Hit (something) out of the (ball)park
Hit the ground running
Hit the hay
Hit the nail on the head
Hit the road
Hit your stride
Hogwash
Hold (your) breath
Hold feet to the fire
Hold (your) hand
Hold on to your hat
Hold the line
Hold water
Hold your horses
Hold your tongue
Holy cow
Homegrown
Homerun
Hoof it
Hook, line, and sinker
(The) Horse is out of the barn
Horse trading
(Eat) Humble pie
(Well,) I'll be a monkey's uncle
Icing on the cake
If I had a nickel for every time that happened (, I would be rich)
In a (pretty) pickle
In a pinch
In deep water
In my crosshairs
In one ear and out the other
In the bag
In the ballpark
In the black
In the blink of an eye
In the cards
In the flesh
In the hot seat
In the long run
(Keep) In the loop
In the nick of time
In the red
In the same boat
(Deep) In the weeds
In (your) wheelhouse
Into the wind
Iron out the wrinkles
(Too many) Irons in the fire
It takes two halves of scissors to cut
It takes two to tango
It's on me
Jog your memory
Joker(s)
Juggling act
Jump/throw in the deep end
Jump on the bandwagon
Jump ship
Jump the gun
Jump the shark
Jump through hoops
(A) Karen
Keep an ear to the ground
Keep an eye on (the ball)
Keep an eye out
Keep (your) eyes peeled
Keep (your) fingers crossed
Keep (your) nose to the grindstone
Kick the bucket
Kick the can down the road
Kick to the curb
Kill two birds with one stone
Kiss ass/up
Kiss (one's) ass
Knee-deep in (shit)
Knee-high to a grasshopper
Knock on wood
Knock (someone) over with a feather
Knocked out of the park
Know the animal
Knuckle sandwich
Land it
Laser focus(ed)
Lather, rinse, (and) repeat
Laugh all the way to the bank
Lay the groundwork (for something)
Leadfoot
Learn the ropes
Leave hanging
Leave it at the door
(To) Leave no stone unturned
Leave the door open
Left field
Legwork
Lend an ear (to someone)
Let it bake - K^2's own...the item needs more time to be done
Let (your) guard down
Let sleeping dogs lie
Let the cat out of the bag
Let the dust settle
Let the genie out of (or put the genie back in) the bottle
Level playing field
Lick your wounds
Lighten up
(The) Lights are on, but nobody's home
Lights out
Like a chicken with its head cut off
Like a (hot) knife through butter
Like night and day
Like (two) peas in a pod
Like riding a bike
Like shooting fish in a barrel
Like watching grass grow
Like watching paint dry
(The) Lion's share
Lip service
(A) Little bird told me
(The) Little things
Live and learn
Live high on the hog
Living large
Loaded question
Long in the tooth
Look a gift horse in the mouth
Look down on
Look someone in the eye(s)
Looking to your laurels
Look up on
Look what the cat dragged in
Loose cannon
Lose your shirt
Lost like a puppy
Lost your marbles
Low hanging fruit
Low man on the totem pole
(As) Mad as a hornet
Make waves
Make a mountain out of a molehill
Make the cut
Man down
Measure twice, cut once
Middle of the road
Mickey Mouse
Million-dollar question
(Get your) Mind out of the gutter
Mind your own business
Miss the boat
(A) Monday morning quarterback(ing)
Monkey around
Monkey business
(A) Monkey on/off your back
Monkey see, monkey do
Monkey wrench
Monkeys might fly out of my ass
More fun than a barrel of monkeys
More than meets the eye
Mouthpiece
Mouthful of marbles
Move mountains
(Have) Move(d) on
Move the goalposts
Mull over
My two cents
My way or the highway
(The) Nail in the coffin
Nail it
(A) Nail-biter
Nancy
Nature calls
(The) Nature of the beast
Neck and neck
Neck of the woods
(Like finding a) Needle in the haystack
Negative Nelly
Neither here nor there
Nervous Nellie
Night owl
No man's land
No picnic
No smoke
Not buy (it)
Not going to lose sleep over...
Not have two brain cells to rub together
Not playing with a full deck
Not the brightest crayon in the box
Not the sharpest knife in the drawer
Not the sharpest tool in the shed
Not touch with a ten-foot pole
Nothing to sneeze at
Nothing ventured, nothing gained
Nuke it
Odd duck
Oddball
Off the cuff
Off the deep end
Off the hook
Off the table
(Right) Off the top of my head
Off your rocker
Old school
On a different planet
On a dime
On a lark
On a roll
On a shoestring (budget)
On board
On fire
On hand
On (your) nerves
On paper
On pins and needles
On the back burner
On the ball
On the board
On the fence
On the front burner
On the lam
On the line
On the nose
On the other hand
On the ropes
On the same page
On the table
On the tip of the tongue
On the up-and-up
On your soapbox
Once-over
Once in a blue moon
One for the books
One trick pony
(A) One-way street
Only rowing with one oar
Open the floodgates
(The) Other side of the coin
Out in the cold
Out of hand
Out of sight, out of mind
Out of step
Out of the blue
Out of the box
Out of the frying pan into the fire
Out of the woods
Out the window
Out to lunch
(Think) Outside of the box
Over (your) head
(Out) Over (one's) skis
Over the hill
Over the top
Pan out
Paint a picture
Paint yourself into a corner
Paint (something) with a broad brush
Panties in a bunch
Par for the course
Park it
Parrot(ing)
Pave the way
Pawn
Pawn off
Peanuts
Pee like a racehorse
Peeling back the onion
Pencil out
(A) Penny for your thoughts
Pepper(ing)
(A) Perfect storm
Pet peeve
Peter out
Photo finish
Pick of the litter
Pie in the sky
Piece of cake
Piece of shit
Pig out
Pigskin
Pile of crap
Pillow talk
Pipe dream
Pit stop
Plain Jane
Play cards close to chest
Play hardball (with someone)
Play for both teams
Plenty of fish in the sea
Point the finger at (one)
Poker face
Polish off
Poop or get off the pot
Pound sand
Pour gasoline on the fire
Practice makes perfect
(A) Pretty penny
(The) Proof is in the pudding
Pull someone's leg
Pull out all the stops
Pull out of a hat
Pull the rug (out) from under
Pull the trigger
Pull/yank someone's chain
Pump (some) iron
Pump the brakes
Punt
Puppet show
Puppy love
Push (your) buttons
Push the envelope
Put a bug in (one's) ear
Put a finger on it
Put a sock in it
Put out to pasture
Put through the ringer
Put your money where your mouth is
Raining cats and dogs
Raise the bar
Rat race
(A) Ray of sunshine
Read between the lines
Red flag
Red herring
Red-headed stepchild
Red tape
(Take a/the) Redeye
Reinvent the wheel
Ride (off) into the sunset
Ride shotgun
Right up your alley
Ring a bell
Rip off the Band-Aid
Ripped (one) a new one
Risk it for the biscuit
Road Hog
Roadblock
(Don't) Rock the boat
(It's not) Rocket science
Roll the dice
Roll up your sleeves
Roll with the punches
Roller coaster
Row one's own boat
(A)Round the Clock
Rub it in
Rub off
Rub salt into the wound
(Where the) Rubber meets the road
Rubberneck
Run around in circles
Run away with (something)
Run of the mill
Run(ning) out the clock
Sail close to the wind
Save (your) bacon
Save for a rainy day
School(ed)
Scrape the barrel
Scratch your back
Screw the pooch
Scrub down (like a crime scene)
(Play) Second fiddle
Second hand
See eye to eye
See in a new light
Seeing color for the first time
Sell (one) down the river
Set in stone
Seventh heaven
Shake in boots
(As) Sharp as a tack
Shed light on something
Ships that pass in the night
Shirt off my back
(When the) Shit hits the fan
Shoe is on the other foot
Shoot
Shoot down
Shoot for the moon
Shoot the breeze
Shoot yourself in the foot
Shot across the bow
Shouting match
Shove off
Show (one) the door
Show your hand
Shut down
Shut the front door
Shut your pie hole
Sick as a dog
Sidetracked
(A) Sight for sore eyes
Silver bullet
Silver lining
Simmer down
Sing a different tune
Sink in
Sink or swim
Sit on (one's) hands
Sit(ting) on the fence
Sitting duck
Skating on thin ice
Skating rink
Skin in the game
Slap on the wrist
Sleep tight
Slip through the cracks
Slippery slope
Slowpoke
Small fry/fries
Small potatoes
Smoke and mirrors
Smooth sailing
Smoking gun
(At a) Snail's pace
Snowballed
Snowflake
Soccer mom
Social butterfly
Soft-pedal (something)
Softball question
(As) solid as a rock
(A) Sore loser
Sour grapes
Southpaw
Space out
Speak of the devil
Spill (the beans)
Spin a yarn
Spin (your) wheels
Spit it out
Splitting hairs
Spoon
Spoon feed/fed
Spot on
Spread your wings
Spring chicken
Square with
Squared away
Squeaky clean
Squeaky wheel gets the grease
Squirrel away
Squirrel (out of)
Stab someone in the back
Stand still
(When the) Stars align(ed)
Start off on the right foot
Stay in your lane
Steal (your) thunder
Steamrolled
Step on a rake
Step up (your) game
Step up to the plate
Stepping into (something)
Stick a fork in it
(A) Stick in the mudd
Stick to (your) guns
Stick up (your) ass
Stir the pot
(A) Stone's throw away
Straight as an arrow
Straight shooter
(The) Straw that broke the camel's back
Strike while the iron is hot
(As) Stubborn as a mule
Suck it up (buttercup)
Suck ass
Suck up (to someone)
Sugarcoated
Sunset(ing)
Sweating bullets
Sweep (something) under the rug
Sweet tooth
Swimming upstream
Switch gears
Switch-hitter
Tailgating
Take a/the bullet (for someone)
Take a hike
Take a page out of (your/the) book
Take a stab (at something)
Take (someone or something) at face value
Take (something) for a spin
Take on water
Take one for the team
Take the bull by the horns
Take the high road
Take the low road
Take to the cleaners
Take with a grain of salt
Tap out
Test the water(s)
That dog won't hunt
That ship has sailed
That's how the cookie crumbles
The apple doesn't fall far from the tree
The big picture
The cat is out of the bag
The devil is in the detail(s)
The grass is always greener (on the other side)
The grass roots
The night is still young
The pot calling the kettle black
The sky's the limit
The third degree
The wheels come off
The whole nine yards
The world is your oyster
There's a new sheriff in town
There's more than one way to skin a cat
Thick skin
This ain't my first rodeo
(A) Thorn in my side
Thread the needle
Throttle down
Throw (one) to the wolves
Throw the book at (someone)
Throw (someone) a bone
Throw (your) hat in the ring
Throw in face
Throw in the towel
Throw the baby out with the bath water
Throw (someone) under the bus
Tides change
Tight ship
Time flys (when you're having fun)
Tinfoil hat
Time on your hands
(A) Tip of the hat
Tip of the iceberg
Tires popped but the wheels still spinning
(Go) To hell in a handbasket
To taste
To taste
(With) tongue in cheek
Toot (your) own horn
Top dog
Top it (all) off
(The) Top of the line
Top-shelf
Touchdown
(A) Tough nut to crack
(A) Tough cookie
Train wreck
Trojan horse
Truck it
True colors
Tunnel vision
Turn into a pumpkin
Turn off
Turn the tables (on someone)
Two sides of the same coin
Under your belt
Under (your) skin
(Look) Under the hood
Under the radar
Under the sun
Under the table
Under (one's) thumb
Under the weather
Under the wire
Under your breath
Under water
Underwater basket weaving
Until the cows come home
Up in the air
Up shit creek (without a paddle)
Up the ante
Up to par
Up your sleeve
Uphill battle
Upside down
(The) Upshot (of something)
Use your head for something other than a hatrack
Waffling
Wait for the other shoe to drop
(Narrow) Window of opportunity
Walk a mile in someone's shoes
Walk away
Walk it off
Walk on eggshells
Walk right into
Walk the plank
Walk the talk
Watch like a hawk
Watch your six
Water down
Water under the bridge
Weather the storm
(A) Wet blanket
What a zoo
What's the damage?
What's your beef?
When pigs fly
Where the rubber meets the road
Where there's a will, there's a way
Whipping boy
White-knuckle
Whole ball of wax
Wild goose chase
Wind down
Window of opportunity
With (one's) tail between (one's) legs
(The) Whole shebang
Wiggle room
Wing it
Wishy-washy
Wolf down
Woke up on the wrong side of the bed
Word salad
Work spouse
Working like a dog
Worth your salt
Would give the shirt off my back
The (hand)writing on the wall
Yank (your) chain
You can lead a horse to water but you can't make it drink
You can take that to the bank
You're screwed
You can't teach an old dog new tricks
You're a numbskull
Yum, yum - K^2's own...when someone is eating up his BS!
Zip your lips
Zipper in (line) - K^2's own...merging two lines

List of proverbial phrases
x
-
+
Agent Emojis (ASCII)
<
o
>
;)u winky tongue
^^)u silly tongue
;3* kissy
(bb) bear (brown) ... pairs well with "huggy"
(bp) bear (panda) ... pairs well with "huggy"
(^^8)) huggy
**^o^ heart eyes
:(? thought
:'( sad
:8^v^ embarrassed
^^8) blush
:8| rolling eyes
'><8 very upset
^^)*** three hearts (kisses) on face
x
-
+
IKBB
<
o
>
Password:
x
-
+
Travel - NYC...Visit!
<
o
>

x
-
+
Travel Games
<
o
>
Scavenger Hunt...find the following: Once found you must take a photograph or preferably a selfie with the item/place!
Find on location or take an item to be photographed with you on your journey.
Buy inexpensive gift shop items ($10-20) that YOU would like to keep.
But these are for friends and family!
Have a White elephant gift exchange type party for friends and family upon returning!
x
-
+
PostgreSQL
<
o
>
PostgreSQL: The world's most advanced open source database
PostgreSQL: Documentation
FAQ - PostgreSQL wiki
DB-Engines Ranking - popularity ranking of database management systems
PostgreSQL
phpPgAdmin
psql
  • Client config file
    • ${HOME}/.psqlrc
    • \set PROMPT1 '%[%033[1;37m%]%M:%> %n@%/%R%#%x%[%033[0m%] '
    • \set PROMPT2 ''
    • \pset
    • \pset null '(NULL)'
    • \set user 'SELECT current_user;'
    • \echo 'Message here!\n'

  • List version
    • SELECT version(   );

  • List databases
    • \list;
    • \l;

  • Connect
    • psql -U postgres [-d databaseName]
    • \c databaseName

  • Help
    • \?
    • \? [commands]
    • \? [options]
    • \? [variables]
    • \h [NAME]

  • Pager...uses environment's "PAGER" variable
    • \pset pager off
    • \pset pager on

  • Edit query buffer...uses environment's "EDITOR" variable
    • ctrl-alt-j
    • \e

  • Command history
    • \s

  • Execute commands from a file
    • \i filename

  • Clear screen
    • \! clear

  • Set variables
    • \set
    • \set version 'SELECT version(   );'
    • \set user 'SELECT current_user;'
    • \set extensions 'SELECT * FROM pg_available_extensions;'
    • \set nopager '\\pset pager off'
    • \set pager '\\pset pager on'
    • \set ls '\\echo `ls`'
    • \set ECHO_HIDDEN
    • \unset ECHO_HIDDEN
    • \pset linestyle unicode \pset border 2
    • reset variable;
    • reset all;

  • Show (show the value of a run-time parameter)
    • SHOW all;
    • SELECT * FROM pg_catalog.pg_settings;
    • SHOW parameterName;
    • SELECT * FROM pg_catalog.pg_settings WHERE name = 'parameterName';
    • SHOW search_path;

  • Set (change a run-time parameter)
    • SET name TO value;
    • SET search_path TO schemaName;

  • List databases
    • \l
    • \l+
    • SELECT datname FROM pg_database;

  • List tables
    • \dt
    • \dt+
    • \d table
    • \d+ table
    • SELECT
        *
      FROM
        pg_catalog.pg_tables
      WHERE
        schemaname != 'pg_catalog'
        AND
        schemaname != 'information_schema';
    • \dt schemaName .*
    • \dt *

  • List schemas (namespace)
    • \dn
    • SELECT * from pg_catalog.pg_namespace;
    • SELECT current_schema;
    • \dn+
    • SELECT
        n.nspname AS "Name",
        pg_catalog.pg_get_userbyid(n.nspowner) AS "Owner",
        pg_catalog.array_to_string(n.nspacl, E'\n') AS "Access privileges",
        pg_catalog.obj_description(n.oid, 'pg_namespace') AS "Description"
      FROM
        pg_catalog.pg_namespace n
      WHERE
        n.nspname !~ '^pg_'
        AND
        n.nspname <> 'information_schema'
      ORDER BY 1;

  • List objects (table, view, sequence, or index) definition
    • \d schemaName.<tab><tab>
    • \dtvs *   --tables/views/sequences
    • \dtvs schemaName.*   --tables/views/sequences
    • \d schemaName.*
    • SELECT
        table_name,
        column_name,
        data_type
      FROM
        information_schema.columns
      WHERE
        table_name = '
      tableName';

  • Extensions
    • \dx
    • SELECT * FROM pg_available_extensions;

  • List users (roles)
    • \du
    • \du+
    • SELECT * FROM pg_user;
    • SELECT CURRENT_USER;
    • SELECT
        *
      FROM
        information_schema.role_table_grants
      WHERE
        table_name = '
      tableName';

  • SQL comments
    • -- one line comment
    • /* multi line comment(s) */

  • Create database
    • CREATE DATABASE databaseName;

  • Create table
    • CREATE TABLE tableName
      (
        
      id  serial not null primary key,
        
      dtCreated  timestamp not null,
        
      dtUpdated  timestamp,
        
      data  jsonb
      );

  • List object (table, view, sequence, or index) access privileges
    • \dp object
    • \z object

  • Grants
    • GRANT USAGE ON SCHEMA schema TO userName;
    • GRANT SELECT, INSERT, UPDATE ON tableName TO userName;
    • GRANT SELECT, UPDATE ON SEQUENCE tableName_fieldName_seq TO userName;

  • Select
    • SELECT columns FROM tableName;
    • SELECT columns FROM tableName WHERE expression;
    • SELECT columns FROM tableName WHERE expression LIMIT integer OFFSET integer;
    • SELECT columns FROM tableName WHERE expression ORDER BY column NULLS FIRST;
    • SELECT c.relname FROM pg_class c WHERE c.relkind = 'S';
    • SELECT * FROM tableName_fieldName_seq;

  • Repeat query
    • \g
    • \watch seconds

  • Set/unset timer
    • \timer

  • Insert
    • INSERT INTO tableName( dtCreated, data ) VALUES( now(), '{}' );

  • Delete record(s)
    • DELETE FROM tableName WHERE id >= 1000000;

  • Export table to CSV file
    • \COPY tableName TO 'path/fileName.csv' CSVheader;

  • Import table from CSV file
    • \COPY tableName FROM 'path/fileName.csv' WITH( FORMAT CSV );

  • Alter sequence
    • ALTER SEQUENCE tableName_fieldName_seq RESTART WITH 1;

  • Truncate table
    • TRUNCATE tableName;
    • TRUNCATE tableName RESTART IDENTITY;

  • Drop table
    • DROP TABLE tableName;

  • Active connections (w/query)
    • SELECT
        pid,
        datname,
        usename,
        application_name,
        client_hostname,
        client_port,
        backend_start,
        query_start,
        query,
        state
      FROM
        pg_stat_activity
      WHERE
        state = 'active';

pg_dump
  • Dump database
    • pg_dump databaseName
    • pg_dump --create databaseName
    • pg_dump --create --schema-only databaseName

  • Dump table
    • pg_dump --schema-only --table=tableName databaseName
    • pg_dump -st tableName databaseName
x
-
+
ID Generator
<
o
>
Length
Characters
x
-
+
Travel Map
<
o
>
Travel Map
x
-
+
Interesting Words
<
o
>
x
-
+
Open Reversi
<
o
>
x
-
+
Notes (ASCII)
<
o
>
Notes should be taken in an ASCII text editor...not Word, Excel, OneNote, etc.
  • You can name this file anything, but for this example I named it "notes.txt".
  • I use "] CCYY/MM/DD [" as my date delimiter...the first script requires it.
  • I also use ")|(" and "~~~" as item delimiters.
  • I mark up my notes.txt file with tags/labels.
  • I put almost everything under the sun in my notes, but if too big I put in a separate file referencing the path (URL).
  • I backup my notes at least once a month manually!!!  (Can't setup cron because I am using Windows/Cygwin).
  • I have been admired/complemented by other for my notes practices.
  • They take time to record, but save time in the long run.
  • They help with accountability.
  • They greatly help with managerial summary reporting.
  • Use as a scratch pad area.


This script is to display a date range from the ASCII notes file.
#] user@workstation ~/doc/notes [# cat notesDays.sh #!/bin/sh #set -x # 2018/01/02; notesDays.sh; Kent M Kohlmeyer if [ $# -lt 6 ] then printf "\e[1mUsage: $(basename $0) <CCYY> <MM> <DD> <CCYY> <MM> <DD>\e[0m\n" exit 1 fi sed -n "/^\] ${1}\/${2}\/${3}/,/^\] ${4}\/${5}\/${6}/p" notes.txt


This script has a case insensitve grep of word(s) from the ASCII notes file...it builds and displays the command to run!
#] user@workstation ~/doc/notes [# cat notesGrep.sh #!/bin/bash #set -x # 2018/08/22; notesGrep.sh; Kent M Kohlmeyer if [ ${#} -eq 0 ] then printf "\e[1mUsage: $(basename $0) [expression] ...\e[0m\n" exit 1 fi count=1 while [ ${count} -le ${#} ] do if [ ${count} -eq 1 ] then command="grep -i \"${!count}\" notes.txt" else command="${command} | grep -i \"${!count}\"" fi count=$(expr ${count} + 1) done printf "\e[1m${command}\e[0m\n" eval ${command}
x
-
+
Agent Vocab
<
o
>
Agent Hangout
Agent Hideout
Agent Hookup
Agent Lighting
Agent Position
Agent Warehouse
Ahrendts
Annie very sorry
Antipasta
AIU
Aww jeeze
Bambi
Bendy
Boiling
Bugging
Chef
Chewing (ear off)
Crapple
Dorkus maximus
Dory
Goldfish(ed)
Ear buddies
FBI
Faline
Feelers
Froggy
Gadget
GFC
GFJ
git
Have fun Maria!
Hey
Hoover
ICE
IKBB
Inhale
IP
Jerkface
Jussie and/or Smollett
K&A
Kiddos
Koji
Little Pumpkin
LKF
LBB
LWP
Machine gunning
Mamma
Maria
Marvin
Meanie pie
M&V then MVR
Mwah!/M!
Olivia
OGP
Optional
Oque
[Morning] paper
Pasta
Pete and Repeat...
Penny
Peter
Pizza SOG
PM then FRSH
Post Maloned
Que
Queueless/Queuemore
Rob Rob
Smollett
Sofa [king]
Squirrel(s)
Tesla Effect
TM
TOO!!!
TOP!!!
Toji
Tonta
URSKW
Up North
Wally World
WWPD
Who
Yum, yum
x
-
+
What School Didn't Teach
<
o
>
How liberal the school system is!!!
To be your own person...don't be a follower!!!
How to read an analog clock.
How to do your taxes.
How to stay organized.
How to balance a checkbook.
Learning from Failure.
x
-
+
Samsung Gear S3 Frontier (info)
<
o
>
This is the only smart watch I have owned.  I love my Gear or I should say "Gadget"!?!  Named after Inspector Gadget.
I named my GFs Apple watch "Penny".  Below are just a few things I really like about Gadget.

  • Hardware
    • bezel (smooth and easy navigation)
    • speaker/microphone (great sound)
    • battery (long life)
    • screen (sharpness visual and touch)
    • many sensors
    • many great bands (third party)
  • Software
    • "Sleep" widget
    • all your downloads are available on your phone...Galaxy Wearable -> Discover -> Top banner -> Sandwich Menu -> MY APPS -> All
    • tons of awesome free faces
    • screen shot(s)...they go to Gadget's "Gallery"
    • transfer one/multiple images from "Gallery" to phone
    • use your hand (quickly) cover/uncover screen to have Gadget sleep
    • "Phone" & "Contacts" (messaging)...can send and receive from Gadget
    • some free apps/games/widgets...time ("Stopwatch", "Timer", "Alarm", "Reminder", etc.), etc.
    • "Find My Phone"
    • "Music"
    • backup to Samsung's Cloud
    • "Samsung Health"
      • steps (pedometer)
      • floors climbed
      • heart rate
      • calories burned
      • nudges (asks you to stretch, etc....if inactive)
      • automatically/manually record workouts



x
-
+
OcciSpace
<
o
>
My personal Office Space.  Named "OcciSpace" because of a company I worked for for many years with a similar name.

Funny usernames that were real:
Michael Rice
mrice
(mister ice)
Heather Ott
hott
Phil Hartman
phartman
Chris Rapp
crapp
Mark Robinson
mr.admin
Sean Odom
so.admin

"I am sofa king we todd did"...we put this on our whiteboard and had passing/visting people read it.
Sometimes twice or three times.
They sounded retarded.
We laughed sofa hard!

The accounting manager walked by my fish bowl while I was debugging some code.
I was bored (sleepy) looking for the issue and just kept hitting a lot of "enters".
The manager said he could do that for what I make.
I said the hard part is knowing when to stop.

A short boss left his cup in the bathroom on the paper towel dispenser.
I saw it and thought it was his, but was not sure because the dispenser is pretty high.
I overheard my boss telling a coworker he misplaced his cup.
I then stepped in and told him I knew where it was but didn't think he could reach that high!
He started reaching up to the top of cubicals. Etc

I was talking to my best friend about a super liberal person we know.
And I made a joke...she is libbing it up.
My best friend thought I said she was living it up.

Being "optional" means not being at work for a bogus reason!

Having meetings about meetings!

I get git!

Ahrendting (a dude, his name, that was always...running errands instead of working)!

Chef and Money!

More and better to come...haven't given much time to this pane!
x
-
+
Samsung Gear S3 Frontier (faces 1)
<
o
>
x
-
+
Chicken or the Egg
<
o
>
UNIX and C
  • UNIX was developed using assembly (language) in 1969
  • C was developed in 1972
  • UNIX was rewitten using C (language) in 1973
Databases and their system tables
  • MySQL, PostgreSQL, Informix, etc use their own engine/table technology to store their calalog, statistic, etc
panes.us and tools in page to help build itself
  • "ID Generator" pane is used to generate file names for the "Audio Clips" pane
  • "To Do" pane is used to manage thing to add/change with this page
  • "Releases" pane is used to display changes with this page
A blacksmith and their anvil
  • A blacksmith used his anvil to make brackets to hold the anvil
3D printer
  • Many parts to improve a 3D printer can be printed by/with itself
Lightning and thunder
  • They occur at the same time if you are at the source, but if at a distance the lightning appear first to our senses
backup.sh
  • I wrote backup.sh to backup chosen files...even "backup.sh" itself.
Shazam/Soundhound
  • Use either app to listen/recognize music on the same phone
  • Can listen to each other.
  • Close, but Shazam was first
Telphone
  • Sometimes a telephone is used to call its telphone service provider
S&P
  • S&P Global is on the S&P 500...the same company
Linux/Unix "man" command
  • man man
HTML URL Encoding
  • '%' = '%25'
x
-
+
Phonetic Alphabet (names)
<
o
>
Like...NATO phonetic alphabet,
but using first names.

A
=
Allison
B
=
Bruce
C
=
Cathrine
D
=
David
E
=
Erica
F
=
Frank
G
=
Genevieve
H
=
Henry
I
=
Isabella
J
=
Jack
K
=
Karissa
L
=
Lenny
M
=
Maria
N
=
Neil
O
=
Olivia
P
=
Paul
Q
=
Quinton
R
=
Ryan
S
=
Samantha
T
=
Ted
U
=
Uma
V
=
Victor
W
=
Wendy
X
=
Xavier
Y
=
Yvonne
Z
=
Zack
x
-
+
Fun Words to Swipe!
<
o
>
Ordered by discovery
remember
crazy
jackie
looking
jeanie
james
bananas
management
recently
bear and/or beast
wouldn't
band
panini
recently
probably
content
someone (two circles or two triangles)
watch
olives
slept
event
painful
whenever
thinking
watched
potatoes
paperwork
x
-
+
Astrological Signs
<
o
>
Astrological Signs
x
-
+
Time Share Game
<
o
>
Share fun times by texting with a friend(s)...
letting them know you are thinking of them.
Don't force...let it happen naturally.
Military time ups the game!
It is really cool to share a time that matches
two categories.
In order of favorites:
11:11, 5:55, etc (all the same digit)
11:31, 12:22, etc (three of a kind)
12:48, 2:46, 3:57, etc (patterns)
10:10, 11:22, 5:33, etc (pairs)
12:34, 1:23, 4:56, etc (serial ascending)
5:43, 4:32 and 3:21 (serial descending)
10:01, 5:05, 12:21, etc (palindromes)
2:11, 5:23, 9:18, etc (sides add the same)
8:26, 2:11, 11:02, etc (add producing other side)
8:42, 4:22, etc (mulitply producing other side)
2:42, 1:54, etc (subtract producing other side)
12:24, 2:42, 1:44, etc (divide producing other side)
12:25, 3:14, 4:20, etc (dates)
1:00, 7:00, 10:00, etc (on the hour)

Matches two categories:
11:11 (4 of a kind & palindrome)
10:01, 12:21, 2:42, 3:03, etc (pair(s) & palindrome)
1:55, 2:11, 4:22, 6:33, 11:02 & 1:44 (pair & math)
etc
x
-
+
Friday Five
<
o
>
 Markley, Van Camp & Robbins

 They take something that's in the news.
 Then they make a countdown around it...
 usually it's music based.

 Three criteria
 1) How big of a hit was the song?
 2) How well does it stand the test of time?
 3) How much do you personally like it?

 They rank them individually and come up with the top five.

 Friday Five Archives - KTSA

 2021-12-03 - Songs with "see" or "seeing" in the title
 (Due to Gift Of Sight Month)

 2021-11-26 - Thanksgiving weekend (no Friday Five)

 2021-11-19 - Greatest TV themes of all time
 (Due to World Television Day)
1) Seinfeld...Seinfeld Theme by Jonathan Wolff
4) The Brady Bunch...The Brady Bunch Theme by Frank De Vol

Honorable Mention
The Andy Griffith Show...The Fishin' Hole by Earle Hagen and Herbert W. Spencer
Three's Company...Come and Knock on Our Door by Ray Charles and Julia Rinker

Caller Suggestions
WKRP in Cincinnati...WKRP in Cincinnati Theme by Tom Wells and Hugh Wilson
The Munsters...The Munsters' Theme by Jack Marshall

 2021-11-12 - Great musical artists to come from Texas
 (Due to broadcasting from Alamo Lounge in San Antonio)

 2021-11-05 - Songs that (predominantly) feature saxophones...would the song not be the same without the saxophone?
 (Due to National Saxophone Day)

 2021-10-29 - Songs with "black" in the title.
 (Due to National Black Cat Day and Halloween)

 2021-10-22 - Greatest stutter songs of all time.
 (Due to International Stuttering Awareness Day)

 2021-10-15 - Songs with "sweet" in the title.
 (Due to Sweetest Day)

 2021-10-08 - Songs with "song" in the title.

 2021-10-01 - Greatest musical trios of all time.
 (The first time all three have been together on Friday in around a month)

 2021-09-24 - Songs with the word "out" in the title.
 (Due to the border issue...people trying to enter the US illegally should be out)

 2021-09-17 - Women fronted rock bands.
 (In honor of Women's Friendship Month)

 2021-09-10 - Songs with "together" in the title.
 (In honor of the 20th anniversary of 9/11.)

 2021-09-03 - Songs with "summer" in the title.
 (Entering Labor Day Weekend...we are saying goodbye to summer.)

 2021-08-27 - Songs with "hero" in the title.
 (Paying tribute to people who have lost their lives this week.)

 2021-08-20 - Songs with "lttle" in the title.
 (Due to League World Series.)

 2021-08-13 - Songs with "hot" or "heat" in the title.
 (Due to the current heat wave.)

 2021-08-06 - Songs with the word "kiss" in the title.
 (In honor of one Governor Andrew Cuomo who talked about how much he likes grabbing people by the face and kissing them.)

 2021-07-30 - Greatest singing bassists of all time.
 (In honor of Dusty Hill of ZZ Top)

 2021-07-23 - Songs with "run or running" in the title.
1) Band On The Run - Paul McCartney & Wings
2) Runnin' With The Devil - Van Halen
3) Running On Empty - Jackson Browne
4) Runnin' Down A Dream - Tom Petty And The Heartbreakers
5) Take The Money And Run - The Steve Miller Band

Honorable Mention
Fox On The Run - Sweet

Callers Suggestions
Born To Run - Bruce Springsteen
Run Through The Jungle - Creedence Clearwater Revival
Run To The Hills - Iron Maiden
Run Like Hell - Pink Floyd
The Long Run - Eagles
Da Do Run Run - The Crystals
Take It On The Run - REO Speedwagon

 2021-07-16 - Songs with "the name of a planet or the moon" in the title.
 (Van Camp had a quick note:
  "Darkside Of The Moon" by Pink Floyd is an album title, NOT a song title.
  "Brain Damage" playing in the background.)
1) Dancing In The Moonlight by King Harvest
2) Bad Moon Rising by Creedence Clearwater Revival
3) Heaven Is A Place On Earth by Belinda Carlisle
4) Venus by Bananarama
5) Drops Of Jupiter by Train

Callers Suggestions
Bark At The Moon - Ozzy Osbourne
Fly Me To The Moon - Frank Sinatra
Walking On The Moon - The Police
Blue Moon - The Marcels
Shame On The Moon - Bob Seger
Jupiter's Child - Steppenwolf
Marching To Mars - Sammy Hagar
Man On The Moon - R.E.M.
Moon River - Andy Williams
I Feel The Earth Move - Carole King

 2021-07-09 - Greatest bald musicians of all time.
 (bald at height of career and focal point of success)
1) Phil Collins
2) Darius Rucker
3) Billy Joel
4) Kenny Chesney
5) James Taylor

Honorable Mention
Joe Satriani

Callers Suggestions
Louis Armstrong
Rob Halford
Tony Levin
Billy Corgan
Geoff Tate
Michael Stipe
Peter Gabriel

 2021-07-02 - Song titles with "America" or "USA" in it
1) American Woman by The Guess Who
2) We're An American Band by Grand Funk Railroad
3) God Bless the USA by Lee Greenwood
4) American Girl by Tom Petty & The Heartbreakers
5) American Pie by Don McLean

Callers Suggestions
Miss America by Styx
Born In The USA by Bruce Springsteen
R.O.C.K In The U S.A by John Mellencamp
Living In Ameircan by James Brown
Party In The U.S.A. by Miley Cyrus
The Happiest Girl In The Whole U.S.A. by Donna Fargo
Back In The USA by Chuck Berry
x
-
+
Song Duets
<
o
>

   Mostly Duets, but some Trios and paired with DJs, etc

Date (release)
Song
Artists
1965-07-09
I Got You Babe
Sonny & Cher
1978-01
Mammas Don't Let Your Babies Grow Up to Be Cowboys
Waylon Jennings with Willie Nelson
1978-05-12
You're The One That I Want
John Travolta & Olivia Newton John
1978-08-25
Summer Nights
John Travolta & Olivia Newton John
1983-08-15
Islands in the Stream
Kenny Rogers and Dolly Parton
1986-09
The Next Time I Fall
Peter Cetera and Amy Grant
1987-07-10
(I've Had) The Time Of My Life
Bill Medley & Jennifer Warnes
1989-02-02
Close My Eyes Forever
Ozzy Osbourne & Lita Ford
1989-11-28
Opposites Attract
Paula Abdul & The Wild Pair
1994-05-10
Wild Night
John Mellencamp and Meshell Ndegeocello
2000-11-07
It Wasn't Me
Shaggy ft RikRok
2002-03-01
Hero
Chad Kroeger ft Josey Scott
2002-06-25
Dilemma
Nelly ft Kelly Rowland
2002-11-12
Picture
Kid Rock ft Sheryl Crow
2003-05-18
Crazy In Love
Beyoncé ft JAY-Z
2004-01-27
Yeah!
Usher ft Lil Jon & Ludacris
2004-03-29
Whiskey Lullaby
Brad Paisley ft Alison Krauss
2004-04-19
Broken
Seether ft Amy Lee
2004-10
Touché
Godsmack ft John Kosco and Lee Richards of Dropbox
2006-02-14
Hips Don't Lie
Shakira ft Wyclef Jean
2006-04-25
Promiscuous
Nelly Furtado & Timbaland
2006-06-06
(When You Gonna) Give It Up To Me
Sean Paul ft Keyshia Cole
2006-07-18
SexyBack
Justin Timberlake ft Timbaland
2007-01-23
Glamorous
Fergie ft Ludacris
2007-02-12
Beautiful Liar
Beyoncé and Shakira
2007-08-24
Hate That I Love You
Rihanna ft Ne-Yo
2008-02-11
No Air
Jordin Sparks ft Chris Brown
2008-04-08
Just Dance
Lady Gaga ft Colby O'Donis
2009-01-13
Lucky
Jason Mraz & Colbie Caillat
2009-01-27
Right Round
Flo Rida ft Kesha
2009-10-20
Empire State Of Mind
JAY-Z ft Alicia Keys
2010-01
Home
Edward Sharpe and the Magnetic Zeros (Alex Ebert and Jade Castrinos)
2010-04-13
Airplanes
B.o.B ft Hayley Williams
2010-06-18
Talkin' 2 Myself"
Eminem ft Kobe
2010-06-18
Won't Back Down
Eminem ft Pink
2010-06-18
Love The Way You Lie
Eminem ft Rihanna
2010-10-25
What's My Name?
Rihanna ft Drake
2010-11-12
Love the Way You Lie (Part II)
Rihanna ft Eminem
2011-02-08
On the Floor
Jennifer Lopez ft Pitbull
2011-03-15
Give Me Everything
Pitbull ft Ne-Yo, Afrojack, & Nayer
2011-06-14
Stereo Hearts
Gym Class Heroes ft Adam Levine
2011-06-21
Moves like Jagger
Maroon 5 ft Christina Aguilera
2011-07-05
Somebody That I Used To Know
Gotye ft Kimbra
2011-07-19
Got 2 Luv U
Sean Paul ft Alexis Jordan
2011-12-09
Titanium
David Guetta ft Sia
2011-12-19
Wild Ones
Flo Rida ft Sia
2011-12-20
Little Talks
Of Monsters and Men
2012-04-16
Payphone
Maroon 5 ft Wiz Khalifa
2012-10-24
Beauty and a Beat
Justin Bieber ft Nicki Minaj
2012-12-13
Stay
Rihanna ft Mikky Ekko
2013-02-26
Just Give Me A Reason
P!nk ft Nate Ruess
2013-07-14
Everything Has Changed
Taylor Swift ft Ed Sheeran
2013-10-07
Timber
Pitbull ft Kesha
2013-10-29
The Monster
Eminem ft Rihanna
2013-11-04
Say Something
A Great Big World & Christina Aguilera
2013-12-17
Dark Horse
Katy Perry ft Juicy J
2014-07-28
Bang Bang
Jessie J, Ariana Grande, & Nicki Minaj
2014-09-30
Love Me Harder
Ariana Grande & The Weeknd
2015-02-10
Marvin Gaye
Charlie Puth ft Meghan Trainor
2015-03-02
Worth It
Fifth Harmony ft Kid Ink
2015-03-17
You Don't Own Me
Grace ft G-Eazy
2015-05-17
Bad Blood
Taylor Swift ft Kendrick Lamar
2015-06-23
Like I'm Gonna Lose You
Meghan Trainor ft John Legend
2015-07-22
Never Forget You
Zara Larsson & MNEK
2015-08-07
Body On Me
Rita Ora ft Chris Brown
2015-10-14
Me, Myself & I
G-Eazy & Bebe Rexha
2015-11-18
I Know What You Did Last Summer
Shawn Mendes & Camila Cabello
2015-12-17
Cheap Thrills
Sia ft Sean Paul
2016-03-25
Close
Nick Jonas ft Tove Lo
2016-07-29
Closer
The Chainsmokers ft Halsey
2016-08-30
Side to Side
Ariana Grande ft Nicki Minaj
2016-10-14
Bad Things
Machine Gun Kelly & Camila Cabello
2016-10-21
Rockabye
Clean Bandit ft Sean Paul & Anne-Marie
2016-11-18
No Lie
Sean Paul ft Dua Lipa
2017-03-17
Symphony
Clean Bandit ft Zara Larsson
2017-04-27
1-800-273-8255
Logic ft Alessia Cara & Khalid
2017-06-15
Feels
Calvin Harris ft Pharrell Williams, Katy Perry, & Big Sean
2017-06-15
Glorious
Macklemore ft Skylar Grey
2017-07-21
Back To You
Louis Tomlinson ft Bebe Rexha & Digital Farm Animals
2017-08-03
Havana
Camila Cabello ft Young Thug
2017-08-30
What Lovers Do
Maroon 5 ft SZA
2017-09-12
Best Friend
Sofi TuKKer ft Nervo, The Knocks, and Alisa Ueno
2017-09-15
Rockstar
Post Malone ft 21 Savage
2017-09-19
Good Old Days
Macklemore ft Kesha
2017-10-24
Meant To Be
Bebe Rexha ft Florida Georgia Line
2017-11-30
Him & I
G-Eazy & Halsey
2017-12-15
River
Eminem ft Ed Sheeran
2017-12-15
Like Home
Eminem ft Alicia Keys
2017-12-15
Tragic Endings
Eminem ft Skylar Grey
2017-12-15
Need Me
Eminem ft Pink
2018-01-04
All The Stars
Kendrick Lamar & SZA
2018-01-05
For You
Liam Payne & Rita Ora
2018-01-19
These Days
Rudimental ft Jess Glynne, Macklemore, and Dan Caplen
2018-01-23
The Middle
Zedd, Maren Morris, & Grey
2018-02-14
Love Lies
Khalid & Normani
2018-02-16
Mad Love
Sean Paul & David Guetta ft Becky G
2018-03-15
Alone
Halsey ft Big Sean and Stefflon Don
2018-03-27
Nowhere Fast
Eminem ft Kehlani
2018-05-31
Girls Like You
Maroon 5 ft Cardi B
2018-07-12
Eastside
Benny Blanco, Halsey, & Khalid
2018-08-16
Happier
Marshmello ft Bastille
2018-09-06
Electricity
Silk City & Dua Lipa ft Diplo & Mark Ronson
2018-09-18
This Feeling
The Chainsmokers ft Kelsea Ballerini
2018-09-27
Shallow
Lady Gaga & Bradley Cooper
2018-10-18
Sunflower
Post Malone & Swae Lee
2018-10-24
Close to Me
Ellie Goulding, Diplo, & Swae Lee
2018-11-02
Baby
Clean Bandit ft Marina & Luis Fonsi
2018-11-16
Rewrite The Stars
Anne-Marie & James Arthur
2019-01-11
Dancing With A Stranger
Sam Smith & Normani
2019-04-26
ME!
Taylor Swift ft Brendon Urie
2019-06-21
Señorita
Shawn Mendes & Camila Cabello
2019-07-05
Goodbyes
Post Malone ft Young Thug
2019-10-17
If the World Was Ending
JP Saxe ft Julia Michaels
2020-01-06
My Oh My
Camila Cabello ft DaBaby
2020-02-08
Death Bed (Coffee for Your Head)
Powfu ft beabadoobee
2020-04-17
I Hope
Gabby Barrett ft Charlie Puth
2020-06-25
Save Me
Jelly Roll ft Lainey Wilson
2020-07-06
Life's a Mess
Juice WRLD ft Halsey
2020-08-07
My Ex's Best Friend
Machine Gun Kelly ft blackbear
2020-09-18
Holy
Justin Bieber ft Chance The Rapper
2020-10-01
Levitating
Dua Lipa ft DaBaby
2020-10-16
Lonely
Justin Bieber ft Benny Blanco
2020-10-23
Lil Bit
Nelly & Florida Georgia Line
2020-12-04
Girl Like Me
Black Eyed Peas & Shakira
2020-12-04
Monsters
All Time Low ft Demi Lovato & blackbear
2021-01-07
Best Friend
Saweetie ft Doja Cat
2021-01-15
Friday
Riton and Nightcrawlers ft Mufasa & Hypeman
2021-02-19
la di die
Nessa Barrett ft jxdn
2021-03-03
Beautiful Mistakes
Maroon 5 ft Megan Thee Stallion
2021-03-05
Life's a Mess II
Juice WRLD ft Clever & Post Malone
2021-03-19
As I Am
Justin Bieber ft Khalid
2021-03-19
Peaches
Justin Bieber ft Daniel Caesar & GIVĒON
2021-03-19
Name
Justin Bieber ft Tori Kelly
2021-04-09
Kiss Me More
Doja Cat ft SZA
2021-04-16
You
Regard, Troye Sivan, & Tate McRae
2021-04-23
Save Your Tears
the Weeknd ft Ariana Grande
2021-05-21
Leave Before You Love Me
Marshmello & Jonas Brothers
2021-05-21
Our Song
Anne-Marie & Niall Horan
2021-06-17
Working
Tate McRae & Khalid
2021-06-25
You Right
Doja Cat & the Weeknd
2021-07-09
Memory
Kane Brown and Blackbear
2021-07-09
Stay
The Kid Laroi & Justin Bieber
2021-07-16
Wild Side
Normani ft Cardi B
2021-07-23
Psycho
Dixie D'Amelio ft Rubi Rose
2021-08-13
Rumors
Lizzo & Cardi B
2021-10-28
Enemy
Imagine Dragons and JID
2022-02-11
Calm Down
Rema ft Selena Gomez
2022-06-03
I Like You (A Happier Song)
Post Malone ft Doja Cat
2022-05-27
Potion
Calvin Harris, Dua Lipa, & Young Thug
2022-08-26
I'm Good (Blue)
David Guetta and Bebe Rexha
2023-02-24
Die For You
the Weeknd & Ariana Grande
2023-07-21
Heartbroken
Thomas Wesley (aka Diplo), Jessie Murph and Polo G
2023-10-06
Wild Ones
Jessie Murph and Jelly Roll
2024-04-19
Fortnight
Taylor Swift ft Post Malone
2024-04-26
II Most Wanted
Beyoncé and Miley Cyrus
2024-05-10
I Had Some Help
Post Malone ft Morgan Wallen
2024-05-10
Tonight
Black Eyed Peas and El Alfa ft Becky G
2024-08-16
Die with a Smile
Lady Gaga and Bruno Mars
x
-
+
~Pages~
<
o
>
Web
NAS






phpPgAdmin (download)
phpMyAdmin (download)
PHP Info (download)

MVR


20Q
x
-
+
Lamborghini
<
o
>
Lamborghini has an interesting history!

Models

x
-
+
2020 Summer Olympics (Sports)
<
o
>

Favorites
Aquatics
->
->
Duet
Aquatics
->
 
 
Athletics
->
 
 
Basketball
->
 
 
Canoeing
->
->
Kayak
Cycling
->
 
 
Gymnastics
->
->
Floor exercise
Gymnastics
->
->
Individual
Gymnastics
->
 
 
 
 
 
 
Surfing
->
 
 
Table tennis
->
 
 
Volleyball
->
 
 
New sports this Olympics: 3x3 basketball & Surfing shortboards
x
-
+
VMware ESXi Shell
<
o
>
esxcfg-info   # outputs lots of info (esxcfg-info --help)
esxcli   # prints helop
vim-cmd hostsvc/net/info | grep 'max = "'   # NIC's MAC address
vim-cmd vmsvc/getallvms   # list registered VMs
esxcli system version get   # version, etc
esxcli system stats installtime get   # installation date/time
esxcli network ip connection list   # status of active network connections
esxcli network nic list   # installed network adapters
esxcli network ip interface list   # network interfaces
esxcli network ip interface ipv4 get   # IP address details
esxcli vm process list   # running VMs
esxtop   # task manager

Most Useful ESXCLI and ESXi Shell Commands for Your VMware Environment
Top 20 Essential ESXCLI Commands You Need to Know
x
-
+
Phone Clips
<
o
>

Anna Kristina Theme.ogg

Complex.ogg

Egyptian Guitar.mp3

Extreme Alarm Clock.mp3

Gem Droids.ogg

Get Over Here.mp3

Grocery Bag Theme.ogg

Halloween Theme.mp3

Hey.mp3

Insomnia.mp3

Kill Bill Whistle.mp3

Looney Toons Theme.mp3

Machina.ogg

Momentum.ogg

Mom Mom Mom Mom.mp3

Moto.ogg

Need For Speed.mp3

Nuclear Alarm.mp3

Old Telephone.mp3

Pink Panther Theme.mp3

Reveille.mp3

Rocky Theme.mp3

Siren.mp3

Super Mario Bros.mp3

Techno.mp3

The Imperial March.mp3

Themos.ogg

The Terminator 2 Theme.mp3

THX.mp3

Transformers.mp3

Turkish Strings.mp3

Twilight Guitar.mp3

Whistle And Guitar.mp3
x
-
+
Wallpaper
<
o
>
x
-
+
DuckDuckGo
<
o
>
10101 binary to decimal
21 decimal to binary
1974 chinese zodiac
AAPL price
alarm
anagram panes
bitcoin price
calendar
calendar 1991-08-25
calendar 25 August 1991
calculator
chronometer
color #b06528
conversion
currency
define panes
expand https://amzn.to/3uylpmf
figlet panes
Gb/s
gold price
html chars
lowercase PANES
nasdaq: amd
password 8
password 8 strong
people in space
phoenix time
pi
portland time
qr http://www.panes.us
random number
random number between 1 and 1000
random passphrase
rhymes with panes
silver price
site:.us panes
stopwatch
uppercase panes
url decode http%3A%2F%2Fwww.panes.us%2F
url encode http://www.panes.us/
vim cheatsheet
Why should I use this?
x
-
+
Android Alternatives
<
o
>
x
-
+
LEGO
<
o
>

2022 Wish List
x
-
+
Bachelor Food
<
o
>
x
-
+
Foods (smoked)
<
o
>
x
-
+
Crawfish (boil)
<
o
>
x
-
+
Kombucha (brewing)
<
o
>
x
-
+
Server Naming Schemas
<
o
>
x
-
+
Simple Pleasures
<
o
>
x
-
+
Thanksgiving Food Favorites
<
o
>
x
-
+
Survival Items
<
o
>
x
-
+
Favorite Foods
<
o
>
x
-
+
Conversions
<
o
>
x
-
+
UNIX
<
o
>
Reasons to love UNIX:


Links to UNIX info:
x
-
+
Calendars and Date Formats/Utilities
<
o
>
x
-
+
Time Methods/Devices
<
o
>
x
-
+
WikipediA (2nd)
<
o
>
0
3M
BMW
BTS
Cay
G20
GNU
H&M
Ion
iOS
JBL
PHP
RCA
Roe
SQL
SZA
XFS
x
-
+
Samsung Gear S3 Frontier (faces 2)
<
o
>





x
-
+
Linux Distros
<
o
>
ubuntu
archlinux
linuxmint
fedora
KALI
debian
openSUSE
CentOS
ORACLE Linux
Rocky Linux
manjaro
almaLinux
Amazon Linux 2
Red Hat EL
CoNtRoL PaNeL
 Theme
 Color
 Paper
 Layout

 Sort
 Find

 Open
 Edit
 Delete


x
-
+
Help
<
o
>
x
-
+
To Do
<
o
>
x
-
+
Releases
<
o
>
x
-
+
X-Ray
<
o
>
x
-
+
My Sites
<
o
>
x
-
+
Notes
<
o
>
x
-
+
Timer
<
o
>
x
-
+
Media Player
<
o
>
x
-
+
Remote Control
<
o
>
© 2017-2024 panes.us