Blog

Intermediate SQL: WHERE vs HAVING

Recently, at Work I gave an introductory SQL tutorial. Since the purpose of the tutorial was to teach SQL for the purpose of answering questions about groupings of data, the tutorial ultimately reached a discussion of WHERE versus HAVING. I thought I'd share the explanation I used in case others felt confused why SQL has two keywords that serve such a similar function.

Looking for .git in all the wrong places

Like many of you, I store my dotfiles in Git repos. However, I quickly encountered a problem with this approach: my configurations would often get out of sync between my various machines. Instead of writing a script to check for updates or just being diligent about it, I decided that I would integrate my configurations into something on my machines that check for updates already: the system package manager!

Know your tools: using inputrc to save keystrokes in the MySQL shell

I do a lot of work with MySQL, and I often bemoan the lack of a concise shortcut to list tables matching a pattern. I much prefer psql's \d shortcut as opposed to mysql's SHOW TABLES. However, since the mysql client uses GNU readline, we can leverage readline's macro facility to make things easier on ourselves!

What I Learned Writing a Dropbox Clone - Part 4 - Conclusion

These posts are largely independent of each other, but if you'd like some context, you should probably read the first post.

What I Learned Writing a Dropbox Clone - Part 3 - Inotify