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.
M. Liffiton, B. Sheese, J. Savelka, and P. Denny. Proceedings of the 23rd Koli Calling International Conference on Computing Education Research, page 1–11. New York, NY, USA, Association for Computing Machinery, (Feb 6, 2024)
B. Jury, A. Lorusso, J. Leinonen, P. Denny, and A. Luxton-Reilly. Proceedings of the 26th Australasian Computing Education Conference, page 77–86. New York, NY, USA, Association for Computing Machinery, (Jan 29, 2024)
J. Savelka, A. Agarwal, M. An, C. Bogart, and M. Sakr. Proceedings of the 2023 ACM Conference on International Computing Education Research - Volume 1, volume 1 of ICER '23, page 78–92. New York, NY, USA, Association for Computing Machinery, (Sep 10, 2023)
S. Sarsa, P. Denny, A. Hellas, and J. Leinonen. Proceedings of the 2022 ACM Conference on International Computing Education Research - Volume 1, page 27-43. ACM, (August 2022)
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.