Skip to content

Instantly share code, notes, and snippets.

View SteveByerly's full-sized avatar

Steve Byerly SteveByerly

  • Metis Genetics
  • Spokane, WA
View GitHub Profile
@SteveByerly
SteveByerly / interview-questions.md
Created July 13, 2021 18:10 — forked from jvns/interview-questions.md
A list of questions you could ask while interviewing

A lot of these are outright stolen from Edward O'Campo-Gooding's list of questions. I really like his list.

I'm having some trouble paring this down to a manageable list of questions -- I realistically want to know all of these things before starting to work at a company, but it's a lot to ask all at once. My current game plan is to pick 6 before an interview and ask those.

I'd love comments and suggestions about any of these.

I've found questions like "do you have smart people? Can I learn a lot at your company?" to be basically totally useless -- everybody will say "yeah, definitely!" and it's hard to learn anything from them. So I'm trying to make all of these questions pretty concrete -- if a team doesn't have an issue tracker, they don't have an issue tracker.

I'm also mostly not asking about principles, but the way things are -- not "do you think code review is important?", but "Does all code get reviewed?".

@SteveByerly
SteveByerly / debug-process_activity.sql
Last active November 15, 2022 20:32
postgresql utils
/*
* Current activity of all server processes
*/
SELECT
pid
, query
, application_name
, usename AS user_name
, state
, wait_event_type