Haelle

select pid, usename, pg_blocking_pids(pid) as blocked_by, query as blocked_query
from pg_stat_activity
where cardinality(pg_blocking_pids(pid)) > 0;

Haelle

Commands:

• docker ps : list running containers (option -a exited ones)
• docker run <image name> : run/install docker image ; options :
  • it : interactive
  • --rm : delete container after it stops
  • --mount type=bind,source=$(pwd),destination=/src : mount current dir to /src on the container
• docker rm <id|name> : delete container
• docker diff <id|name> : show diff made in this image
• docker system df: show space taken by docker

Haelle

SELECT
    table_name,
    pg_size_pretty(table_size) AS table_size,
    pg_size_pretty(indexes_size) AS indexes_size,
    pg_size_pretty(total_size) AS total_size
FROM (
    SELECT
        table_name,
        pg_table_size(table_name) AS table_size,
        pg_indexes_size(table_name) AS indexes_size,

Haelle

The Scene View

Transform tools

• a - Hand tool :

  • hold click to move around

• z - manipulate GameObjects on axis

• e - manipulate GameObjects on rotations

• r - manipulate GameObjects on scales

• t - rectTranform for UI

Haelle

Checklists for Software Development

Patrick Joyce - pragmati.st/checklists

Before Submitting a Pull Request

THE SUBMITTER SHOULD ALWAYS ASK THEMSELVES THE FOLLOWING QUESTIONS:

• Have I looked at every line of the diff between your branch and master?
• Is there anything in this patch that is not related to the overall change?
• Have I structured the commits to make the reviewer’s job easy?
• Have I tested the code locally?
• Should QA look at this before I submit it for review?