Abel Martin abelmartin

## gist:e90f80c60fa7e1bd5e36174fbb651cb6

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                abelmartin
                / gist:e90f80c60fa7e1bd5e36174fbb651cb6
            
            
              Created
              December 19, 2017 05:36
                — forked from jordelver/gist:5617879
            
              
                Spell check entire codebase
              
          
    Spell check entire codebase

Requires aspell. Install using brew install aspell on Mac OS X.
From STDIN

cat *.txt | aspell -l EN-US --mode=tex list

Whole directory


## gist:4926ffb9bb4589ab2d48bd868e10f423
KEYBINDINGS
       byobu keybindings can be user defined in /usr/share/byobu/keybindings/ (or within .screenrc if byobu-export was used). The  common  key  bindings
       are:

       F2 - Create a new window

       F3 - Move to previous window

       F4 - Move to next window

## postgres_queries_and_commands.sql
-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(query_start, clock_timestamp()), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

## fft.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                abelmartin
                / fft.md
            
            
              Last active
              January 16, 2017 00:21
            
              
                Final Fantasy Tactics builds
              
          
    http://finalfantasy.wikia.com/wiki/List_of_Final_Fantasy_Tactics_jobs
Martin: => Dark Knight

 Monk: 5/5
 Geomancer: 8/8
 Archer: 4/4
 Thief: 5/5
 Ninja: 8/8
 Dragoon: 8/8
 Knight: not mastered


## mongodb.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                abelmartin
                / mongodb.md
            
            
              Created
              December 6, 2016 19:25
            
              
                #mongodb cheat sheet
              
          
    MongoDB cheat sheet

Overview

Overview
MongoDB is a document database that provides high performance, high availability, and easy scalability.

Document Database


## postgres-cheatsheet.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                abelmartin
                / postgres-cheatsheet.md
            
            
              Created
              October 26, 2016 00:14
                — forked from Kartones/postgres-cheatsheet.md
            
              
                PostgreSQL command line cheatsheet
              
          
    PSQL

Magic words:
psql -U postgres
If run with -E flag, it will describe the underlaying queries of the \ commands (cool for learning!).
Most \d commands support additional param of __schema__.name__ and accept wildcards like *.*

  
## gist:be7b11c16e9c4b9533e2b83994cfe997
Movies:
Atonement
Old boy

## ahub-notes.txt
If you try to delete a deleted thing:
=> 401 Unauthorized: <html>
<head>
    <title>Permission Denied</title>
</head>
<body>
<content tag="hideAsk"></content>
<content tag="fullWidth"></content>
<h1>Access Denied</h1>
We're sorry, but you do not have permission to do the activity you attempted.  If you believe this to be in error, please contact the site administrator(s).</body>

## updates.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                abelmartin
                / updates.md
            
            
              Last active
              October 21, 2015 21:17
            
              
                10.9.x upgrade to 10.10.5 or 10.11
              
          
    BEFORE YOU UPGRADE!


pg_dumpall > outputfile

Brew


Run brew update twice

Databases

Postgres 9.3.4 to 9.4.4


brew upgrade postgresl
http://stackoverflow.com/a/26001639/36308 to resolve pg_tblspc missing


## SassMeister-input.scss
// ----
// Sass (v3.4.3)
// Compass (v1.0.1)
// ----

$pink: #f24;
$blue: #456;
$red: #808;

$colors: (pink: $pink, blue: $blue, red: $red);
	KEYBINDINGS
	byobu keybindings can be user defined in /usr/share/byobu/keybindings/ (or within .screenrc if byobu-export was used). The common key bindings
	are:

	F2 - Create a new window

	F3 - Move to previous window

	F4 - Move to next window
	-- show running queries (pre 9.2)
	SELECT procpid, age(query_start, clock_timestamp()), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(query_start, clock_timestamp()), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
	If you try to delete a deleted thing:
	=> 401 Unauthorized: <html>
	<head>
	<title>Permission Denied</title>
	</head>
	<body>
	<content tag="hideAsk"></content>
	<content tag="fullWidth"></content>
	<h1>Access Denied</h1>
	We're sorry, but you do not have permission to do the activity you attempted. If you believe this to be in error, please contact the site administrator(s).</body>
	// ----
	// Sass (v3.4.3)
	// Compass (v1.0.1)
	// ----

	$pink: #f24;
	$blue: #456;
	$red: #808;

	$colors: (pink: $pink, blue: $blue, red: $red);