Tony Pitale tpitale

Sublime Text 4 & Elixir LSP

Install packages

Make sure you have Package Control installed first.
Install the latest versions of:
- https://github.com/sublimelsp/LSP
- https://github.com/elixir-editors/elixir-tmbundle

I'd like to share some git aliases that you might find useful if you handle pull requests from others.

Add these to your ~/.gitconfig in the [alias] section:

copr = "!f() { git fetch -fu origin refs/pull/$1/head:pr-$1; git checkout pr-$1; } ; f"
prunepr = "!git for-each-ref refs/heads/pr-* --format='%(refname:short)' | while read ref ; do git branch -D $ref ; done"

Now you can "git copr #{pr_number}" (check out pull request is the mnemonic) and it will pull down the PR in a local branch of pr-#{pr_number} and check it out for you. To do it right, you must pronounce it "Copper" with a James Cagney gangster accent.

Go to Tools > New Plugin
Paste timestamp.py contents and save in User as timestamp.py
Open Preferences > Key Bindings - User (or Default, your call)
Paste keybindings.json, or add a line to your keybindings
Customize the keyboard shortcut to your liking and save

	letter	frequency
	A	.08167
	B	.01492
	C	.02782
	D	.04253
	E	.12702
	F	.02288
	G	.02015
	H	.06094
	I	.06966

SQL for reporting queries

Datatypes: JSON, HLL

JSON

http://www.postgresql.org/docs/9.3/static/functions-json.html

	def wait_for_notify(&block)
	io = pg_connection.socket_io

	while @listening do
	Celluloid::IO.wait_readable(io) # blocks execution, but unblocks this actor
	pg_connection.consume_input # fetch any input on this connection

	# read the NOTIFY messages off the socket
	while notification = pg_connection.notifies do
	block.call(

	<html>
	<head>
	<style type="text/css">
	table table {
	width: 600px !important;
	}
	table div + div { /* main content */
	width: 65%;
	float: left;
	}

	SELECT created_on, note_count, sum(note_count) OVER (ORDER BY created_on ASC)
	FROM (
	SELECT date_trunc('day', created_at) AS created_on, count(1) AS note_count
	FROM notes
	GROUP BY created_on
	ORDER BY created_on DESC
	) AS note_counting;
	-- WHERE created_on >= '2013-01-01'

	# /etc/init/ruby-example-upstart.conf

	description "Ruby example upstart conf"

	# change to the user you want to run this ruby script as
	setuid deploy
	setgid deploy

	# This starts upon bootup and stops on shutdown
	# check runlevel of running system with `runlevel` command

	import os; path=sublime.packages_path(); (os.makedirs(path) if not os.path.exists(path) else None); window.run_command('exec', {'cmd': ['git', 'clone', 'https://github.com/titoBouzout/SideBarEnhancements', 'SideBarEnhancements'], 'working_dir': path})

	import os; path=sublime.packages_path(); window.run_command('exec', {'cmd': ['git', 'checkout', '37429739a0452a2dc36343fb7875ba7fcbeb88a9'], 'working_dir': os.path.join(path, 'SideBarEnhancements')})