Author here. I am curious, what kind of tricks do you apply that are similar to connection naming?
Other options I know about:
1. Using an own username per application
2. Adding comments into every database query
Let me know what you think about all this.