Skip to content

Instantly share code, notes, and snippets.


Shane Cooke githubber

View GitHub Profile
seven1m /
Last active Feb 7, 2021
List of Open Source Church Software
stephenlb / cryptoDashboard.html
Last active Dec 13, 2020
Realtime Ticker Price Changes for Ethereum, Bitcoin and Litecoin.
View cryptoDashboard.html
<!DOCTYPE html>
<title>Crypto Currency Prices</title>
<script src=""></script>
<script type="text/javascript" src=""></script>
<link type="text/css" rel="stylesheet" href=""/>
githubber /
Created Sep 16, 2016 — forked from n2j3/
simplified backup script utilising Fabrizi's dropbox uploader. Based on Dave Hope's backup script ( )
BACKUP_SRC="/root /etc /home"
MYSQL_USER="mysql username"
MYSQL_PASS="mysql password"
# Stop editing here.
NOW=$(date +"%Y.%m.%d")
dschneider / convert_utf8_to_utf8mb4
Created May 7, 2014
How to easily convert utf8 tables to utf8mb4 in MySQL 5.5
View convert_utf8_to_utf8mb4
# For each database:
ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
# For each table:
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
# For each column:
ALTER TABLE table_name CHANGE column_name column_name VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
# (Don’t blindly copy-paste this! The exact statement depends on the column type, maximum length, and other properties. The above line is just an example for a `VARCHAR` column.)
isaacs /
Last active Feb 15, 2021
Use one of these techniques to install node and npm without having to sudo. Discussed in more detail at Note: npm >=0.3 is *safer* when using sudo.
echo 'export PATH=$HOME/local/bin:$PATH' >> ~/.bashrc
. ~/.bashrc
mkdir ~/local
mkdir ~/node-latest-install
cd ~/node-latest-install
curl | tar xz --strip-components=1
./configure --prefix=~/local
make install # ok, fine, this step probably takes more than 30 seconds...
curl | sh