Investigate options for managing psql connection and pools

[kylejb]

What

Investigate pros/cons to managing connections to psql ourselves instead of using AsyncSessionLocal from SQLAlchemy.

Is your feature request related to a problem? Please describe.

I'd like us to gracefully manage open connections/pools to the DB during the lifecycle of a request. FastAPI provides decorators for event listeners, which seems like a nice approach.

[kylejb]

Updates

Database class was introduced in #19 to help manage connection.

I'd like to investigate how it can be improved or if it's worth replacing with databases. Additionally, this file scaffolds functions that might be useful with FastAPI events.