start new:
tmux
start new with session name:
tmux new -s myname
blackcow02
blackcow02
/ tmux-cheatsheet.markdown
Created
October 24, 2022 19:35
— forked from MohamedAlaa/tmux-cheatsheet.markdown
tmux shortcuts & cheatsheet
blackcow02
/ Idempotent migration in MySQL example
Created
October 19, 2022 19:52
— forked from jeremyjarrell/Idempotent migration in MySQL example
In MySQL, IF statements cannot exist outside of stored procedures. Therefore, to create an idempotent migration for MySQL it's necessary to wrap the migration in a stored procedure and execute that stored procedure against the database to perform the migration.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DELIMITER $$ | |
| DROP PROCEDURE IF EXISTS add_email_address_column_to_customers_table $$ | |
| -- Create the stored procedure to perform the migration | |
| CREATE PROCEDURE add_email_address_column_to_customers_table() | |
| BEGIN | |
| -- Add the email_address column to the customers table, if it doesn't already exist |
blackcow02
/ MySQL Timezone Cheatsheet.md
Created
January 12, 2022 15:57
— forked from suvozy/MySQL Timezone Cheatsheet.md
It seems that it does not matter what timezone is on the server as long as you have the time set right for the current timezone, know the timezone of the datetime columns that you store, and are aware of the issues with daylight savings time.
On the other hand if you have control of the timezones of the servers you work with then you can have everything set to UTC internally and never worry about timezones and DST.
Here are some notes I collected of how to work with timezones as a form of cheatsheet for myself and others which might influence what timezone the person will choose for his/her server and how he/she will store date and time.
blackcow02
/ .gitattributes
Created
April 15, 2021 13:27
— forked from Voonder/.gitattributes
Sample of git config file (Example .gitconfig, .gitattributes, .gitignore)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Auto detect text files and perform LF normalization | |
| * text=auto | |
| # Documents | |
| *.doc diff=astextplain | |
| *.DOC diff=astextplain | |
| *.docx diff=astextplain | |
| *.DOCX diff=astextplain | |
| *.dot diff=astextplain | |
| *.DOT diff=astextplain |
blackcow02
/ ultimate-ut-cheat-sheet.md
Created
January 3, 2017 17:48
— forked from yoavniran/ultimate-ut-cheat-sheet.md
The Ultimate Unit Testing Cheat-sheet For Mocha, Chai and Sinon
using mocha/chai/sinon for node.js unit-tests? check out my utility: mocha-stirrer to easily reuse test components and mock require dependencies