Harry Moreno

The thing about a lot of things is you only need one. You want a really really good one. One.

#sql http://www.craigkerstiens.com/2017/06/08/working-with-time-in-postgres/ … practical computer stuff

#devops host http://google.com  returns the ip address some url will resolve to, it's host #commandline

Every CS degree covers fancy data structures. But what trips up more programmers? Times. Dates. Floats. Non-English text. Currencies.

"In Buddhism, a sense of shame is the most important of all virtues since it leads to greater wisdom"

#commandline tr -cs "[:alpha]" "\n" < file | sort | uniq -c generates a list and count of words in a file #unixForPoets

#bash use tee to see output and pipe to a file http://www.linuxquestions.org/questions/linux-software-2/bash-how-to-redirect-output-to-file-and-still-have-it-on-screen-412611/ …

#sql https://en.wikipedia.org/wiki/Join_(SQL)#Outer_join … the full outer join https://pgexercises.com/questions/joins/self2.html … useful for optional or sparse relationships

Unix for Poets [pdf] must read #regex #commandline

#regex \b word boundary http://www.regular-expressions.info/wordboundaries.html … where ever word (\w) and nonword (\W) characters touch

"Cosette is an automated prover for checking equivalences of SQL queries." http://cosette.cs.washington.edu/  #coq #rosette #sql

#python [i for i in list if i.attribute == value] idomatic way of filtering a list

#sql #60daysOFsql the distinct clause http://devdocs.io/postgresql~9.5/queries-select-lists#QUERIES-DISTINCT … https://pgexercises.com/questions/joins/self.html …

#sql NATURAL JOINs are dangerous and therefore shouldn't be used https://en.wikipedia.org/wiki/Join_(SQL)#Natural_join …