Good guidelines to improve end to end tests. I especially relate to the first one, the test API is very important for those, otherwise they become a chore to maintain and understand.

Interesting tips for potential bottlenecks in your queries.

Nice way to learn systemd uses.