<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple Computer//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
<key>Label</key>
<string>localhost.pbcopy</string>
Patrick halbtuerke
jeremyjarrell
/ Idempotent migration in MySQL example
Created
July 25, 2013 20:06
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 |
burke
/ remotepaste.md
Last active
April 18, 2025 03:35
This sets up keybindings in tmux that allow you to copy/paste to/from your OS X clipboard from tmux running inside an SSH connection to a remote host. Partially borrowed from http://seancoates.com/blogs/remote-pbcopy
justinhj
/ git-add-dired.el
Created
July 7, 2013 21:28
Allows you to use dired to add multiple files to a git repository. This is useful since staging files in magit is sluggish and takes a long time when you have a lot of files.
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
| (defun git-add-files(files) | |
| "Run git add with the input file" | |
| (interactive) | |
| (shell-command (format "git add %s" files))) | |
| (defun dired-git-add-marked-files() | |
| "For each marked file in a dired buffer add it to the index" | |
| (interactive) | |
| (if (eq major-mode 'dired-mode) | |
| (let ((filenames (dired-get-marked-files)) |
tentacode
/ XSDValidator.php
Created
July 5, 2013 13:47
Super easy XML/XSD validator (require libxml)
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
| <?php | |
| namespace Tentacode\FilesystemBundle\XML; | |
| use DOMDocument; | |
| use XMLReader; | |
| class XSDValidator | |
| { | |
| protected $xmlFile; |
markjaquith
/ gist:5922095
Created
July 3, 2013 19:45
AppleScript for App Tamer that wakes Dropbox for 60 seconds, then sleeps it again. Note that you have to have enabled AutoStop for Dropbox already. Set this to run every X minutes on a cron, for fun and profit. Increase the delay if you think it will need more time to sync on a slow connection.
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
| tell application "App Tamer" | |
| wake "Dropbox" | |
| delay 60 | |
| # Hack to get App Tamer to sleep Dropbox again | |
| # There is no "sleep" verb ಠ_ಠ | |
| autostop false | |
| autostop true | |
| end tell |
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
| sudo find /private/var/folders/ -name com.apple.dock.iconcache -exec rm {} \; |
ttscoff
/ grab links.bookmarklet
Last active
February 20, 2025 09:55
Create a bookmark and paste the code from `grab links.bookmarklet` into the url. Trigger it on a page containing links you want to save and then click the section of the page containing the links. A Markdown list of all links will be generated, and clicking the resulting list will select all for copying.
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
| javascript:(function(){var p=document.createElement("p");p.innerHTML="<strong>Loading…</strong>";p.id="loadingp";p.style.padding="20px";p.style.background="#fff";p.style.left="20px";p.style.top=0;p.style.position="fixed";p.style.zIndex="9999999";p.style.opacity=".85";document.body.appendChild(p);document.body.appendChild(document.createElement("script")).src="https://gist.github.com/ttscoff/5834741/raw/grablinks.js?x="+(Math.random());})(); |
brentsimmons
/ gist:5810992
Last active
January 3, 2021 02:22
Detect a tap on a URL inside a UITextView. Note: the rs_links method isn't included -- you'll need something that takes text and returns an array of detected links. This gist just demonstrates walking through the UITextView characters.
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
| @implementation UITextView (RSExtras) | |
| static BOOL stringCharacterIsAllowedAsPartOfLink(NSString *s) { | |
| /*[s length] is assumed to be 0 or 1. s may be nil. | |
| Totally not a strict check.*/ | |
| if (s == nil || [s length] < 1) | |
| return NO; |
DivineDominion
/ com.brettterpstra.gitlogger.plist
Last active
December 26, 2021 17:59
— forked from ttscoff/gitlogger.rb
Logs selected git repository commits to a text file or Day One for the past day once in the morning.
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
| <?xml version="1.0" encoding="UTF-8"?> | |
| <!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"> | |
| <plist version="1.0"> | |
| <dict> | |
| <key>Label</key> | |
| <string>com.brettterpstra.gitlogger</string> | |
| <key>EnvironmentVariables</key> | |
| <dict> | |
| <key>LANG</key> | |
| <string>en_US.UTF-8</string> |
Each of these commands will run an ad hoc http static server in your current (or specified) directory, available at http://localhost:8000. Use this power wisely.
$ python -m SimpleHTTPServer 8000