Fred Liang ilstar

## gist:6b1bcaf7724dfc2a54f3
WITH table_scans as (
    SELECT relid,
        tables.idx_scan + tables.seq_scan as all_scans,
        ( tables.n_tup_ins + tables.n_tup_upd + tables.n_tup_del ) as writes,
                pg_relation_size(relid) as table_size
        FROM pg_stat_user_tables as tables
),
all_writes as (
    SELECT sum(writes) as total_writes
    FROM table_scans

## New New Index Bloat Query
WITH btree_index_atts AS (
    SELECT nspname, relname, reltuples, relpages, indrelid, relam,
        regexp_split_to_table(indkey::text, ' ')::smallint AS attnum,
        indexrelid as index_oid
    FROM pg_index
    JOIN pg_class ON pg_class.oid=pg_index.indexrelid
    JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace
    JOIN pg_am ON pg_class.relam = pg_am.oid
    WHERE pg_am.amname = 'btree'
    ),

## anonymous
/System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/LaunchServices.framework/Versions/A/Support/lsregister -kill -r -domain local -domain system -domain user  && killall Finder

## Changes in Rails 4_1.md

      
              3 files
            
          
              54 forks
            
          
              29 comments
            
          
              228 stars
            
          
                nightire
                / Changes in Rails 4_1.md
            
            
              Last active
              May 11, 2022 04:50
            
              
                拥抱 Rails 4 —— 详述 Rails 4 的新变化
              
          
    Routes

小心地使用 Match（Rails 3 已实现）

Rails 3 提供了 match 方法供我们自定义 routes，然而我们要小心使用它以避免“跨站脚本攻击”（XSS Attack）。比如像这样的 routes：
注：（r3 代表 Rails 3，r4 代表 Rails 4）
# routes.rb

  
## heroku-CVE-2013-0156.rb
## The quick-and-nasty CVE-2013-0156 Heroku inspector!
## Originally brought to you by @elliottkember with changes by @markpundsack @ Heroku
## Download and run using:
## ruby heroku-CVE-2013-0156.rb

`heroku list`.split("\n").each do |app|
  app = app.strip

  # Some "heroku apps" lines have === formatting for grouping. They're not apps.
  next if app[0..2] == "==="

## enc_dec_test.py
"""
Dependencies:
    pip install tabulate simplejson ujson yajl msgpack
"""

from timeit import timeit
from tabulate import tabulate

setup = '''d = {
    'words': """

## rspec_rails_cheetsheet.rb
#Model

@user.should have(1).error_on(:username) # Checks whether there is an error in username
@user.errors[:username].should include("can't be blank")  # check for the error message

#Rendering
response.should render_template(:index)

#Redirecting
response.should redirect_to(movies_path)

## app.coffee
class App
  express = require 'express'
  redis = require 'redis'
  RedisStore = require('connect-redis')(express)
  sessionStore = new RedisStore()

  # These will be used only on ioController()
  fs = require 'fs'
  parseCookie = require('connect').utils.parseCookie

## 12306AutoLogin.user.js
/*
		12306 Auto Login => A javascript snippet to help you auto login 12306.com.
		Copyright (C) 2011 Kevintop

		Includes jQuery
		Copyright 2011, John Resig
		Dual licensed under the MIT or GPL Version 2 licenses.
		http://jquery.org/license

		Includes 12306.user.js

## gist:1207002

      
              1 file
            
          
              804 forks
            
          
              81 comments
            
          
              2097 stars
            
          
                lucasfais
                / gist:1207002
            
            
              Created
              September 9, 2011 18:46
            
              
                Sublime Text 2 - Useful Shortcuts
              
          
    Sublime Text 2 – Useful Shortcuts (Mac OS X)

General


		 ⌘T 
		 go to file 
	
	
		 ⌘⌃P 
		 go to project 
	
	
		 ⌘R 
		 go to methods 
	
	
		 ⌃G 
		 go to line 
	
	
		 ⌘KB 
		 toggle side bar 
	
	
		 ⌘⇧P 
		 command prompt
	WITH table_scans as (
	SELECT relid,
	tables.idx_scan + tables.seq_scan as all_scans,
	( tables.n_tup_ins + tables.n_tup_upd + tables.n_tup_del ) as writes,
	pg_relation_size(relid) as table_size
	FROM pg_stat_user_tables as tables
	),
	all_writes as (
	SELECT sum(writes) as total_writes
	FROM table_scans
	WITH btree_index_atts AS (
	SELECT nspname, relname, reltuples, relpages, indrelid, relam,
	regexp_split_to_table(indkey::text, ' ')::smallint AS attnum,
	indexrelid as index_oid
	FROM pg_index
	JOIN pg_class ON pg_class.oid=pg_index.indexrelid
	JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace
	JOIN pg_am ON pg_class.relam = pg_am.oid
	WHERE pg_am.amname = 'btree'
	),
	## The quick-and-nasty CVE-2013-0156 Heroku inspector!
	## Originally brought to you by @elliottkember with changes by @markpundsack @ Heroku
	## Download and run using:
	## ruby heroku-CVE-2013-0156.rb

	`heroku list`.split("\n").each do \|app\|
	app = app.strip

	# Some "heroku apps" lines have === formatting for grouping. They're not apps.
	next if app[0..2] == "==="
	"""
	Dependencies:
	pip install tabulate simplejson ujson yajl msgpack
	"""

	from timeit import timeit
	from tabulate import tabulate

	setup = '''d = {
	'words': """
	#Model

	@user.should have(1).error_on(:username) # Checks whether there is an error in username
	@user.errors[:username].should include("can't be blank") # check for the error message

	#Rendering
	response.should render_template(:index)

	#Redirecting
	response.should redirect_to(movies_path)
	class App
	express = require 'express'
	redis = require 'redis'
	RedisStore = require('connect-redis')(express)
	sessionStore = new RedisStore()

	# These will be used only on ioController()
	fs = require 'fs'
	parseCookie = require('connect').utils.parseCookie
	/*
	12306 Auto Login => A javascript snippet to help you auto login 12306.com.
	Copyright (C) 2011 Kevintop

	Includes jQuery
	Copyright 2011, John Resig
	Dual licensed under the MIT or GPL Version 2 licenses.
	http://jquery.org/license

	Includes 12306.user.js
⌘T	go to file
⌘⌃P	go to project
⌘R	go to methods
⌃G	go to line
⌘KB	toggle side bar
⌘⇧P	command prompt