stephenhardy

"##############################################################################
"# My additions and configurations below
"##############################################################################

set nocompatible

" Remove any chrome, toolbars etc
if has("gui_running")
  set guioptions-=m
  set guioptions-=T

stephenhardy

{
    "cmd": ["open", "-a", "Google Chrome", "$file"]
}

stephenhardy

I wrote this in early January 2012, but never finished it. The research and thinking in this area led to a lot of the design of Yeoman and talks like "Javascript Development Workflow of 2013", "Web Application Development Workflow" and "App development stack for JS developers" (surpisingly little overlap in those talks, btw).

Now it's June 2013 and the state of web app tooling has matured quite a bit. But here's a snapshot of the story from 18 months ago, even if a little ugly and incomplete. :p

---

In the beginning…

• Intro to tooling

stephenhardy

@Grab(group = 'com.fasterxml.jackson.dataformat', module= 'jackson-dataformat-csv', version = '2.3.0')
import com.fasterxml.jackson.annotation.JsonProperty
import com.fasterxml.jackson.annotation.JsonCreator
import com.fasterxml.jackson.annotation.JsonPropertyOrder
import com.fasterxml.jackson.core.JsonFactory
import com.fasterxml.jackson.dataformat.csv.CsvMapper
import com.fasterxml.jackson.dataformat.csv.CsvSchema
import com.fasterxml.jackson.databind.MappingIterator
import com.fasterxml.jackson.databind.ObjectMapper
import com.fasterxml.jackson.databind.ObjectWriter

stephenhardy

mysqldump -u username -p --default-character-set=utf8 --result-file=dumpFile.sql databaseName

stephenhardy

SELECT DISTINCT TABLE_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('columnA','ColumnB')
        AND TABLE_SCHEMA='YourDatabase';

stephenhardy

:%s/findme/replaceme/g

stephenhardy

select
    t.name table_name
from
    sys.tables t
    join sys.schemas s on (t.schema_id = s.schema_id)
    join sys.partitions p on (t.object_id = p.object_id)
where p.index_id in (0,1)
group by t.name,s.name
having sum(p.rows) = 0;

stephenhardy

openssl rand -base64 20

stephenhardy

To remote
-----------
rsync -azP  file username@remote_host:/home/dir/file


From remote
-------------
rsync -azP username@remote_host:/home/dir/file file