For most of us, interviewing is hard. And annoying, frustrating, and stressful. Most interviews these days consist of a string of 1-hour interviews covering:
A bookmarkable interface for executing read-only SQL queries against your database
This one is very much exposing my biases (I just released Django SQL Dashboard 1.0 which provides exactly this for Django+PosgreSQL projects) but having used this for the past few months I can’t see myself going back. Using bookmarked SQL queries to inform the implementation of new features is an incredible productivity boost. Here’s an issue I worked on recently with 18 comments linking to illustrative SQL queries.
G. Nelson, B. Xie, and A. Ko. Proceedings of the 2017 ACM Conference on International Computing Education Research, ACM, (August 2017)Understand code before write code - tracing and examples first.