Hello Simon. On Monday, May 14, 2018 at 6:15:50 PM UTC+1, Simon Charette wrote: > > > Is there a way to force Django to close the DB connection after each > operation (unless we're in an atomic block)? > > The only way I can think of achieving that is by bundling your own > database backend subclass > and override execute() and the cursor subclass to close the connection > when appropriate. >
Thanks for the suggestion, I will take a look at it. > Is there any reason you opted for an in-application connection pool > instead of using > pgbouncer or pgpool instead? > There are several reasons: - I would have to configure Django to open a new connection to the pooling component at each request and, well, we've moved past PHP at this time... :) - I have zero experience with either pgbouncer or pgpool, and they both seem to perform the same tasks, so it would be yet another decision that I would have to make and using only second-hand experience. In addition, none of them seem to have official Docker images. - Another component that I would have to manage, and I already have an sqlproxy component between Django and the DB when I need to access Cloud SQL instances in GCP. - Doubling of the number of connections of the server, the same amount of web client connections would be reflected in DB connections to the pooler component. - All in all IMO the connection pooling problem is better handled in process, and it's not rocket science, there are already libs for this, I'm just missing 10% help from Django. Thank you and best regards, André -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/52a479a3-ae6f-47ba-b55e-df590bf0b26f%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
