get_db and Postgres.conf needs adjustments

[micahjohnson150]

After our first live run during hackweek we had a ton of issues with the database.

• max_connections was 100
• tcp_keepalives_idle 0

Still sorting through what else needs to be adjusted but this is the starting place. These eventually need to be added to the mod_conf.py script.

[micahjohnson150]

Maybe also add pool_pre_ping=True in the get_db functions (aka the pessimistic approach to connection viability) https://docs.sqlalchemy.org/en/14/core/pooling.html#disconnect-handling-pessimistic

[micahjohnson150]

@jomey I am keeping some list of improvements here.

[jomey]

Adding the discussed contextmanager idea:
https://docs.sqlalchemy.org/en/14/core/connections.html#basic-usage

[jomey]

@micahjohnson150 - Sounds like this issue should be transferred to the snowexdb repo?
Also, the API class that handles the connection should be a big difference maker

[micahjohnson150]

Yep!