Stephen Margheim fractaledmind

Putting up a bounty didn't produce a solution to this, so I've spent a while figuring out the best one I could. I don't have any source confirming that this is the correct way to do it, so use at your own risk.

Solution

To convert any string into a SQLite identifier:

Ensure the string can be encoded as UTF-8.
Ensure the string does not include any NUL characters.
Replace all " with "".
Wrap the entire thing in double quotes.

Stevey's Google Platforms Rant

I was at Amazon for about six and a half years, and now I've been at Google for that long. One thing that struck me immediately about the two companies -- an impression that has been reinforced almost daily -- is that Amazon does everything wrong, and Google does everything right. Sure, it's a sweeping generalization, but a surprisingly accurate one. It's pretty crazy. There are probably a hundred or even two hundred different ways you can compare the two companies, and Google is superior in all but three of them, if I recall correctly. I actually did a spreadsheet at one point but Legal wouldn't let me show it to anyone, even though recruiting loved it.

I mean, just to give you a very brief taste: Amazon's recruiting process is fundamentally flawed by having teams hire for themselves, so their hiring bar is incredibly inconsistent across teams, despite various efforts they've made to level it out. And their operations are a mess; they don't real

Install ImageMagick for image conversion:

brew install imagemagick

Install tesseract for OCR:

brew install tesseract --all-languages

Or install without --all-languages and install them manually as needed.

tmux shortcuts & cheatsheet

start new:

tmux

start new with session name:

tmux new -s myname

	# Recursively diff two hashes, showing only the differing values.
	# By Henrik Nyh <http://henrik.nyh.se> 2009-07-14 under the MIT license.
	#
	# Example:
	#
	# a = {
	# "same" => "same",
	# "diff" => "a",
	# "only a" => "a",
	# "nest" => {

	var flattenObject = function(ob) {
	var toReturn = {};

	for (var i in ob) {
	if (!ob.hasOwnProperty(i)) continue;

	if ((typeof ob[i]) == 'object') {
	var flatObject = flattenObject(ob[i]);
	for (var x in flatObject) {
	if (!flatObject.hasOwnProperty(x)) continue;

	#!/bin/zsh

	# Global virtualenvwrapper postactivate, lives in $WORKON_HOME/postactivate

	# Remove virtual env from start of PS1 as it's in RPROMPT instead
	PS1="$_OLD_VIRTUAL_PS1"

	PROJECT_DIR="$HOME/projects/$(basename $VIRTUAL_ENV)"
	if [ -d $PROJECT_DIR ]; then
	# If we aren't already within the project dir, cd into it

	--
	-- OCR all documents added to a folder
	--
	on adding folder items to this_folder after receiving added_items
	try
	repeat with i from 1 to number of items in added_items
	set this_item to item i of added_items
	set appName to my getAppName()
	tell application appName
	activate

	import sys
	import os.path
	import datetime
	import codecs
	import sqlite3
	import codecs
	import getopt
	import datetime
	from optparse import OptionParser
	from xml.etree.ElementTree import Element,ElementTree,SubElement

	# textutil -convert html file.doc -stdout \| pandoc -f html -t markdown -o file.md

	see also: https://gist.github.com/2380036