IanColdwater

Mute these words in your settings here: https://twitter.com/settings/muted_keywords

ActivityTweet
generic_activity_highlights
generic_activity_momentsbreaking
RankedOrganicTweet
suggest_activity
suggest_activity_feed
suggest_activity_highlights
suggest_activity_tweet

ewhauser

SELECT
  FORMAT_DATE('%F', d) as id,
  d AS full_date,
  EXTRACT(YEAR FROM d) AS year,
  EXTRACT(WEEK FROM d) AS year_week,
  EXTRACT(DAY FROM d) AS year_day,
  EXTRACT(YEAR FROM d) AS fiscal_year,
  FORMAT_DATE('%Q', d) as fiscal_qtr,
  EXTRACT(MONTH FROM d) AS month,
  FORMAT_DATE('%B', d) as month_name,

ryantuck

fermi paradox

universe is huge

• 100b stars in milky way
• 100b galaxies in observable universe
• 10^22 stars available
• sun-like stars 5-20% (est 1%)
• possible earth-like planets 22-50% (est 10%)
• estimate 1% of earth-like planets develop life

Schniz

if exists("*ToggleBackground") == 0
	function ToggleBackground()
		if &background == "dark"
			set background=light
		else
			set background=dark
		endif
	endfunction

	command BG call ToggleBackground()

apolloclark

Postgres Cheatsheet

This is a collection of the most common commands I run while administering Postgres databases. The variables shown between the open and closed tags, "<" and ">", should be replaced with a name you choose. Postgres has multiple shortcut functions, starting with a forward slash, "". Any SQL command that is not a shortcut, must end with a semicolon, ";". You can use the keyboard UP and DOWN keys to scroll the history of previous commands you've run.

Setup

installation, Ubuntu

http://www.postgresql.org/download/linux/ubuntu/ https://help.ubuntu.com/community/PostgreSQL

lestoni

via (https://www.linux.com/learn/tutorials/442438-vim-tips-folding-fun)

• zf#j creates a fold from the cursor down # lines.
• zf/string creates a fold from the cursor to string .
• zj moves the cursor to the next fold.
• zk moves the cursor to the previous fold.
• zo opens a fold at the cursor.
• zO opens all folds at the cursor.
• zm increases the foldlevel by one.
• zM closes all open folds.