Django Working with Databases

[stunstunstun]

Overview

lib/pq is an excellent Postgres driver written in pure Go, but it only offers support for the default Postgres timeouts of connect_timeout and statement_timeout. These work well, but in a high availability situation, they might not be enough. statement_timeout only works if the connection to Postgres is alive and well. connect_timeout only provides a timeout during initial connection. Once the connection is in the pool, connect_timeout doesn't apply. If the database goes down, or the network dies, the open connections will hang. Without a read or write timeout on the connection, there is no way to recover quickly. pq-timeouts provides a way to add a timeout to every write and read to and from the database.

AWS Elastic Beanstalk as Production

https://docs.aws.amazon.com/ko_kr/elasticbeanstalk/latest/dg/create-deploy-python-container.html

References

• https://hakibenita.com/9-django-tips-for-working-with-databases
• https://www.postgresql.org/docs/9.6/runtime-config-client.html#GUC-STATEMENT-TIMEOUT
• https://chrisjune-13837.medium.com/postgres%EC%99%80-django%EC%9D%98-connection-%EA%B4%80%EB%A6%AC-5acf3f5c28a7
• https://github.com/Kount/pq-timeouts