$ psql postgres://user:pass@localhost:1337/dbname -o 'file.csv' -F , --no-align -c 'SELECT * FROM column ORDER BY created_at ASC;'
UPDATE "Jobs" SET "subscribers" = array_replace("subscribers", 'corbanb+plan@gmail.com', 'corbanb+plan2@gmail.com') WHERE "deletedAt" IS NULL AND 'corbanb+plan@gmail.com' = ANY ("subscribers")
| #/usr/bin/env bash | |
| # MIT © Sindre Sorhus - sindresorhus.com | |
| # git hook to run a command after `git pull` if a specified file was changed | |
| # Run `chmod +x post-merge` to make it executable then put it into `.git/hooks/`. | |
| changed_files="$(git diff-tree -r --name-only --no-commit-id ORIG_HEAD HEAD)" | |
| check_run() { | |
| echo "$changed_files" | grep --quiet "$1" && eval "$2" |
Below is a collection of links and tools used in my day to day life as a creative developer. There are a few stages of this from Frontend, Middleware, Database, Creative, DevOps and General Tools. This is intended to be a living document of these resources.
| 4r5e | |
| 5h1t | |
| 5hit | |
| God | |
| God damn | |
| Goddamn | |
| a55 | |
| a_s_s | |
| about | |
| account |
| # Opens the bitbucket page for the current git repository in your browser | |
| function bit() { | |
| giturl=$(git config --get remote.origin.url) | |
| if [ "$giturl" == "" ] | |
| then | |
| echo "Not a git repository or no remote.origin.url set" | |
| exit 1; | |
| fi |
| var App = App || {}; | |
| App.Helpers = App.Helpers || {}; | |
| (function($) { | |
| 'use strict'; | |
| App.Helpers.Numbers = { |
| <?php | |
| ini_set('auto_detect_line_endings',TRUE); | |
| $handle = fopen("mydata.csv", "r"); | |
| ?> | |
| <ul> | |
| <?php while ( ($data = fgetcsv($handle, 1000, ",")) !== FALSE ): ?> | |
| <li> | |
| <a href="<?= $data[4] ?>" class="product-container"> | |
| <img class="lazy" src="<?= $data[3] ?>" data-original="<?= $data[3] ?>"> | |
| <div class="post-details"> |
| worker_processes Integer(ENV['WEB_CONCURRENCY'] || 4) | |
| timeout 120 | |
| preload_app true | |
| listen ENV['PORT'].to_i || 3000, tcp_nopush: false | |
| before_fork do |server, worker| | |
| Signal.trap 'TERM' do | |
| puts 'Unicorn master intercepting TERM and sending myself QUIT instead' | |
| Process.kill 'QUIT', Process.pid |
| # More info - https://github.com/josegonzalez/homebrew-php#installing-multiple-versions | |
| # install multiple versions of php with homebrew | |
| brew tap josegonzalez/php | |
| brew install php53 --with-fpm | |
| brew install php54 --with-fpm | |
| brew install php55 --with-fpm | |
| # These are the aliases that will auto switch to the version you want to use. | |
| alias use_php53="brew unlink php54 && brew unlink php55 && brew unlink php53 && brew link php53" |
| [Mensch font](http://robey.lag.net/2010/06/21/mensch-font.html), | |
| [Webkit](http://webkit.org), | |
| [Chrome](http://google.com/chrome), | |
| [Firefox](http://firefox.com), | |
| [Kaleidoscope](http://www.kaleidoscopeapp.com), | |
| [iTerm](http://iterm2.com), | |
| [Transmit](http://panic.com/transmit), | |
| [Coda](http://panic.com/coda), | |
| [Sublime Text](http://www.sublimetext.com/dev), | |
| [Sequel Pro](http://nightly.sequelpro.com), |