Skip to content

Instantly share code, notes, and snippets.

View leonhfr's full-sized avatar
🦡
working on a chess engine

léon h leonhfr

🦡
working on a chess engine
View GitHub Profile
@leonhfr
leonhfr / postgres-cheatsheet.md
Created December 12, 2023 23:17 — forked from Kartones/postgres-cheatsheet.md
PostgreSQL command line cheatsheet

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

  • -E: will describe the underlaying queries of the \ commands (cool for learning!)
  • -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

Reverse interview

Engineering

  1. What tech stack do you use? Are you rolling out new technologies or sunsetting older ones? Do you have any legacy system that you need to maintain?
  2. What is your maturity stage? Finding a direction, feature work, maintenance...
  3. What are the next big engineering challenges you will face?
  4. How are requirements delivered to the engineering teams? How are technical decisions made and communicated?
  5. What level of involvement do engineers have in relation to architecture and system design? How much freedom for decision making do individual developers have? What happens if an engineer identifies areas of improvement?
  6. What is the junior/senior balance of the team?
@leonhfr
leonhfr / cfoam
Created November 16, 2020 22:42
Foam commit
#!/bin/bash
INSIDE_GIT_REPO="$(git rev-parse --is-inside-work-tree 2>/dev/null)"
TODAY="$(date +'%Y-%m-%d')"
if [ ! "$INSIDE_GIT_REPO" ]; then
echo "Not in a git repository."
exit 1
fi