Posts in talk

Vim Send Text

https://raw.githubusercontent.com/ddrscott/vim-islime2/gh-pages/demo.gif" title="‘Vim Send Text Demo’" >

After pairing with some Sublime users, I noticed a neat feature. Or more accurately, they were rubbing it in my face that their cute editor was better than mine. The feature was SendText. Well, I couldn’t let Sublime users have all the fun, and apparently neither could a few other people.

written in talk, vim Read on →

What the SQL?!? WINDOW

Today’s “What the SQL?!?” features the keyword WINDOW. This clause allows us to elegantly select results from the previous results from the previous results from the previous results…

written in sql, talk Read on →

What the SQL?!? Recursive

Today’s “What the SQL?!?” features the keyword RECURSIVE. This clause allows us to elegantly select results from the previous results from the previous results from the previous results…

written in sql, talk Read on →

What the SQL?!? Lateral Joins

Today’s “What the SQL?!?” features the keyword LATERAL. A prerequisite to understanding lateral joins are regular joins and subqueries. I’ll explain those briefly to see how LATERAL can simplify a complicated SQL query.

written in sql, talk Read on →