Add additional test cases for process management

[RealOrangeOne]

Fixes #59

Unfortunately, SQLite tests are now much slower, as they don't run in memory any more.

These process tests fail spectacularly on postgres, so more investigation is needed into why. It seems to impact unrelated tests, so it's likely something to do with connection management.