BowerStudios.com

This is great for making daily backups of your database, so that you can roll back to a known config.

Install
Use homebrew to install it.
brew install automysqlbackup

The config file is in /usr/local/etc/automysqlbackup/automysqlbackup.conf
You'll want to modify the excludes line to contain the following:
CONFIG_db_exclude=( 'information_schema' 'performance_schema' 'mysql')

create the directory /usr/local/var/backup:
mkdir -p /usr/local/var/backup

Usage
You can run manually with:
automysqlbackup

The databases should be saved to
cd /usr/local/var/backup/db
Optional: The "tree" command can be useful exploring that directory at the command line. You might need to install it via brew as well.

Generally, you can load those backups by first unzipping:
gunzip mydb_2018_04-04_10h00m.Friday.sql.gz

and then you can load it:
mysql < mydb_2018_04-04_10h00m.Friday.sql
or, with a password:
mysql -u myusername --password=THE_PASSWORD_GOES_HERE < mydb_2018_04-04_10h00m.Friday.sql

If the database already exists, you'll need to remove it.

Scheduling
Verify it is loaded in the mac scheduler with:
launchctl list | grep homebrew
Macs don't really use cron. They favor launchctl.

If it isn't there, you may need to copy:
cp /usr/local/Cellar/automysqlbackup/3.0-rc6/homebrew.mxcl.automysqlbackup.plist ~/Library/LaunchAgents
and then
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.automysqlbackup.plist

From Baeldung.com

Logback has an interesting feature for following a flow through a system: Mapped Diagnostic Contexts

Rubber Duck Debugging Bot

It is based on the elizabot by Joseph Weizenbaum. User mohlendo has a wrapper for hubot on Github

If you want to test what your rails app does when it hits a rails exception, one thing you can do is the following. Change the query slightly:
myDomainObj.where(my_param: "myval")
to:
myDomainObj.execute("SIGNAL SQLSTATE 'ERROR'")

Paypal

Bluesnap

Attach the contents of 1.txt as json to send to a url:
curl --data "@1.txt" -v -H "Content-Type: application/json" https://myapp.com

Grab 10,000 lines after matching, and then look only at the given thread
grep -A 10000 "09:55:.*My API endpoint.*ProviderSearch" myLog.log | grep pool-2-thread-28166

Big Deletes by Rick James

Mysql Internal Locking

View processes locking tables in Mysql

Create temporary tables in mysql

Getting the disk size of a table in mysql

Specifying index to use for a query in mysql

Interpreting Explain Query output in mysql

Performing online updates with mysql

From stackoverflow

Boils down to adding a couple of Java switches to the start script:
-Dswing.plaf.metal.controlFont=Tahoma-18 -Dswing.plaf.metal.userFont=Tahoma-18

For example, in squirrel-sql.sh, modify this line to include the above:
$JAVACMD -Xmx256m -Dswing.plaf.metal.controlFont=Tahoma-24 -Dswing.plaf.metal.userFont=Tahoma-24 -cp "$TMP_CP" $MACOSX_SQUIRREL_PROPS -splash:icons/splash.jpg net.sourceforge.squirrel_sql.client.Main --log-config-file "$UNIX_STYLE_HOME"/log4j.properties --squirrel-home "$UNIX_STYLE_HOME" $NATIVE_LAF_PROP $SCRIPT_ARGS

• Redis Datatypes
• Redis Cheatsheet by LeCoupa

  Command	Description
  redis-cli	redis client executable
  info	display info about redis
  info keyspaces	show databases equiv
  select [num]	Use database equiv
  keys [pattern / *]	List keys in db
  set [key value]
  get [key]
  mget [keys...]
  incr [key]
  incrBy [key incrementVal]
  decr [key]
  decrby [key decrementVal]
  del [key]
  ttl [key]
  expire [key seconds]