Connection Management Best Practices

What are the best practices for managing our connections to the database? I'm unsure of how to manage these properly and the readme doesn't really provide much guidance on this. Currently I'm opening a connection, executing my query and then closing the connection. Is there a recommended way to handle eliminating this code duplication?